Question 1

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

Accepted Answer

The Currency data type in most programming languages is accurate up to 4 digits on the right side of the decimal point. This is because of the way it is stored in memory and the limitations of the data type.

Question 2

____ 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 Access databases. It is recommended to rename the table to a more descriptive name related to its content.

Question 3

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

Accepted Answer

This statement is true. Data redundancy refers to the unnecessary repetition of data in a database. It can lead to an increase in storage space usage and may cause inconsistencies and errors in the database. Therefore, it is generally considered best practice to avoid data redundancy as much as possible.

Question 4

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 can perform a specific action on a computer more efficiently than using a mouse.

Question 5

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 6

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

Accepted Answer

fields

Question 7

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

Accepted Answer

Access does not automatically assign the Number data type to all new fields; it assigns the Text data type by default unless specified otherwise.

Question 8

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 for entering groups of fields using the Quick Start selection is only available in Datasheet view.

Question 9

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

Accepted Answer

In some cases, it may be necessary or beneficial to split fields into different tables. For example, if you have a large amount of data with many different categories or types, it may be more organized and efficient to separate them into different tables rather than having a single table with many columns. This is known as database normalization.

Question 10

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

Accepted Answer

Access allows data to be imported from sources other than another Access database, such as Excel spreadsheets or CSV files.

Question 11

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 switches between Table Design grid and Field Properties pane in Access table workspace.

Question 12

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 13

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

Accepted Answer

The Caption property sets the text display of the label for the field in forms and reports, which is also the field name displayed in database objects.

Question 14

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

Text values should be enclosed within quotation marks to avoid syntax errors.

Question 15

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

Accepted Answer

Table Design grid

Question 16

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

Accepted Answer

The common field is used to link the tables together, and it must exist in both tables being joined in order to define the relationship.

Question 17

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. The other properties listed (Data type, Field size, Required) do not provide a means for explaining the purpose or use of a field.

Question 18

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

Accepted Answer

Access does not require a field description (also known as a field name or column header) for every field included in a table, but it is recommended for clarity and organization.

Question 19

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

Accepted Answer

Access does not require tables to have primary keys, but having a primary key helps to enforce data integrity and provide a unique identifier for each record in the table.

Question 20

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

Accepted Answer

composite key

Quiz 2: Building a Database and Defining Table Relationships

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

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

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

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

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

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

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

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

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

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

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