Question 1

Formatting Date/Time fields changes only the way data is displayed, not the field ____.

Accepted Answer

A) values 
B) letters 
C) numbers 
D) mask 
A) values 
B) letters 
C) numbers 
D) mask

Question 2

The common field between two tables in the Relationship window is indicated by a(n)____.

Accepted Answer

A) key icon 
B) field name 
C) join line 
D) infinity symbol 
A) key icon 
B) field name 
C) join line 
D) infinity symbol

Question 3

Which data type allows the designer to define the Field Size property?

Accepted Answer

A) Long Text 
B) Hyperlink 
C) Memo 
D) AutoNumber 
A) Long Text 
B) Hyperlink 
C) Memo 
D) AutoNumber

Question 4

____________________ is the process that allows data to be copied to an Access database table from a source without having to open the source file.

Accepted Answer

The answer of ____________________ is the process that allows data...

Question 5

The ____ property specifies the number of decimal places displayed to the right of the decimal point.

Accepted Answer

A) Decimal Places 
B) Input Mask 
C) Default Value 
D) Format 
A) Decimal Places 
B) Input Mask 
C) Default Value 
D) Format

Question 6

The data type that allows both sequential and random numbering is the ____ data type.

Accepted Answer

A) Number 
B) Currency 
C) AutoNumber 
D) Long Date 
A) Number 
B) Currency 
C) AutoNumber 
D) Long Date

Question 7

It is important that data being imported from a text file into Access are separated by a character, such as a comma, which defines the text file as a(n)____ text file.

Accepted Answer

A) imported 
B) readable 
C) delimited 
D) external 
A) imported 
B) readable 
C) delimited 
D) external

Question 8

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

A) True 
 B)False

Question 9

The ____ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition.

Accepted Answer

A) AutoNumber 
B) Short Text 
C) Yes/No 
D) Long Text 
A) AutoNumber 
B) Short Text 
C) Yes/No 
D) Long Text

Question 10

A primary key field from one table that is also a field in another table and is used to create a relationship between the two tables is a(n)____________________ in the second table.

Accepted Answer

The answer of A primary key field from one table...

Question 11

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

Accepted Answer

A) My table 
B) Table1 
C) ADB Table 
D) TableA 
A) My table 
B) Table1 
C) ADB Table 
D) TableA

Question 12

Match between columns
                        Premises: The term used when the same data is stored in more than one place which can cause inconsistencies in the database.

Accepted Answer

The Answer of Cascade Delete Related Records Option and data is...

Question 13

Match between columns
                        Premises: The Access option that permits a change in the value of the primary key in a table and changes the appropriate foreign key values in the related table.

Accepted Answer

The Answer of orphaned record and Cascade Update Related Fields is...

Question 14

Match between columns
                        Premises: A primary key that consists of two or more fields in a table.

Accepted Answer

The Answer of referential integrity and Quick Start selection and is...

Question 15

Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?

Accepted Answer

A) Yes/No 
B) Memo 
C) Text 
D) AutoNumber 
A) Yes/No 
B) Memo 
C) Text 
D) AutoNumber

Question 16

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.

Accepted Answer

A) entered value 
B) changed value 
C) default value 
D) permanent value 
A) entered value 
B) changed value 
C) default value 
D) permanent value

Question 17

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

A) True 
 B)False

Question 18

A custom date format set for a Date/Time field that contains the symbols mmm/dd/yy would display the date as ____.

Accepted Answer

A) July 4, 2016 
B) 07/04/16 
C) 7/4/2016 
D) Jul/04/16 
A) July 4, 2016 
B) 07/04/16 
C) 7/4/2016 
D) Jul/04/16

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

List six guidelines for designing databases.

Accepted Answer

1. Identify all the fields needed to pro

Formatting Date/Time fields changes only the way data is displayed, not the field ____.

The common field between two tables in the Relationship window is indicated by a(n)____.

Which data type allows the designer to define the Field Size property?

____________________ is the process that allows data to be copied to an Access database table from a source without having to open the source file.

The ____ property specifies the number of decimal places displayed to the right of the decimal point.

The data type that allows both sequential and random numbering is the ____ data type.

It is important that data being imported from a text file into Access are separated by a character, such as a comma, which defines the text file as a(n)____ text file.

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 ____ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition.

A primary key field from one table that is also a field in another table and is used to create a relationship between the two tables is a(n)____________________ in the second table.

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

Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.

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

A custom date format set for a Date/Time field that contains the symbols mmm/dd/yy would display the date as ____.

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

List six guidelines for designing databases.

Access-Module 1: Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 2: Building a Database and Defining Table Relationships

Formatting Date/Time fields changes only the way data is displayed, not the field ____.

The common field between two tables in the Relationship window is indicated by a(n)____.

Which data type allows the designer to define the Field Size property?

____________________ is the process that allows data to be copied to an Access database table from a source without having to open the source file.

The ____ property specifies the number of decimal places displayed to the right of the decimal point.

The data type that allows both sequential and random numbering is the ____ data type.

It is important that data being imported from a text file into Access are separated by a character, such as a comma, which defines the text file as a(n)____ text file.

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 ____ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition.

A primary key field from one table that is also a field in another table and is used to create a relationship between the two tables is a(n)____________________ in the second table.

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

Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.

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

A custom date format set for a Date/Time field that contains the symbols mmm/dd/yy would display the date as ____.

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

List six guidelines for designing databases.

Access-Module 1: Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters