Question 1

Which table in the Chatham database is illustrated in the accompanying figure?

Accepted Answer

A)  Patient 
B)  Billing 
C)  Invoices 
D)  Payment 
A)  Patient 
B)  Billing 
C)  Invoices 
D)  Payment

Question 2

A custom date format set for a Date/Time field that contains the symbols mmm/dd/yy would display the date as ____.

Accepted Answer

A)  July 4, 2016 
B)  07/04/16 
C)  7/4/2016 
D)  Jul/04/16 
A)  July 4, 2016 
B)  07/04/16 
C)  7/4/2016 
D)  Jul/04/16

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

A primary key field from one table that is also a field in another table and is used to create a relationship between the two tables is a(n) ____________________ in the second table.

Accepted Answer

The answer of A primary key field from one table...

Question 6

External data are data that are imported from a source other than the current database without having to open the source file. _________________________

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)  Input Mask 
B)  Default Value 
C)  Format 
D)  Caption 
A)  Input Mask 
B)  Default Value 
C)  Format 
D)  Caption

Question 8

____ is the default name for a new table in an Access database.

Accepted Answer

A)  My table 
B)  Table1 
C)  ADB Table 
D)  TableA 
A)  My table 
B)  Table1 
C)  ADB Table 
D)  TableA

Question 9

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 10

In the accompanying figure, the ____ field has been selected to be moved in the Design view.

Accepted Answer

A)  InvoiceNum 
B)  InvoiceAmt 
C)  InvoiceDate 
D)  InvoicePaid 
A)  InvoiceNum 
B)  InvoiceAmt 
C)  InvoiceDate 
D)  InvoicePaid

Question 11

In the accompanying figure, the ____ is indicated by the red brackets.

Accepted Answer

A)  Design view 
B)  Field Properties pane 
C)  Datasheet view 
D)  Relationship pane 
A)  Design view 
B)  Field Properties pane 
C)  Datasheet view 
D)  Relationship pane

Question 12

Match between columns
                        Premises: The term used when the same data is stored in more than one place which can cause inconsistencies in the database.

Accepted Answer

The Answer of orphaned record and referential integrity and Cascade is...

Question 13

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
 
Considering the table in the figure above, which data type is best suited for the ActivityStartTime and the ActivityEndTime fields?

Accepted Answer

A)  Date/Time 
B)  Number 
C)  Memo 
D)  Short Text 
A)  Date/Time 
B)  Number 
C)  Memo 
D)  Short Text

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

In the accompanying figure, the highlighted record entries illustrate a database design with ____.

Accepted Answer

A)  extremely long character widths 
B)  data redundancy 
C)  a composite primary key 
D)  no field properties 
A)  extremely long character widths 
B)  data redundancy 
C)  a composite primary key 
D)  no field properties

Question 16

In the accompanying figure, fields inserted into the table using the Address Quick Start fields will be inserted prior to the ____ field.

Accepted Answer

A)  Phone 
B)  Email 
C)  Fax 
D)  PatientID 
A)  Phone 
B)  Email 
C)  Fax 
D)  PatientID

Question 17

Which data type allows the designer to define the Field Size property?

Accepted Answer

A)  Long Text 
B)  Hyperlink 
C)  Memo 
D)  AutoNumber 
A)  Long Text 
B)  Hyperlink 
C)  Memo 
D)  AutoNumber

Question 18

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 19

In the accompanying figure, the top portion of the table window indicated by the red bracket is the ____.

Accepted Answer

A)  Field Property grid 
B)  Table Design grid 
C)  General grid 
D)  Primary grid 
A)  Field Property grid 
B)  Table Design grid 
C)  General grid 
D)  Primary grid

Question 20

Match between columns
                        Premises: The Access option that permits a change in the value of the primary key in a table and changes the appropriate foreign key values in the related table.

Accepted Answer

The Answer of referential integrity and Design and Data Type is...

Which table in the Chatham database is illustrated in the accompanying figure?

A custom date format set for a Date/Time field that contains the symbols mmm/dd/yy would display the date as ____.

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

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

A primary key field from one table that is also a field in another table and is used to create a relationship between the two tables is a(n) ____________________ in the second table.

External data are data that are imported from a source other than the current database without having to open the source file. _________________________

____ is the default name for a new table in an Access database.

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

In the accompanying figure, the ____ field has been selected to be moved in the Design view.

In the accompanying figure, the ____ is indicated by the red brackets.

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

In the accompanying figure, the highlighted record entries illustrate a database design with ____.

In the accompanying figure, fields inserted into the table using the Address Quick Start fields will be inserted prior to the ____ field.

Which data type allows the designer to define the Field Size property?

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.

In the accompanying figure, the top portion of the table window indicated by the red bracket is the ____.

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

Which table in the Chatham database is illustrated in the accompanying figure?

A custom date format set for a Date/Time field that contains the symbols mmm/dd/yy would display the date as ____.

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

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

A primary key field from one table that is also a field in another table and is used to create a relationship between the two tables is a(n) ____________________ in the second table.

External data are data that are imported from a source other than the current database without having to open the source file. _________________________

____ is the default name for a new table in an Access database.

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

In the accompanying figure, the ____ field has been selected to be moved in the Design view.

In the accompanying figure, the ____ is indicated by the red brackets.

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

In the accompanying figure, the highlighted record entries illustrate a database design with ____.

In the accompanying figure, fields inserted into the table using the Address Quick Start fields will be inserted prior to the ____ field.

Which data type allows the designer to define the Field Size property?

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.

In the accompanying figure, the top portion of the table window indicated by the red bracket is the ____.

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