Question 1

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 2

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

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.

Accepted Answer

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

Question 4

More than one person can enter, update, and analyze data in an Access database at the same time.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is NOT a data type?

Accepted Answer

A)  Number 
B)  Formula 
C)  Date/Time 
D)  Short Text 
A)  Number 
B)  Formula 
C)  Date/Time 
D)  Short Text

Question 6

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 7

Match between columns
                        Premises: Last field of the last record

Accepted Answer

The Answer of [End] and [Down Arrow] and [Left Arrow] is...

Question 8

Values in an AutoNumber field are automatically created by Access.

Accepted Answer

A) True 
 B)False

Question 9

Pressing [Ctrl][;] will insert the current date in a Date field.

Accepted Answer

A) True 
 B)False

Question 10

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 11

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 12

Field properties change depending on the data type of the field.

Accepted Answer

A) True 
 B)False

Question 13

____ View provides the most options for defining fields.

Accepted Answer

A)  Table Design 
B)  Table Creation 
C)  Field Definition 
D)  Definition 
A)  Table Design 
B)  Table Creation 
C)  Field Definition 
D)  Definition

Question 14

Which shortcut key moves focus to the first field of the current record?

Accepted Answer

A)  [Home] 
B)  [End] 
C)  [F4] 
D)  [F5] 
A)  [Home] 
B)  [End] 
C)  [F4] 
D)  [F5]

Question 15

Which data type is used for sequential integers controlled by Access?

Accepted Answer

A)  Hyperlink 
B)  Web 
C)  Lookup Wizard 
D)  AutoNumber 
A)  Hyperlink 
B)  Web 
C)  Lookup Wizard 
D)  AutoNumber

Question 16

Which of the following is NOT available to you as you start Access?

Accepted Answer

A)  opening an existing database 
B)  recalibrating an existing database 
C)  creating a new database from a template 
D)  creating a new blank database 
A)  opening an existing database 
B)  recalibrating an existing database 
C)  creating a new database from a template 
D)  creating a new blank database

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

A subdatasheet shows the records on the "many" side of a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 19

A(n) ____________________ relationship describes when a record from one table is related to several records in another table.

Accepted Answer

one to man

Question 20

Which data type stores Web addresses?

Accepted Answer

A)  Lookup Wizard 
B)  Hyperlink 
C)  URL 
D)  HTML 
A)  Lookup Wizard 
B)  Hyperlink 
C)  URL 
D)  HTML

Exam 1: Access 1: Getting Started With Access

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

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

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.

More than one person can enter, update, and analyze data in an Access database at the same time.

Which of the following is NOT a data type?

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

Values in an AutoNumber field are automatically created by Access.

Pressing [Ctrl][;] will insert the current date in a Date field.

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

Which data type stores only one of two values?

Field properties change depending on the data type of the field.

____ View provides the most options for defining fields.

Which shortcut key moves focus to the first field of the current record?

Which data type is used for sequential integers controlled by Access?

Which of the following is NOT available to you as you start Access?

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

A subdatasheet shows the records on the "many" side of a one-to-many relationship.

A(n) ____________________ relationship describes when a record from one table is related to several records in another table.

Which data type stores Web addresses?

Access 2: Building and Using Queries

Access 3: Using Forms

Access 4: Using Reports

Essential: Understanding Essential Computer Concepts

Excel 1: Getting Started With Excel 2016

Excel 2: Working With Formulas and Functions

Excel 3: Formatting a Worksheet

Excel 4: Working With Charts

Integration 1: Integrating Word and Excel

Integration 2: Integrating Word Excel and Access

Integration 3: Integrating Word Excel Access and Powerpoint

Office: Getting Started With Office 2016

Outlook 1: Getting Started With Email

Outlook 2: Managing Information Using Outlook

Powerpoint 1: Creating a Presentation in Powerpoint 2016

Powerpoint 2: Modifying a Presentation

Powerpoint 3: Inserting Objects Into a Presentation

Powerpoint 4: Finishing a Presentation

Windows 1: Getting Started With Windows 10

Windows 2: Understanding File Management

Word 1: Creating Documents With Word 2016

Word 2: Editing Documents

Word 3: Formatting Text and Paragraphs

Word 4: Formatting Documents

Filters