Exam 2: Building a Database and Defining Table Relationships

Identify the letter of the choice that best matches the phrase or definition.

Premises:

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.

Responses:

Cascade Update Related Fields Option

Quick Start selection

data redundancy

Correct Answer:

Verified

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.

(Matching)

4.8/5

(25)

Question 41

A key or combination of keys that complete an action more efficiently than using the mouse is called a(n)keyboard shortcut . _________________________

(True/False)

4.9/5

(29)

Question 42

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

(True/False)

4.8/5

(37)

Question 43

The F6 key toggles the Access table workspace between the Table Design grid and the Field Properties pane. _________________________

(True/False)

4.9/5

(38)

Question 44

The field name displayed in database objects, including forms and reports, is determined by the Caption property . _________________________

(True/False)

4.9/5

(30)

Question 45

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

(True/False)

4.9/5

(25)

Question 46

Identify the letter of the choice that best matches the phrase or definition.

Premises:

A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.

Responses:

data redundancy

Quick Start selection

Cascade Update Related Fields Option

Correct Answer:

Verified

A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.

(Matching)

4.8/5

(37)

Question 47

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

(Short Answer)

4.8/5

(43)

Question 48

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

(Short Answer)

4.8/5

(43)

Question 49

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

(True/False)

4.9/5

(41)

Question 50

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

(Multiple Choice)

4.7/5

(41)

Question 51

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 -After printing a report of parent information for camper pick-up monitors, Santana decides some of the field names displayed on the report are hard to read. For example, she prefers the field MotherMobilePhone to be displayed as Mother Cell on the report. Which field property should be changed to modify the field name display on the report?

(Multiple Choice)

4.8/5

(32)

Question 52

____________________ values are never allowed by Access in the primary key field.

(Short Answer)

5.0/5

(37)

Question 53

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

(True/False)

4.9/5

(30)

Question 54

____________________ view allows the database designer to enter both the field names and define the field properties.

(Short Answer)

4.9/5

(36)

Question 55

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

(True/False)

4.9/5

(30)

Question 56

Which data type would be the best logical data type for a field named PaidDate?

(Multiple Choice)

4.9/5

(43)

Question 57

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

(Multiple Choice)

4.9/5

(30)

Question 58

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

(Multiple Choice)

4.8/5

(30)

Question 59

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

(True/False)

4.9/5

(32)

Question 60

Showing 41 - 60 of 75

A key or combination of keys that complete an action more efficiently than using the mouse is called a(n)keyboard shortcut . _________________________

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

The F6 key toggles the Access table workspace between the Table Design grid and the Field Properties pane. _________________________

The field name displayed in database objects, including forms and reports, is determined by the Caption property . _________________________

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

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

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

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

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

____________________ values are never allowed by Access in the primary key field.

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

____________________ view allows the database designer to enter both the field names and define the field properties.

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

Which data type would be the best logical data type for a field named PaidDate?

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

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

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

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