Question 1

The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

Accepted Answer

The answer of The "many" side of a one-to-many relationship...

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

A database management system is a useful tool only if it meets which of the following criteria?

Accepted Answer

A)  produces reports 
B)  contains simple records 
C)  meets the needs of its users 
D)  meets the needs of the designer 
A)  produces reports 
B)  contains simple records 
C)  meets the needs of its users 
D)  meets the needs of the designer

Question 5

Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail?

Accepted Answer

A)  there is no relationship between tables 
B)  the Excel and Access caption property values to do not match 
C)  the data was entered incorrectly 
D)  the Access field names and the Excel worksheet column headings do not match 
A)  there is no relationship between tables 
B)  the Excel and Access caption property values to do not match 
C)  the data was entered incorrectly 
D)  the Access field names and the Excel worksheet column headings do not match

Question 6

The default character length for the Short Text data type is ____ characters.

Accepted Answer

A)  55 
B)  255 
C)  64 
D)  15 
A)  55 
B)  255 
C)  64 
D)  15

The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

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

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

A database management system is a useful tool only if it meets which of the following criteria?

Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail?

The default character length for the Short Text data type is ____ characters.

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

The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

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

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

A database management system is a useful tool only if it meets which of the following criteria?

Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail?

The default character length for the Short Text data type is ____ characters.

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