Which standard is used for converting the keystroke into the corresponding bits? a) ASCII b) EBCDIC c) ANSI d) ISO

Answer= ASCII The “ASCII”, short for “American Standard Code for Information Interchange”, is a “character encoding standard” format for electronic communication. “ASCII” codes represent characters in “computers, telecommunications units”, and other devices. The “ASCII” is a standard which assigns “alphabets, numbers, and other special characters” in the slots available in the form of an “8-bit code”. The “ASCII number system” is created from the binary system, which is the “language of all computers”.

Electronic Spreadsheet is also known as a) Data Processor b) Word Processor c) Presentation Package d) None of above

Answer= None of above Electronic Spread sheet is also known as Worksheet.

What is the another name for programmed chip? a) RAM b) ROM c) LSCI d) PROM

Answer=ROM ROM is the other name of programmed chip. Programmable read-only memory (PROM), or one-time programmable ROM (OTP), can be written to or programmed via a special device called a PROM programmer. Typically, this device uses high voltages to permanently destroy or create internal links (fuses or antifuses) within the chip. Once data has been written onto a ROM chip, it cannot be removed and can only be read. Unlike main memory (RAM), ROM retains its contents even when the computer is turned off. ROM is referred to as being nonvolatile, whereas RAM is volatile.

Ms Access-4

Ms Access-4

MS-Access lets users link to data in its current location and use the information for viewing, querying, updating, and reporting. It's simple to install and easy to understand. It lets users create tables, forms, queries, and reports and connect with the aid of Macros.

1. In which of the following view, you can’t change the table data?

(A) Pivot table view

(B) Datasheet view

(C) Design view

(D) Both (a) and (b)

2. declarations stored as one unit.

(A) Tables

(B) Reports

(D) Modules

3. Which of the following database object hold data?

(A) Forms

(B) Reports

(C) Tables

(D) Queries

4. This is the stage in database design where one gathers and lists all the necessary fields for the database project.

(A) Data Definition

(B) Data Refinement

(D) All of these

5. Which action will optimize your database performance?

(A) Set the record set type of Snapshot

(B) Use the compact and repair database tool

(D) All of the above

6. To toggle the Navigation Pane, press

(A) F1

(B) F2

(D) F11

7. In Access, this operation copies a backup file from the storage medium back onto the computer

(A) Restore

(B) Recreate

(D) Structure

8. Which of the following Data Type is used to store picture in MS Access?

(A) Picture cannot be stored

(B) Memo

(C) OLE object

(D) Picture

9. A _____ name must be unique within a database.

(A) Character

(B) Table

(D) Field

10. Which control does access use to link data access page components to access data?

(A) Microsoft Default Connection Control

(B) Microsoft Data Connection Control

(D) Microsoft Office Data Source Control

11. Which of the following database object is created first before any other created?

(A) Query

(B) Table

(D) Form

12. Press _____ to cyle between open windows.

(A) Ctrl + F4

(B) Ctrl + F6

(D) Ctrl + F12

13. To sort records in a table

(A) Open table, click on the field on which the sorting is to be done, then click sort button on database toolbar

(B) Click the field heading to sort it ascending or descending

(D) All of the above

14. In MS Access, Lookup Wizard is used to

(A) to select value from another table

(B) to select values from Excel Sheet

(D) not a valid data type

15.The command center of access file that appears when you create or open the ms access database file.

(A) Switchboard

(B) Design view Window

(C) Database Window

(D) Query Window

16. In MS Access, Text data type may contain maximum character of

(A) 255 character

(B) 256 character

(D) No limit

17. To rename a selected object, press

(A) F2

(B) F3

(D) F5

18. ___ key is uniquely identifies each record.

(A) Field Name

(B) Unique key

(C) Primary key

(D) Key record

19. Which of the following is a method to create a new table in MS access?

(A) Create table by entering data

(B) Create table using wizard

(D) All of above

20. The expression builder is an access tool that controls an expression _____ for entering an expression.

(A) Palette

(B) Box

(D) Table

21. Which of the following is a method to create a new table in MS-Access?

(A) Create table using wizard

(B) Create table in design view

(D) All of the above

22. You can automatically include all of the field in a table in a query by _____ a strike that appear list box in query design view.

(A) Double clicking

(B) Right clicking

(D) All the above

23. What is a database?

(A) It is a collection of data arranged in rows

(B) It is a collection of data arranged in columns

(C) It is a collection of data arranged in rows and columns

(D) All of the above

24. To open an existing database, press

(A) Ctrl + O

(B) Ctrl + P

(D) Ctrl + X

25. The option allows you to build a new table by entering data directly into the datasheet.

(A) Datasheet view

(B) Design view

(D) All of the above

Ms Access-4

Contact Form