Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A)  a query 
B)  a record 
C)  a field 
D)  a data type

Question 5

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

Accepted Answer

A)  primary key field 
B)  field value 
C)  foreign key field 
D)  common field

Question 6

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

Accepted Answer

The answer of An important reference tool available in Access...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Access report printing options may be changed using the Navigation dialog box.

Accepted Answer

A) True 
 B)False

Question 9

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

Question 10

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

Question 11

A database or a relational database is a collection of related tables.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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

Accepted Answer

The answer of Clicking or tapping this navigation button 
...

Question 14

What is the purpose of the primary key?

Accepted Answer

A)  to uniquely identify each record in a table 
B)  to uniquely identify each table in a database 
C)  to create a relationship between two tables in a database 
D)  to create a relationship for queries in a database

Question 15

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

Question 16

When creating a form in Access, the Layout view allows the user to make design changes to the form while it is displaying data.

Accepted Answer

A) True 
 B)False

Question 17

The process of decreasing the file size of a database and enhancing the performance of the database is called ____________________ the database.

Accepted Answer

The answer of The process of decreasing the file size...

Question 18

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 19

Match between columns
                        Premises: A field, or collection of fields, whose values are used to uniquely identify each record in a table.
A status box that displays the number of the current record and the total number of records in a table.
The Access 2016 view that allows the user to manage files and options.
AutoNumber and Short Text are two examples of this Access feature which determines the values that may be entered in a field.
The specific content of a field.
The Access Ribbon tab that allows the user to create database objects such as tables, forms, and reports.
An Access 2016 tool that allows the user to quickly add fields and records to display in query results.
The Access Ribbon tab that offers the option for the user to compact and repair a database.
The Access 2016 view that shows the number of pages that will be printed.
A question that is asked about the data stored in a database.

Accepted Answer

The Answer of Print Preview and File tab and Backstage is...

Question 20

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

Accepted Answer

A)  sorting the database 
B)  querying the database 
C)  saving the database 
D)  repairing the database

Exam 1: Word Module Access Module Creating a Database

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

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

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.

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

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

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 software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS).

Access report printing options may be changed using the Navigation dialog box.

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

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

A database or a relational database is a collection of related tables.

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) ____________________.

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

What is the purpose of the primary key?

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?

When creating a form in Access, the Layout view allows the user to make design changes to the form while it is displaying data.

The process of decreasing the file size of a database and enhancing the performance of the database is called ____________________ the 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.

Identify the letter of the choice that best matches the phrase or definition.

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