Question 1

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 2

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 3

The "one" table in a one-to-many relationship is the ____________________ table.

Accepted Answer

The answer of The "one" table in a one-to-many relationship...

Question 4

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

Accepted Answer

A) True 
 B)False

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

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 7

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 8

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 9

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 10

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 11

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 12

The ____ property allows the database designer to explain the purpose of a field or how a field is used.

Accepted Answer

A) Data type 
B) Field size 
C) Required 
D) Description 
A) Data type 
B) Field size 
C) Required 
D) Description

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Explain how a one-to-many relationship is created using an Access database with two or more tables. Why is it useful to create a relationship between tables?

Accepted Answer

​A one-to-many relationship exists betwe

Question 17

Discuss at least three advantages of including a primary key in a table.

Accepted Answer

Students should include at least three o

Question 18

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 19

Leah and Santana have been requested to print a daily report of scheduled activities. Their supervisor needs to know if each participant has paid for the activity. The ParticipantPD field will be included in the report. Which data type will allow the report to display a true/false condition for the ParticipantPD field?

Accepted Answer

A) Short Text 
B) Number 
C) Yes/No 
D) Currency 
A) Short Text 
B) Number 
C) Yes/No 
D) Currency

Question 20

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

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

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 "one" table in a one-to-many relationship is the ____________________ table.

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

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

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

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

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

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

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

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

The ____ property allows the database designer to explain the purpose of a field or how a field is used.

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

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

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

Explain how a one-to-many relationship is created using an Access database with two or more tables. Why is it useful to create a relationship between tables?

Discuss at least three advantages of including a primary key in a table.

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

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.

Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters

Exam 2: Building a Database and Defining Table Relationships

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

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 "one" table in a one-to-many relationship is the ____________________ table.

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

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

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

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

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

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

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

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

The ____ property allows the database designer to explain the purpose of a field or how a field is used.

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

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

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

Explain how a one-to-many relationship is created using an Access database with two or more tables. Why is it useful to create a relationship between tables?

Discuss at least three advantages of including a primary key in a table.

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

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.

Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters