Question 1

The Address Quick Start selection adds a group of relationships related to an address including Address,City,State,etc._________________________

Accepted Answer

fields

Question 2

The ____ property allows the database designer to explain the purpose of a field or how a field is used. 
A) Data type
B) Field size 
C) Required
D) Description

Accepted Answer

The Description property allows the database designer to explain the purpose of a field or how a field is used.

Question 3

The Data Type Gallery,which allows the entry of groups of fields using the Quick Start selection,is only available in Datasheet view. _________________________

Accepted Answer

The statement is true. The Data Type Gallery is only available in Datasheet view, not in other views like Design view or Form view.

Question 4

When text is used as the Default Value for a field property,it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message. _________________________

Accepted Answer

Enclosing the text within quotation marks is a best practice to avoid any syntax errors.

Question 5

The F6 key toggles the Access table workspace between the Table Design grid and the Field Properties pane. _________________________

Accepted Answer

The statement is true. Pressing F6 key toggles the Access table workspace between the Table Design grid and the Field Properties pane.

Question 6

The Currency data type is accurate up to 4 digits on the right side of the decimal point._________________________

Accepted Answer

The Currency data type is accurate up to 4 digits on the right side of the decimal point.

Question 7

All fields in a database should be contained in one table. _________________________

Accepted Answer

It is best practice to break up data into multiple tables based on their logical relationships in order to avoid redundancy and improve data integrity. The fields in these tables can be linked through primary and foreign keys.

Question 8

Access does not allow data to be imported from sources other than another Access database. _________________________

Accepted Answer

This statement is false. Access allows data to be imported from sources like Excel, CSV, and other databases as well using its import wizard.

Question 9

Access automatically assigns the Number data type to all new fields. _________________________

Accepted Answer

The answer of  Access automatically assigns the Number data type...

Question 10

Access does not require a field description for every field included in a table. _________________________

Accepted Answer

Access allows for fields to be created without a description, although it may be beneficial to include one for clarity and organization.

Question 11

A primary key that consists of two or more fields is called a(n) redundant key._________________________

Accepted Answer

composite key

Question 12

In the Database Design grid,press the Enter key to move from one property to the next property._________________________

Accepted Answer

Table Design grid

Question 13

In order to define table relationships,each table being joined must contain a common field._________________________

Accepted Answer

This common field serves as the basis for establishing a relationship between the tables. Without a common field, the tables cannot be joined meaningfully.

Question 14

Access does not require a table to have a(n) primary key._________________________

Accepted Answer

Access does not require a table to have a primary key, but it is recommended to have one for data integrity and performance purposes.

Question 15

Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database. _________________________

Accepted Answer

Data redundancy can lead to wasted storage space, slower database performance, and inconsistencies or errors in the data. It is important to minimize redundancy through database normalization techniques to ensure data accuracy and efficiency.

Question 16

Relationship integrity is a set of rules used by Access to maintain consistency between related tables when data in either table is updated._________________________

Accepted Answer

Referential integrity

Question 17

A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut._________________________

Accepted Answer

A keyboard shortcut is a combination of keys that allows you to perform a task or command more quickly and efficiently than using a mouse or other input device.

Question 18

Field names in a table may only be changed in Design view. _________________________

Accepted Answer

The answer of  Field names in a table may only...

Question 19

____ is the default name for a new table in an Access database. 
A) My table
B) Table1 
C) ADB Table
D) TableA

Accepted Answer

Table1 is the default name for a new table in an Access database.

Question 20

The field name displayed in database objects,including forms and reports,is determined by the Caption property._________________________

Accepted Answer

The Caption property determines the field name displayed in database objects, including forms and reports.

Quiz 2: Building a Database and Defining Table Relationships

The Address Quick Start selection adds a group of relationships related to an address including Address,City,State,etc._________________________

The ____ property allows the database designer to explain the purpose of a field or how a field is used.

The Data Type Gallery,which allows the entry of groups of fields using the Quick Start selection,is only available in Datasheet view. _________________________

When text is used as the Default Value for a field property,it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message. _________________________

The F6 key toggles the Access table workspace between the Table Design grid and the Field Properties pane. _________________________

The Currency data type is accurate up to 4 digits on the right side of the decimal point._________________________

All fields in a database should be contained in one table. _________________________

Access does not allow data to be imported from sources other than another Access database. _________________________

Access automatically assigns the Number data type to all new fields. _________________________

Access does not require a field description for every field included in a table. _________________________