Question 1

Field names should help identify the data held in the field.

Accepted Answer

A) True 
 B)False

Question 2

A ________ rule verifies data entered into a field and ensures that the data is of the correct type for the field.

Accepted Answer

The answer of A ________ rule verifies data entered into...

Question 3

Spaces should be included in field names.

Accepted Answer

A) True 
 B)False

Question 4

Sheila is creating a database that will store student data. The database will contain a Field named DeansList. This field identifies whether or not a student appears on the dean's list. Sheila should use the ________ data type to this field.

Accepted Answer

The answer of Sheila is creating a database that will...

Question 5

Joe is working in a database that stores client data. He needs to design a field that will assign a client ID number each time a user enters a new client. The data type he should apply to this field is:

Accepted Answer

A)  Text 
B)  Memo 
C)  Number 
D)  AutoNumber 
A)  Text 
B)  Memo 
C)  Number 
D)  AutoNumber

Question 6

You cannot modify a multi-table query using the same methods used to modify a single table query.

Accepted Answer

A) True 
 B)False

Question 7

The value in a field with the ________ data type will be automatically increased each time a new record is entered.

Accepted Answer

A)  Currency 
B)  Date / Time 
C)  Number 
D)  AutoNumber 
A)  Currency 
B)  Date / Time 
C)  Number 
D)  AutoNumber

Question 8

Referential integrity should be enforced in a database with related tables because it

Accepted Answer

A)  makes the database easier to back up. 
B)  helps ensure invalid data is not entered into a table. 
C)  makes the database easier to repair. 
D)  helps ensure data is automatically updated. 
A)  makes the database easier to back up. 
B)  helps ensure invalid data is not entered into a table. 
C)  makes the database easier to repair. 
D)  helps ensure data is automatically updated.

Question 9

________ are used in the Relationships window to establish a relationship between two tables.

Accepted Answer

The answer of ________ are used in the Relationships window...

Question 10

In a query, which of the following statements is true regarding delimiters in the criterion of a field?

Accepted Answer

A)  Text data types must be enclosed in pound signs 
B)  Number data types require no delimiters 
C)  Date / Time data types must be enclosed in quotations 
D)  Number data types must be enclosed in single quotes 
A)  Text data types must be enclosed in pound signs 
B)  Number data types require no delimiters 
C)  Date / Time data types must be enclosed in quotations 
D)  Number data types must be enclosed in single quotes

Question 11

You want to create a table based on the data contained in an Excel spreadsheet. You will use the ________ tab to import the data from Excel.

Accepted Answer

The answer of You want to create a table based...

Question 12

Data redundancy may result in errors.

Accepted Answer

A) True 
 B)False

Question 13

The ________ determines what field values are allowed and what other properties the field will have.

Accepted Answer

A)  identity 
B)  attribute 
C)  record type 
D)  data type 
A)  identity 
B)  attribute 
C)  record type 
D)  data type

Question 14

The ________ data type can be used for fields that contain monetary values.

Accepted Answer

The answer of The ________ data type can be used...

Question 15

Which of the following statements is true about data types and delimiters?

Accepted Answer

A)  Numeric fields require quotation marks as delimiters 
B)  Text fields require pound signs as delimiters 
C)  Different data types require different delimiters 
D)  Different data types use the same delimiters 
A)  Numeric fields require quotation marks as delimiters 
B)  Text fields require pound signs as delimiters 
C)  Different data types require different delimiters 
D)  Different data types use the same delimiters

Question 16

Related ________ make up a table.

Accepted Answer

The answer of Related ________ make up a table....

Question 17

Access requires a primary key for every table.

Accepted Answer

A) True 
 B)False

Question 18

The ________ group on the External Data Tab has options that you can use to send a portion of a database to other application

Accepted Answer

A)  Import & Link 
B)  Export 
C)  Collect Data 
D)  Web Linked Lists 
A)  Import & Link 
B)  Export 
C)  Collect Data 
D)  Web Linked Lists

Question 19

Which field property type should be used to enter a predefined value into a field when most of the records will have the same value?

Accepted Answer

A)  Input Mask 
B)  Default Value 
C)  Validation Rule 
D)  Validation Text 
A)  Input Mask 
B)  Default Value 
C)  Validation Rule 
D)  Validation Text

Question 20

The ________ property can be used to create a label that appears in forms and reports.

Accepted Answer

The answer of The ________ property can be used to...

Field names should help identify the data held in the field.

A ________ rule verifies data entered into a field and ensures that the data is of the correct type for the field.

Spaces should be included in field names.

Sheila is creating a database that will store student data. The database will contain a Field named DeansList. This field identifies whether or not a student appears on the dean's list. Sheila should use the ________ data type to this field.

Joe is working in a database that stores client data. He needs to design a field that will assign a client ID number each time a user enters a new client. The data type he should apply to this field is:

You cannot modify a multi-table query using the same methods used to modify a single table query.

The value in a field with the ________ data type will be automatically increased each time a new record is entered.

Referential integrity should be enforced in a database with related tables because it

________ are used in the Relationships window to establish a relationship between two tables.

In a query, which of the following statements is true regarding delimiters in the criterion of a field?

You want to create a table based on the data contained in an Excel spreadsheet. You will use the ________ tab to import the data from Excel.

Data redundancy may result in errors.

The ________ determines what field values are allowed and what other properties the field will have.

The ________ data type can be used for fields that contain monetary values.

Which of the following statements is true about data types and delimiters?

Related ________ make up a table.

Access requires a primary key for every table.

The ________ group on the External Data Tab has options that you can use to send a portion of a database to other application

Which field property type should be used to enter a predefined value into a field when most of the records will have the same value?

The ________ property can be used to create a label that appears in forms and reports.

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Relational Databases and Queries

Excel: Customize, Analyze, and Summarize Query Data

Excel: Creating and Using Professional Forms and Reports

Access: Introduction to Powerpoint

Access: Presentation Design

Access: Powerpoint Rich Media Tools

Filters

Exam 16: Access: Presentation Development

Field names should help identify the data held in the field.

A ________ rule verifies data entered into a field and ensures that the data is of the correct type for the field.

Spaces should be included in field names.

Sheila is creating a database that will store student data. The database will contain a Field named DeansList. This field identifies whether or not a student appears on the dean's list. Sheila should use the ________ data type to this field.

Joe is working in a database that stores client data. He needs to design a field that will assign a client ID number each time a user enters a new client. The data type he should apply to this field is:

You cannot modify a multi-table query using the same methods used to modify a single table query.

The value in a field with the ________ data type will be automatically increased each time a new record is entered.

Referential integrity should be enforced in a database with related tables because it

________ are used in the Relationships window to establish a relationship between two tables.

In a query, which of the following statements is true regarding delimiters in the criterion of a field?

You want to create a table based on the data contained in an Excel spreadsheet. You will use the ________ tab to import the data from Excel.

Data redundancy may result in errors.

The ________ determines what field values are allowed and what other properties the field will have.

The ________ data type can be used for fields that contain monetary values.

Which of the following statements is true about data types and delimiters?

Related ________ make up a table.

Access requires a primary key for every table.

The ________ group on the External Data Tab has options that you can use to send a portion of a database to other application

Which field property type should be used to enter a predefined value into a field when most of the records will have the same value?

The ________ property can be used to create a label that appears in forms and reports.

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Relational Databases and Queries

Excel: Customize, Analyze, and Summarize Query Data

Excel: Creating and Using Professional Forms and Reports

Access: Introduction to Powerpoint

Access: Presentation Design

Access: Powerpoint Rich Media Tools

Filters