Question 1

When choosing field names, it is best to choose names that ____.

Accepted Answer

A)  include both numbers and letters in the name 
B)  use only uppercase characters 
C)  describe the content or purpose of the field 
D)  use only lowercase letters and no spaces 
A)  include both numbers and letters in the name 
B)  use only uppercase characters 
C)  describe the content or purpose of the field 
D)  use only lowercase letters and no spaces

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

In the accompanying figure, the primary key for the Vist table is the ____ field.

Accepted Answer

A)  PatientID 
B)  VisitDate 
C)  Reason 
D)  VisitID 
A)  PatientID 
B)  VisitDate 
C)  Reason 
D)  VisitID

Question 6

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 7

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 8

Match between columns
                        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.

Accepted Answer

The Answer of data redundancy and Quick Start selection and is...

Question 9

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 10

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

Accepted Answer

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

Question 11

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 12

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 13

Field names in a table may only be changed in Design view.

Accepted Answer

A) True 
 B)False

Question 14

A database system determines how to store, display, and process field values based on which of the following?

Accepted Answer

A)  field names 
B)  field properties 
C)  field captions 
D)  field size 
A)  field names 
B)  field properties 
C)  field captions 
D)  field size

Question 15

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 16

List six guidelines for designing databases.

Accepted Answer

1. Identify all the fields needed to pro

Question 17

Case-Based Critical Thinking Questions Case 2-2
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 18

The accompanying figure illustrates the ____ view which allows the user to modify a table structure.

Accepted Answer

A)  Datasheet 
B)  Relationship 
C)  Design 
D)  Grid 
A)  Datasheet 
B)  Relationship 
C)  Design 
D)  Grid

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

When choosing field names, it is best to choose names that ____.

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

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

In the accompanying figure, the primary key for the Vist table is the ____ field.

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

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

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

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

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

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.

Field names in a table may only be changed in Design view.

A database system determines how to store, display, and process field values based on which of the following?

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

List six guidelines for designing databases.

The accompanying figure illustrates the ____ view which allows the user to modify a table structure.

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

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

Managing Your Files

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 Sharing a Database

Filters

Exam 3: Building a Database and Defining Table Relationships

When choosing field names, it is best to choose names that ____.

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

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

In the accompanying figure, the primary key for the Vist table is the ____ field.

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

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

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

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

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

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.

Field names in a table may only be changed in Design view.

A database system determines how to store, display, and process field values based on which of the following?

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

List six guidelines for designing databases.

The accompanying figure illustrates the ____ view which allows the user to modify a table structure.

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

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

Managing Your Files

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 Sharing a Database

Filters