Question 1

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

Accepted Answer

A) Navigation Bar 
B) Record 
C) Shutter Bar Open/Close 
D) Table View 
A) Navigation Bar 
B) Record 
C) Shutter Bar Open/Close 
D) Table View

Question 2

Files created with Access 2016 may be used with which previous version of Access?

Accepted Answer

A) Access 2010 
B) Access 2000 
C) Access 2005 
D) Access 2003 
A) Access 2010 
B) Access 2000 
C) Access 2005 
D) Access 2003

Question 3

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

Accepted Answer

A) form 
B) table 
C) query 
D) report 
A) form 
B) table 
C) query 
D) report

Question 4

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

Accepted Answer

A) scroll the vertical scroll bar 
B) scroll the horizontal scroll bar 
C) cllick on the Navigation Pane 
D) right click 
A) scroll the vertical scroll bar 
B) scroll the horizontal scroll bar 
C) cllick on the Navigation Pane 
D) right click

Question 5

A field in a second table that is the primary key in the first table is used to form a relationship between the two tables; the field in the second table is called a(n)____________________.

Accepted Answer

The answer of A field in a second table that...

Question 6

Each column in an Access table datasheet represents a ____.

Accepted Answer

A) query 
B) record 
C) field 
D) primary key 
A) query 
B) record 
C) field 
D) primary key

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.

Accepted Answer

The answer of Use the ____________________ feature on the Ribbon...

Question 9

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

Accepted Answer

A) database 
B) query 
C) storage device 
D) clipboard 
A) database 
B) query 
C) storage device 
D) clipboard

Question 10

The default sort order for records in an Access table is based on the values in the primary key field. _________________________

Accepted Answer

A) True 
 B)False

Question 11

Which Access feature provides information about Access commands and features and instructions about how to use them?

Accepted Answer

A) Query Wizard 
B) Access Help 
C) Form Wizard 
D) Report Wizard 
A) Query Wizard 
B) Access Help 
C) Form Wizard 
D) Report Wizard

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

A query is used to enter, edit, and view records in a database.  _________________________

Accepted Answer

A) True 
 B)False

Question 14

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.  
_________________________

Accepted Answer

A) True 
 B)False

Question 15

Records in separate tables may be connected through a(n)____________________ that appears in both tables.

Accepted Answer

The answer of Records in separate tables may be connected...

Question 16

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?

Accepted Answer

A) Tab, Insert 
B) Enter, PgDn 
C) Insert, PgUp 
D) Tab, Enter 
A) Tab, Insert 
B) Enter, PgDn 
C) Insert, PgUp 
D) Tab, Enter

Question 17

Match between columns
                        Premises: A status box that displays the number of the current record and the total number of records in a table.

Accepted Answer

The Answer of primary key and Backstage view and Current is...

Question 18

Which Ribbon group allows you to add fields to an Access table with defined data types?

Accepted Answer

A) Properties 
B) Formatting 
C) Field Validation 
D) Add & Delete 
A) Properties 
B) Formatting 
C) Field Validation 
D) Add & Delete

Question 19

Access reports are based on a selected ____________________ or ____________________.

Accepted Answer

The answer of Access reports are based on a selected...

Question 20

All of the data in a relational database are contained in ____________________.

Accepted Answer

The answer of All of the data in a relational...

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

Files created with Access 2016 may be used with which previous version of Access?

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.

A field in a second table that is the primary key in the first table is used to form a relationship between the two tables; the field in the second table is called a(n)____________________.

Each column in an Access table datasheet represents a ____.

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

Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.

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

The default sort order for records in an Access table is based on the values in the primary key field. _________________________

Which Access feature provides information about Access commands and features and instructions about how to use them?

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

A query is used to enter, edit, and view records in a database. _________________________

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. _________________________

Records in separate tables may be connected through a(n)____________________ that appears in both tables.

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?

Which Ribbon group allows you to add fields to an Access table with defined data types?

Access reports are based on a selected or .

All of the data in a relational database are contained in ____________________.

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 1: Access-Module 1: Creating a Database

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

Files created with Access 2016 may be used with which previous version of Access?

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.

A field in a second table that is the primary key in the first table is used to form a relationship between the two tables; the field in the second table is called a(n)____________________.

Each column in an Access table datasheet represents a ____.

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

Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.

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

The default sort order for records in an Access table is based on the values in the primary key field. _________________________

Which Access feature provides information about Access commands and features and instructions about how to use them?

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

A query is used to enter, edit, and view records in a database. _________________________

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. _________________________

Records in separate tables may be connected through a(n)____________________ that appears in both tables.

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?

Which Ribbon group allows you to add fields to an Access table with defined data types?

Access reports are based on a selected ____________________ or ____________________.

All of the data in a relational database are contained in ____________________.

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Access reports are based on a selected or .