Question 1

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

Accepted Answer

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

Question 2

Which shortcut key moves focus to the first field of the current record?
A)[Home]
B)[End]
C)[F4]
D)[F5]

Accepted Answer

The [Home] key is the shortcut key that moves focus to the first field of the current record.

Question 3

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

Accepted Answer

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

Question 4

In Access, data entry screens are called forms .

Accepted Answer

In Access, data entry screens are indeed called forms.

Question 5

Press this keystroke combination to move focus to the last field of the last record.
A)[Alt][Ctrl][Up Arrow]
B)[Ctrl][Up Arrow]
C)[Ctrl][End]
D)[Ctrl][Page Up]

Accepted Answer

[Crtl][End] keystroke combination moves the focus to the last field of the last record, making it the best choice. [Alt][Ctrl][Up Arrow] moves the screen to the top of the viewable area and [Ctrl][Up Arrow] and [Ctrl][Page Up] move the screen up a line or page respectively, but do not move the focus to the last field of the last record.

Question 6

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

Question 7

Which of the following keys will help you delete unwanted data in Edit mode?
A)[Insert]
B)[Home]
C)[Ctrl]
D)[Backspace]

Accepted Answer

The [Backspace] key helps to delete unwanted data in Edit mode by deleting characters to the left of the cursor.

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)____________________ 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 select...

Question 10

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

Accepted Answer

This statement is false. While it is recommended that you do not make major changes to the structure of a database created from a template, it is possible to make alterations as needed.

Question 11

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 12

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

Question 13

Which shortcut key moves focus to the previous field of the current record?
A)[Home]
B)[Shift][Tab]
C)[Up Arrow]
D)[F5]

Accepted Answer

[Shift][Tab] is the shortcut key that moves focus to the previous field of the current record. This is a common shortcut used in data entry to quickly navigate between fields without using the mouse.

Question 14

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 15

____________________ 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 16

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 17

While editing a record, pressing [Esc] a second time ____.
A)Deletes the current field
B)Deletes the current datasheet
C)Removes all data from the current record
D)Removes all changes made to the record you are currently editing

Accepted Answer

Pressing [Esc] a second time while editing a record in Microsoft Access removes all changes made to the record you are currently editing.

Question 18

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

Question 19

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.

Question 20

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

Quiz 10: Getting Started With Access 2.0

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

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

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

In Access, data entry screens are called forms .

Press this keystroke combination to move focus to the last field of the last record.

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

Which of the following keys will help you delete unwanted data in Edit mode?

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

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

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

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

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

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

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.

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

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

While editing a record, pressing [Esc] a second time ____.

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

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

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