Exam 1: Creating a Database

 A formatted printout (or screen display) of the contents of one or more tables or queries is a form. _________________________

Identify the letter of the choice that best matches the phrase or definition. - A question that is asked about the data stored in a database. A)field value B)primary key C)Backstage view D)data type E)Current Record Box F)Create tab G)query H)Simple Query Wizard I)Print Preview J)File tab

 What is the purpose of the primary key? 

 Another term used for the column selector feature is ____. 

Identify the letter of the choice that best matches the phrase or definition. - The Access Ribbon tab that offers the option for the user to compact and repair a database. A)field value B)primary key C)Backstage view D)data type E)Current Record Box F)Create tab G)query H)Simple Query Wizard I)Print Preview J)File tab

 Clicking or tapping this navigation button moves the insertion point to the ____________________ in a table.

 A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS). _________________________ 

 The default ____________________ provided by Access is the ID field.

 What function does compacting an Access database perform other than reducing the file size? 

 A relationship between two tables in a database is formed using a Backstage field. _________________________

 Which Access database object(s) might be used to enter,edit,and view records in a database? 

 Each row in an Access table datasheet displays which of the following? 

 Access report printing options may be changed using theNavigation dialog box._________________________

 In a relational DBMS,a user may create a database structure that contains which of the following? 

 Which button is used to open and close the Navigation Pane? 

 Each record in a table is uniquely identified by a foreign key. _________________________ 

 A table is a predesigned database that includes professionally designed database objects. _________________________ 

 Which Access 2016 view contains commands used to manage Access files and options? 

 Experienced database developers avoid using spaces in field names and object names because names with spaces might cause errors if the objects are involved in ____. 

 Data can be presented in customized and useful ways different from tables and queries by using a Simple ____________________.