MS Access Cat 1
This test is formulated to assess your knowledge on the concepts of how to use Microsoft Access software effectively. The test is based on the criteria of the computer 150 course syllabus which is basically how to create and edit forms, tables ,reports and quires. The online tutorial effectively covered all the specific areas expected to know so this test will be enjoyable. Good Luck!
- 1.A database is ?
- A.
A collection of file.
- B.
A collection of records .
- C.
A collection of data.
- D.
A collection of tables.
- 2.Most database systems make it very easy to create a database via ?
- A.
A visual interface
- B.
A user interface
- C.
Tabs
- D.
Speech recognition
- 3.The following is the first step in how to create a database in Microsoft Access?
- A.
From the "File" menu, click on "New Database"
- B.
Choose "Blank Database"
- C.
Choose a location to save the database
- D.
Exit
- 4.In database terms, a table ?
- A.
Is responsible for storing data in the database
- B.
Is responsible for storing data in a folder
- C.
Is responsible for storing data in a report
- D.
Is responsible for storing data in a query
- 5.Database tables consist of ?
- A.
Rows and columns
- B.
Forms and reports
- C.
Lines and arrows
- D.
Formulas and calculations
- 6.A row contains each record in the?
- A.
Form
- B.
Report
- C.
Table
- D.
Design View
- 7.What enables you to create the names of each column, specify the type of data that can go into each column, as well as specifying any other restrictions you'd like to enforce?
- A.
Creative view
- B.
Visual view
- C.
Design view
- D.
Creative View
- 8.A "query" refers to the action of ________from your database.
- A.
Retrieving data
- B.
Deleting data
- C.
Recycling data
- D.
Canceling data
- 9.A unique identifier is a value that is ______to each record.
- A.
Ordinary
- B.
Common
- C.
Unique
- D.
Deleted
- 10.The column that contains the unique identifier is referred to as the ?
- A.
Secondary key
- B.
Product Key
- C.
Primary Key
- D.
Delete Key
Questions: 10 | Attempts: 21875 | Last updated: Mar 22, 2022
-
Sample QuestionA _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.
Questions: 10 | Attempts: 17165 | Last updated: Mar 22, 2022
-
Sample QuestionAn organized collection of logically related data is known as?
Questions: 50 | Attempts: 15535 | Last updated: Mar 22, 2022
-
Sample QuestionWhich object is used to create a form?
Back to top