CIS 106 Chapter 1 Introduction to Access Multiple Choice Questions
1.) Which sequence represents the hierarchy of terms, from smallest to largest?
A.) Database, table, record, field
B.) Field, record, table, database
C.) Record, field, table, database
D.) Field, record, database, table
2.) You perform several edits in a table within an Access database. When should you execute the Save command?
A.) Immediately after you add, edit, or delete a record
B.) Each time you close a table or query
C.) Once at the end of a session
D.) Records are saved automatically; the save command is not required
3.) You have opened an Access file. The left pane displays a table with forms, queries, and reports listed below a table name. Then another table and its objects display. You notice some of the object names are repeated under different tables. Why?
A.) The navigation Pane has been set to Object Type. The object names repeat because a query or report is frequently based on multiple tables.
B.) The Navigation Pane has been set to Tables and Related Views. The object names repeat because a query or report is frequently based on multiple tables.
C.) The Navigation Pane has been set to Most Recently Used View. The object names repeat because an object has been used frequently
D.) The database objects have been alphabetized.
4.)Which of the following is not true of an Access Database?
A.) Every record in a table has the same fields as every other record
B.) Every table in a database contains the same number of records as every other table
C.) Text, Number, AutoNumber, and Currency are valid data types
D.) Each table should contain a primary key; however, a primary key is not required
5.) Which of the following is true regarding the record selector box?
A.) A pencil symbol indicates that the current record already has been saved
B.) An empty...