Microsoft Access
Exam Review
Questions And
Answers Latest
Update
Microsoft Access Exam Review Questions And Answers Latest Update
©® 1
,Microsoft Access Exam
1. A database program you use to enter, organize, display, and retrieve related information. - ANSWER
✔ - Access
2. The program window that appears when you start the Access program to create a new database or
open an existing database. - ANSWER ✔ - Access window
3. A group on the Fields tab in Table Datasheet view that contains options for adding different types of
fields to a table. - ANSWER ✔ - Add & Delete group
4. The default category in the Navigation Pane; it lists all the objects in the database grouped by type
(tables, queries, forms, reports, and so on). - ANSWER ✔ - All Access Objects
5. An Access data type that automatically assigns a unique number to a record. - ANSWER ✔ -
AutoNumber
6. Making a copy of a database file to protect your database against loss or damage. - ANSWER ✔ -
backing up
7. In Datasheet view for a table, the datasheet column you can use to create a new field in the table. -
ANSWER ✔ - Click to Add column
8. In a datasheet, the column heading (also called the field selector) that you click to select the entire
column. - ANSWER ✔ - column selector
9. A field that appears in more than one table, allowing you to connect the records in the separate
tables - ANSWER ✔ - common field
©® 2
, 10. A process that rearranges the data and objects in a database to decrease its file size, thereby making
more space available on your disk and letting you open and close the database more quickly. -
ANSWER ✔ - compacting
11. A tab on the Ribbon that provides options for creating various database objects, including tables,
forms, and reports. - ANSWER ✔ - Create tab
12. The box that appears at the bottom of a datasheet or form and that indicates the current record and
total number of records displayed. - ANSWER ✔ - Current Record box
13. The field property that determines what field values you can enter for the field and what other
properties the field will have. - ANSWER ✔ - data type
14. A collection of related tables stored in the same file. - ANSWER ✔ - database
15. A software program that lets you create databases and then manipulate data in them. - ANSWER ✔ -
database management system (DBMS)
16. The display of a table's contents in rows and columns, similar to a table or spreadsheet; each row is
a separate record in the table, and each column contains the field values for one field in the table. -
ANSWER ✔ - datasheet
17. A box in the upper-left corner of a datasheet that lets you select the entire datasheet. - ANSWER ✔ -
datasheet selector
18. The Access view that shows a table's contents as a datasheet in rows and columns. - ANSWER ✔ -
Datasheet view (for a table)
©® 3
Exam Review
Questions And
Answers Latest
Update
Microsoft Access Exam Review Questions And Answers Latest Update
©® 1
,Microsoft Access Exam
1. A database program you use to enter, organize, display, and retrieve related information. - ANSWER
✔ - Access
2. The program window that appears when you start the Access program to create a new database or
open an existing database. - ANSWER ✔ - Access window
3. A group on the Fields tab in Table Datasheet view that contains options for adding different types of
fields to a table. - ANSWER ✔ - Add & Delete group
4. The default category in the Navigation Pane; it lists all the objects in the database grouped by type
(tables, queries, forms, reports, and so on). - ANSWER ✔ - All Access Objects
5. An Access data type that automatically assigns a unique number to a record. - ANSWER ✔ -
AutoNumber
6. Making a copy of a database file to protect your database against loss or damage. - ANSWER ✔ -
backing up
7. In Datasheet view for a table, the datasheet column you can use to create a new field in the table. -
ANSWER ✔ - Click to Add column
8. In a datasheet, the column heading (also called the field selector) that you click to select the entire
column. - ANSWER ✔ - column selector
9. A field that appears in more than one table, allowing you to connect the records in the separate
tables - ANSWER ✔ - common field
©® 2
, 10. A process that rearranges the data and objects in a database to decrease its file size, thereby making
more space available on your disk and letting you open and close the database more quickly. -
ANSWER ✔ - compacting
11. A tab on the Ribbon that provides options for creating various database objects, including tables,
forms, and reports. - ANSWER ✔ - Create tab
12. The box that appears at the bottom of a datasheet or form and that indicates the current record and
total number of records displayed. - ANSWER ✔ - Current Record box
13. The field property that determines what field values you can enter for the field and what other
properties the field will have. - ANSWER ✔ - data type
14. A collection of related tables stored in the same file. - ANSWER ✔ - database
15. A software program that lets you create databases and then manipulate data in them. - ANSWER ✔ -
database management system (DBMS)
16. The display of a table's contents in rows and columns, similar to a table or spreadsheet; each row is
a separate record in the table, and each column contains the field values for one field in the table. -
ANSWER ✔ - datasheet
17. A box in the upper-left corner of a datasheet that lets you select the entire datasheet. - ANSWER ✔ -
datasheet selector
18. The Access view that shows a table's contents as a datasheet in rows and columns. - ANSWER ✔ -
Datasheet view (for a table)
©® 3
