Question 1

In a single table, all ____________________ must be unique within that table.

Accepted Answer

The answer of In a single table, all ____________________ must...

Question 2

To begin importing data from an Excel spreadsheet, click on the ____ tab on the ribbon.

Accepted Answer

A) Create 
B) Database Tools 
C) External Data 
D) Home 
A) Create 
B) Database Tools 
C) External Data 
D) Home

Question 3

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 4

Relationship integrit y is a set of rules used by Access to maintain consistency between related tables when data in either table is updated. _________________________

Accepted Answer

A) True 
 B)False

Question 5

Match between columns
                        Premises: 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 Cascade Delete Related Records Option and Design is...

Question 6

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 7

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

Accepted Answer

Students should include at least three o

Question 8

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 9

Access automatically assigns the Number data type to all new fields.  
_________________________

Accepted Answer

A) True 
 B)False

Question 10

Case-Based Critical Thinking Questions
Interns Leah and Santana are organizing a summer camp for children ages 5-10 for their local recreation and parks agency. Participant and payment information is stored in an Excel spreadsheet as children are registered for activities. An Access database contains information about children (participants), parents, employees, as well as activity sessions and schedules. The database contains the following tables:
∙ Participant Information
∙ Parent Information
∙ Employees
∙ Activities
-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 11

Match between columns
                        Premises: The Access database view that allows users to define or modify a table structure or field properties in a table.

Accepted Answer

The Answer of Design and Data Type gallery and Cascade is...

Question 12

Match between columns
                        Premises: A record in a table that is related to a primary table but has no matching record established with the primary table.

Accepted Answer

The Answer of Composite key and propagate and orphaned record is...

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

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...

In a single table, all ____________________ must be unique within that table.

To begin importing data from an Excel spreadsheet, click on the ____ tab on the ribbon.

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.

Relationship integrit y is a set of rules used by Access to maintain consistency between related tables when data in either table is updated. _________________________

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

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

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.

Access automatically assigns the Number data type to all new fields. _________________________

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

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.

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

In a single table, all ____________________ must be unique within that table.

To begin importing data from an Excel spreadsheet, click on the ____ tab on the ribbon.

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.

Relationship integrit y is a set of rules used by Access to maintain consistency between related tables when data in either table is updated. _________________________

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

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

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.

Access automatically assigns the Number data type to all new fields. _________________________

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

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.

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