Question 1

In Access, data entry screens are called forms .

Accepted Answer

Data entry screens in Access are called forms.

Question 2

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

Accepted Answer

The answer of A(n) ____________________  is a fundamental building block...

Question 3

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

Accepted Answer

The answer of A(n) ____________________ object provides an easy-to-use data...

Question 4

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

Accepted Answer

Picker

Question 5

A(n) ____________________ key field contains unique data for each record.

Accepted Answer

The answer of A(n) ____________________ key field contains unique data...

Question 6

When creating a database using an Access template, you must remember that the database cannot be altered later.

Accepted Answer

A database created using an Access template can be easily modified and customized to meet the specific needs of the user.

Question 7

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

Accepted Answer

The answer of Relational ____________________ software is used to manage...

Question 8

____________________ View is a spreadsheet-like grid that displays a table's fields and records.

Accepted Answer

The answer of ____________________ View is a spreadsheet-like grid that...

Question 9

A(n) ____________________ field automatically assigns a new number each time you add a record.

Accepted Answer

The answer of A(n) ____________________ field automatically assigns a new...

Question 10

The navigation buttons are found at the top of the datasheet.

Accepted Answer

bottom
lower-left corner

Question 11

Which editing keystroke deletes one character to the right of the insertion point?
A) [Backspace]
B) [Delete]
C) [F2]
D) [F7]

Accepted Answer

The [Delete] key deletes one character to the right of the insertion point. The [Backspace] key deletes one character to the left of the insertion point. [F2] opens the Save As dialog in many programs, and [F7] typically opens a spelling and grammar check.

Question 12

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

Accepted Answer

The answer of A foreign key field is always on...

Question 13

The Database window displays the Tables, Queries, Forms, and Reports. Describe what these four objects represent.

Accepted Answer

The answer of The Database window displays the Tables, Queries,...

Question 14

Match between columns
                        Premises: Often contains numerical values that help you interpret the size of chart elements.
An independent element on a worksheet.
Visually represents each data point.
Presents information in a pictorial format.
Often contains the names of data groups, such as locations, months, or years.

Accepted Answer

The Answer of chart and category axis and value axis is...

Question 15

What are the advantages of database software such as Access over spreadsheet software such as Excel?

Accepted Answer

The answer of What are the advantages of database software...

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

The answer of A(n) ____________________ relationship describes when a record...

Question 18

____________________ View is a view in which you create and manipulate the structure of an object.

Accepted Answer

The answer of ____________________ View is a view in which...

Question 19

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

Accepted Answer

If Access assumes that you are attempting to make changes to a field value, you are in Edit mode, not Navigation mode. Navigation mode is when you are moving between records or fields without making any changes.

Question 20

The ____________________ refers to which data you would edit if you started typing.

Accepted Answer

The answer of The ____________________ refers to which data you...

Quiz 2: Getting Started With Access 2.0