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

(C) Macros

(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

(C) Establishing Relationship

(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

(C) Create a replica of the database

(D) All of the above


6. To toggle the Navigation Pane, press

(A) F1

(B) F2

(C) F6

(D) F11


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

(A) Restore

(B) Recreate

(C) Copy

(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

(C) Record

(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

(C) Microsoft Dynamic Data 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

(C) Report

(D) Form


12. Press _____ to cyle between open windows.

(A) Ctrl + F4

(B) Ctrl + F6

(C) Ctrl + F7

(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

(C) Open table, click sort button on database toolbar, choose field based on which to sort, click ok

(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

(C) to select from previous values

(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

(C) 1064 character

(D) No limit


17. To rename a selected object, press

(A) F2

(B) F3

(C) F4

(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

(C) Create table in design view

(D) All of above


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

(A) Palette

(B) Box

(C) Cell

(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

(C) Create table in data sheet 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

(C) 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

(C) Ctrl + E

(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

(C) Link table

(D) All of the above

Post a Comment (0)
Previous Post Next Post