Exam 1: Getting Started With Access

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

(Short Answer)

4.8/5

(27)

Question 21

A(n) ____________________ object provides an easy-to-use data entry screen.

(Short Answer)

4.7/5

(33)

Question 22

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

(Short Answer)

4.8/5

(39)

Question 23

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

(True/False)

4.8/5

(40)

Question 24

Access databases cannot be password protected.

(True/False)

4.7/5

(31)

Question 25

You can use the Calendar Box to enter dates in a Date/Time field. _________________________

(True/False)

4.9/5

(38)

Question 26

Press [Esc] once to undo a change to the current field.

(True/False)

4.8/5

(33)

Question 27

____ View provides the most options for defining fields.

(Multiple Choice)

4.7/5

(27)

Question 28

In Access, data entry screens are called forms . _________________________

(True/False)

4.8/5

(38)

Question 29

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

(True/False)

4.8/5

(30)

Question 30

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

(Multiple Choice)

4.8/5

(32)

Question 31

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

(True/False)

4.9/5

(33)

Question 32

Values in an AutoNumber field are automatically created by Access.

(True/False)

4.7/5

(36)

Question 33

Microsoft Access 2016 can best be described as ____ software.

(Multiple Choice)

4.7/5

(25)

Question 34

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

(True/False)

4.8/5

(28)

Question 35

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

(Multiple Choice)

4.8/5

(36)

Question 36

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.

(True/False)

4.9/5

(30)

Question 37

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

(True/False)

4.8/5

(31)

Question 38

The Database window displays the tables, queries, forms, and reports. Describe what these four objects represent.

(Essay)

4.9/5

(35)

Question 39

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

(Multiple Choice)

4.9/5

(35)

Question 40

Showing 21 - 40 of 68

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) ____________________ object provides an easy-to-use data entry screen.

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

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

Access databases cannot be password protected.

You can use the Calendar Box to enter dates in a Date/Time field. _________________________

Press [Esc] once to undo a change to the current field.

____ View provides the most options for defining fields.

In Access, data entry screens are called forms . _________________________

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

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

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

Values in an AutoNumber field are automatically created by Access.

Microsoft Access 2016 can best be described as ____ software.

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

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

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.

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

The Database window displays the tables, queries, forms, and reports. Describe what these four objects represent.

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

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters