Exam 1: Creating a Database

 The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a data sheet. _________________________ 

 An important reference tool available in Access 2016,which may be used to assist a user with problems that might occur,is the ____________________ system.

 A question asked about the data stored in a database is called a primary key. _________________________ 

 There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________.

 To save a table in Access with a name that relates to the database (a name other than the Access default name),it is necessary to complete which process? 

 Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question? 

 When using a mouse while in an Access 2016 work session,access a shortcut menu for an object by performing this task. 

 Each Access database may be as large as two gigabytes in size and may have up to 255 people using the database at the same time. _________________________

Identify the letter of the choice that best matches the phrase or definition. - The Access 2016 view that shows the number of pages that will be printed. 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

 Which view is used to make design changes to a form while the form is displaying data? 

 Which of the following terms describes the Access feature that allows a user to size a column in datasheet view so that the column is just wide enough to display the longest visible value in the column? 

 Data organized as a collection of tables creates this type of data system. 

 It is possible to view all Access objects in the Navigation Pane. _________________________

Identify the letter of the choice that best matches the phrase or definition. - The Access Ribbon tab that allows the user to create database objects such as tables,forms,and reports.

 When copying and pasting records from one table to another,the records must first be copied to the ____. 

 Field values that may be entered into a field are determined by the data type of the field. _________________________

 Access reports are based on a selected ____________________ or ____________________.

Identify the letter of the choice that best matches the phrase or definition. - An Access 2016 tool that allows the user to quickly add fields and records to display in query results. 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

 Which of the following is the file extension used for Access 2016 database files? 

Identify the letter of the choice that best matches the phrase or definition. - The Access 2016 view that allows the user to manage files and options.