Question 1

In which of the following circumstances would you copy an entire table?
A) You want to export records to another format.
B) You want to create a query with a self join.
C) You want to make one table the parent table and the other the child table.
D) You want to use the same table structure as in another table.

Accepted Answer

Copying an entire table is useful when you want to use the same table structure as in another table, such as when creating a new table with identical fields to an existing table.

Question 2

A(n) _____ is an intentional "nothing" entry, which you might use for employees who do not want their email addresses stored in the database.
A) index
B) blank string
C) validation text
D) zero-length string

Accepted Answer

A zero-length string is a string with no characters in it, and can be used as a placeholder to indicate a lack of information. In this case, it can be used as a placeholder for an email address that is intentionally left blank or not provided.

Question 3

If you set the _____ property to Yes for the CustEmail field, that means users can enter two quotation marks ("") in the field to mean no entry.
A) Allow Zero Length
B) Allow Multiple Values
C) Allow Value List Edits
D) Allow Null

Accepted Answer

The Allow Zero Length property allows users to leave a field blank, or in this case, enter two quotation marks to indicate no entry. The other properties listed do not pertain to this particular scenario.

Question 4

To allow users to enter more than one value in a field, you set the Allow Multiple Values property to Yes in the _____ in Table Design View.
A) General tab
B) Lookup tab
C) Description column
D) Data Type column

Accepted Answer

The Allow Multiple Values property is set to Yes in the Lookup tab in Table Design View when you want to allow users to enter more than one value in a field. This feature is often used for creating a lookup field that can hold multiple values from a list.

Question 5

You can copy and paste any object in Access except for tables.

Accepted Answer

You can copy and paste tables in Access.

Question 6

To copy a table, you right-click it in _____ and then click Copy on the shortcut menu.
A) the Field List
B) Datasheet View
C) the Navigation Pane
D) Design View

Accepted Answer

The answer of To copy a table, you right-click it...

Question 7

After using the Performance Analyzer, you can open the Relationship window to see the tables and relationships it created. Which symbol identifies the primary key field?
A) key symbol
B) linking symbol
C) infinity symbol
D) expand symbol

Accepted Answer

The key symbol identifies the primary key field in the Relationship window. This is important because the primary key is used to uniquely identify each record in a table, and it is often used in relationships between tables.

Quiz 1: Access 2019

In which of the following circumstances would you copy an entire table?

A(n) _____ is an intentional "nothing" entry, which you might use for employees who do not want their email addresses stored in the database.

If you set the _____ property to Yes for the CustEmail field, that means users can enter two quotation marks ("") in the field to mean no entry.

To allow users to enter more than one value in a field, you set the Allow Multiple Values property to Yes in the _____ in Table Design View.

You can copy and paste any object in Access except for tables.

To copy a table, you right-click it in _____ and then click Copy on the shortcut menu.

After using the Performance Analyzer, you can open the Relationship window to see the tables and relationships it created. Which symbol identifies the primary key field?