Cis 106 chapter 1 introduction to access multiple choice questions

Page 1

CIS 106 Chapter 1 Introduction to Access Multiple Choice Questions http://homeworktimes.com/downloads/cis-106-chapter-1-introduction-access-multiple-choicequestions/

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 square indicates that the current record has not changed C.) An asterisk indicates the first record in the table D.) A gold border surrounds the active record


6.) You have finished an Access assignment and your instructor wants you to turn it in. It has more than doubled in its original size. What should you do? A.) Zip the database file prior to transmitting it to the instructor B.) Turn it in; the size does not matter C.) Compact and repair the database file prior to transmitting it to the instructor D.) Delete extra tables or reports or fields to make the file smaller 7.) Which of the following will be accepted as valid during data entry? A.) Adding a record with a duplicate primary key B.) Entering a text into a numeric field C.) Entering numbers into a text field D.) Omitting an entry in a required field 8.) Which of the following conditions is available through Filter by Selection? A.) The AND condition B.) The OR Condition C.) An Equals Condition D.) A delete condition


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.