Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

Which of the following is the most logical data type to use if a field will contain long comments or explanations?

Accepted Answer

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

Question 5

The ____________________ data type is not subject to round-off error when calculated, unlike the Number data type with decimal values.

Accepted Answer

The answer of The ____________________ data type is not subject...

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

A field in an Access database table that has no value is determined by Access to have a ____ value.

Accepted Answer

A)  custom 
B)  zero 
C)  null 
D)  number 
A)  custom 
B)  zero 
C)  null 
D)  number

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

The way field values are stored, displayed, and processed in an Access database is determined by the ____________________.

Accepted Answer

The answer of The way field values are stored, displayed,...

Question 10

Which symbols would be used to create a custom date format that would display July 4, 2016 as 7/04/16?

Accepted Answer

A)  mm/dd/yyyy 
B)  m/ddd/yy 
C)  mmm/d/yyyy 
D)  m/dd/yy 
A)  mm/dd/yyyy 
B)  m/ddd/yy 
C)  mmm/d/yyyy 
D)  m/dd/yy

Question 11

A field used to connect one table logically with another table is called a ____ field.

Accepted Answer

A)  common 
B)  primary 
C)  composite 
D)  data 
A)  common 
B)  primary 
C)  composite 
D)  data

Question 12

Performing a(n) ____________________ is the process of relating tables in a database based on a common field.

Accepted Answer

The answer of Performing a(n) ____________________ is the process of...

Question 13

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 14

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.
A primary key that consists of two or more fields in a table.
A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.
A record in a table that is related to a primary table but has no matching record established with the primary table.
The term used when the same data is stored in more than one place which can cause inconsistencies in the database.
The Access option that deletes a record in the primary table and also deletes all records in related tables that have matching foreign key values.
The Access database view that allows users to define or modify a table structure or field properties in a table.
An Access feature available from the FIELDS tab that allows the user to add a group of related fields to a table at the same time.
A group of fields added all at once using the Data Type gallery.
The process that occurs when the field Description (Optional) property is changed in Design View and the Property Update Options tool is used to update the entire database everywhere the field is used, including forms and reports.

Accepted Answer

The Answer of Quick Start selection and Data Type gallery is...

Question 15

A relationship between Access tables that is a relationship between one record in the first table and zero, one, or many records in the second table, and at least one record in the second table matches at most one record in the first table, is defined as a ____ relationship.

Accepted Answer

A)  One-to-One 
B)  One-to-Many 
C)  One-to-Most 
D)  Many-to-One 
A)  One-to-One 
B)  One-to-Many 
C)  One-to-Most 
D)  Many-to-One

Question 16

____ 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 17

Field name display in database objects such as datasheets, forms, and reports is determined by the ____________________ property.

Accepted Answer

The answer of Field name display in database objects such...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

One rule of ____________________ is that Access prevents the primary key from being changed in the primary table of a relationship if a matching record exists in a related table.

Accepted Answer

referentia

Question 20

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

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

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

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

Which of the following is the most logical data type to use if a field will contain long comments or explanations?

The ____________________ data type is not subject to round-off error when calculated, unlike the Number data type with decimal values.

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

A field in an Access database table that has no value is determined by Access to have a ____ value.

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

The way field values are stored, displayed, and processed in an Access database is determined by the ____________________.

Which symbols would be used to create a custom date format that would display July 4, 2016 as 7/04/16?

A field used to connect one table logically with another table is called a ____ field.

Performing a(n) ____________________ is the process of relating tables in a database based on a common field.

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

A relationship between Access tables that is a relationship between one record in the first table and zero, one, or many records in the second table, and at least one record in the second table matches at most one record in the first table, is defined as a ____ relationship.

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

Field name display in database objects such as datasheets, forms, and reports is determined by the ____________________ property.

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

One rule of ____________________ is that Access prevents the primary key from being changed in the primary table of a relationship if a matching record exists in a related table.

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

Word Module Access Module Creating a Database

Access Module Maintaining and Querying a Database

Word Module Creating and Editing a Document

Word Module 2: Navigating and Formatting a Document

Excel Module Getting Started With Excel

Excel Module Formatting Workbook Text and Data

Excel Module Performing Calculations With Formulas and Functions

Powerpoint Module Creating a Presentation

Managing Your Files

Communicating With Microsoft Outlook Angel

Productivity Apps for School and Work

Filters

Exam 2: Access Module : Building a Database and Defining Table Relationships

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

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

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

Which of the following is the most logical data type to use if a field will contain long comments or explanations?

The ____________________ data type is not subject to round-off error when calculated, unlike the Number data type with decimal values.

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

A field in an Access database table that has no value is determined by Access to have a ____ value.

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

The way field values are stored, displayed, and processed in an Access database is determined by the ____________________.

Which symbols would be used to create a custom date format that would display July 4, 2016 as 7/04/16?

A field used to connect one table logically with another table is called a ____ field.

Performing a(n) ____________________ is the process of relating tables in a database based on a common field.

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

A relationship between Access tables that is a relationship between one record in the first table and zero, one, or many records in the second table, and at least one record in the second table matches at most one record in the first table, is defined as a ____ relationship.

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

Field name display in database objects such as datasheets, forms, and reports is determined by the ____________________ property.

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

One rule of ____________________ is that Access prevents the primary key from being changed in the primary table of a relationship if a matching record exists in a related table.

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

Word Module Access Module Creating a Database

Access Module Maintaining and Querying a Database

Word Module Creating and Editing a Document

Word Module 2: Navigating and Formatting a Document

Excel Module Getting Started With Excel

Excel Module Formatting Workbook Text and Data

Excel Module Performing Calculations With Formulas and Functions

Powerpoint Module Creating a Presentation

Managing Your Files

Communicating With Microsoft Outlook Angel

Productivity Apps for School and Work

Filters