Question 1

When working with Access in ____ Mode,the user may tap the buttons on the Ribbon and also tap to use other features of Access 2016. 
A) Write
B) Touch 
C) Tap
D) Tablet

Accepted Answer

"Touch" mode is the mode in which Access is optimized for touch screens and allows users to easily tap buttons and use other features using touch gestures.

Question 2

When copying and pasting records from one table to another,the records must first be copied to the ____. 
A) database
B) query 
C) storage device
D) clipboard

Accepted Answer

When copying and pasting records, the records must first be copied to the clipboard before they can be pasted into another table. The clipboard temporarily stores the copied data until it is pasted into the desired location.

Question 3

In a relational DBMS,a user may create a database structure that contains which of the following? 
A) data, fields, and table relationships
B) numbers, tables, and fields 
C) symbols, numbers, and tables
D) fields, tables, and table relationships

Accepted Answer

In a relational DBMS, a user may create a database structure that contains fields, tables, and table relationships. Fields represent the individual data elements, tables organize related fields into a collection of records, and table relationships define how the tables are related to each other. Therefore, option D is the correct choice as it includes all the necessary components required to create a relational database structure.

Question 4

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

Accepted Answer

The answer of  There are two ways to move vertically...

Question 5

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? 
A) Tab, Insert
B) Enter, PgDn 
C) Insert, PgUp
D) Tab, Enter

Accepted Answer

The Tab key is used to move to the next field to the right in datasheet view, while the Enter key is used to move to the next row. Therefore, the best choice is D, as it includes Tab (to move to the next field) and Enter (to move to the next row).

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

The answer of  Data can be presented in customized and...

Question 8

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 ____. 
A) creating reports using Access
B) related databases 
C) programming tasks
D) queries

Accepted Answer

Including spaces in field names and object names can cause errors in programming tasks, such as when referencing the object in code. It is generally recommended to use underscores or CamelCase to separate words in names instead of spaces.

Question 9

The default ____________________ provided by Access is the ID field.

Accepted Answer

The answer of  The default ____________________ provided by Access is...

Question 10

Which of the following is the file extension used for Access 2016 database files? 
A) .mdb
B) .acdbs
C) .accdb
D) .dbacc

Accepted Answer

The file extension used for Access 2016 database files is .accdb. Option A (.mdb) was used for older versions of Access, option B (.acdbs) is not a valid file extension, and option D (.dbacc) does not exist.

Question 11

Access reports are based on a selected ____________________ or ____________________.

Accepted Answer

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

Question 12

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 13

Which of the following attributes of a table are saved only when the table object is saved? 
A) records
B) field values 
C) characteristics of the fields
D) data records

Accepted Answer

Characteristics of the fields such as data type, field size, field format, and validation rules are saved only when the table object is saved. The records and field values can be added, edited, and deleted without saving the table object. Data records are also saved when the table object is saved, but this is not an attribute of the table.

Question 14

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 15

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

Question 16

Which data type allows field values to contain letters,digits,and other characters? 
A) Short Text
B) AutoNumber 
C) Currency
D) Date/Time

Accepted Answer

Short Text allows for field values to contain any combination of letters, digits, and other characters. AutoNumber generates a unique number for each record, Currency is for monetary values, and Date/Time is for dates and times.

Question 17

When using a mouse while in an Access 2016 work session,access a shortcut menu for an object by performing this task. 
A) scroll the vertical scroll bar
B) scroll the horizontal scroll bar 
C) cllick on the Navigation Pane
D) right click

Accepted Answer

To access a shortcut menu for an object in Access 2016, you should right-click on the object with your mouse. This will open a menu of options related to the object you clicked on.

Question 18

A table's contents are shown in rows and columns when using the ____________________ view.

Accepted Answer

The answer of  A table's contents are shown in rows...

Question 19

Files created with Access 2016 may be used with which previous version of Access? 
A) Access 2010
B) Access 2000 
C) Access 2005
D) Access 2003

Accepted Answer

The answer of  Files created with Access 2016 may be...

Question 20

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

Quiz 1: Creating a Database

When working with Access in ____ Mode,the user may tap the buttons on the Ribbon and also tap to use other features of Access 2016.

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

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

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

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?

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

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

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

The default ____________________ provided by Access is the ID field.

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

Access reports are based on a selected or .

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

Which of the following attributes of a table are saved only when the table object is saved?

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.

Which data type allows field values to contain letters,digits,and other characters?

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

A table's contents are shown in rows and columns when using the ____________________ view.

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

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