Question 1

Which editing keystroke deletes one character to the right of the insertion point?

Accepted Answer

A)  [Backspace] 
B)  [Delete] 
C)  [F2] 
D)  [F7] 
A)  [Backspace] 
B)  [Delete] 
C)  [F2] 
D)  [F7] B

Question 2

Relational ____________________ software is used to manage data that can be organized into lists, such as information about customers, products, vendors, employees, projects, or sales.

Accepted Answer

database

Question 3

A(n) ____________________ is a fundamental building block of a relational database because this object stores all of the data.

Accepted Answer

table

Question 4

Tables, queries, and forms are examples of Access ____.

Accepted Answer

A)  entities 
B)  objects 
C)  values 
D)  controls 
A)  entities 
B)  objects 
C)  values 
D)  controls

Question 5

Tables contain all of the data in the database.

Accepted Answer

A) True 
 B)False

Question 6

Which two properties are required for every field?

Accepted Answer

A)  Field Name and Data Type 
B)  Field Name and Field Size 
C)  Data Type and Format 
D)  Field Size and Format 
A)  Field Name and Data Type 
B)  Field Name and Field Size 
C)  Data Type and Format 
D)  Field Size and Format

Question 7

The [F2] key switches between Edit and Navigation modes.

Accepted Answer

A) True 
 B)False

Question 8

Which data type links files created in other programs such as pictures or documents?

Accepted Answer

A)  Lookup 
B)  Attachment 
C)  Yes/No 
D)  Link Wizard 
A)  Lookup 
B)  Attachment 
C)  Yes/No 
D)  Link Wizard

Question 9

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

Accepted Answer

A) True 
 B)False

Question 10

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator.

Accepted Answer

A) True 
 B)False

Question 11

A(n) foreign key field is always on the "one" side of a one-to-many relationship between two tables.

Accepted Answer

A) True 
 B)False

Question 12

Which data type stores only one of two values?

Accepted Answer

A)  Attachment 
B)  Hyperlink 
C)  Yes/No 
D)  Null 
A)  Attachment 
B)  Hyperlink 
C)  Yes/No 
D)  Null

Question 13

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

Accepted Answer

A)  Edit mode 
B)  Navigation mode 
C)  Update mode 
D)  Form mode 
A)  Edit mode 
B)  Navigation mode 
C)  Update mode 
D)  Form mode

Question 14

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

Accepted Answer

A)  Hierarchical 
B)  Network 
C)  Schematic 
D)  Referential 
A)  Hierarchical 
B)  Network 
C)  Schematic 
D)  Referential

Question 15

A(n) ____________________ object allows a user to select a subset of data from one or more tables.

Accepted Answer

The answer of A(n) ____________________ object allows a user to...

Question 16

In the accompanying figure, CustomerRoster is a ____ tab.

Accepted Answer

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

Question 17

If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode.

Accepted Answer

A) True 
 B)False

Question 18

The navigation buttons on a datasheet display the total number of fields in the datasheet.

Accepted Answer

A) True 
 B)False

Question 19

In Navigation mode, press [Tab] or ____ to move to the next field within the same record.

Accepted Answer

A)  [End] 
B)  [Page Down] 
C)  [Down Arrow] 
D)  [Enter] 
A)  [End] 
B)  [Page Down] 
C)  [Down Arrow] 
D)  [Enter]

Question 20

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Accepted Answer

A)  record 
B)  table 
C)  database 
D)  object 
A)  record 
B)  table 
C)  database 
D)  object

Which editing keystroke deletes one character to the right of the insertion point?

Relational ____________________ software is used to manage data that can be organized into lists, such as information about customers, products, vendors, employees, projects, or sales.

A(n) ____________________ is a fundamental building block of a relational database because this object stores all of the data.

Tables, queries, and forms are examples of Access ____.

Tables contain all of the data in the database.

Which two properties are required for every field?

The [F2] key switches between Edit and Navigation modes.

Which data type links files created in other programs such as pictures or documents?

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator.

A(n) foreign key field is always on the "one" side of a one-to-many relationship between two tables.

Which data type stores only one of two values?

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

A(n) ____________________ object allows a user to select a subset of data from one or more tables.

In the accompanying figure, CustomerRoster is a ____ tab.

If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode.

The navigation buttons on a datasheet display the total number of fields in the datasheet.

In Navigation mode, press [Tab] or ____ to move to the next field within the same record.

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Building and Using Queries

Using Forms

Using Reports

Getting Started With Microsoft Office 2013

Filters

Exam 1: Getting Started With Access 2013

Which editing keystroke deletes one character to the right of the insertion point?

Relational ____________________ software is used to manage data that can be organized into lists, such as information about customers, products, vendors, employees, projects, or sales.

A(n) ____________________ is a fundamental building block of a relational database because this object stores all of the data.

Tables, queries, and forms are examples of Access ____.

Tables contain all of the data in the database.

Which two properties are required for every field?

The [F2] key switches between Edit and Navigation modes.

Which data type links files created in other programs such as pictures or documents?

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator.

A(n) foreign key field is always on the "one" side of a one-to-many relationship between two tables.

Which data type stores only one of two values?

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

A(n) ____________________ object allows a user to select a subset of data from one or more tables.

In the accompanying figure, CustomerRoster is a ____ tab.

If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode.

The navigation buttons on a datasheet display the total number of fields in the datasheet.

In Navigation mode, press [Tab] or ____ to move to the next field within the same record.

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Building and Using Queries

Using Forms

Using Reports

Getting Started With Microsoft Office 2013

Filters