Question 1

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 A

Question 2

The ____ property specifies the number of decimal places displayed to the right of the decimal point.

Accepted Answer

A)  Decimal Places 
B)  Input Mask 
C)  Default Value 
D)  Format 
A)  Decimal Places 
B)  Input Mask 
C)  Default Value 
D)  Format A

Question 3

Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database.

Accepted Answer

A) True 
 B)False  True

Question 4

In the accompanying figure, the field size is set to ____.

Accepted Answer

A)  Short text 
B)  InvoiceNum 
C)  General 
D)  5 
A)  Short text 
B)  InvoiceNum 
C)  General 
D)  5

Question 5

Predefined display formats for fields with the Date/Time data type may be chosen from the ____ field property.

Accepted Answer

A)  Input Mask 
B)  Format 
C)  Default Value 
D)  Text Align 
A)  Input Mask 
B)  Format 
C)  Default Value 
D)  Text Align

Question 6

In the accompanying figure, once the selected field is moved it will appear above which field in Design view?

Accepted Answer

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

Question 7

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 Data Type gallery and referential integrity and is...

Question 8

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

Accepted Answer

Students should include at least three o

Question 9

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

Accepted Answer

The answer of ____________________ view allows the database designer to...

Question 10

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 11

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 12

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 13

It is important that data being imported from a text file into Access are separated by a character, such as a comma, which defines the text file as a(n) ____ text file.

Accepted Answer

A)  imported 
B)  readable 
C)  delimited 
D)  external 
A)  imported 
B)  readable 
C)  delimited 
D)  external

Question 14

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

Accepted Answer

The answer of ____________________ values are never allowed by Access...

Question 15

In the accompanying figure, what is the name of the table being edited?

Accepted Answer

A)  Invoices 
B)  InvoicePaid 
C)  Chatham 
D)  Billing 
A)  Invoices 
B)  InvoicePaid 
C)  Chatham 
D)  Billing

Question 16

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
Several participants registered for activities late as other participants cancelled.  These participants need to be added to the Participants table.  What is the most expedient way to add these participants and their paid status to the Participants table?

Accepted Answer

A)  type the information for each participant in the Participants table in datasheet view 
B)  import the data from the Excel spreadsheet into the Participants table 
C)  type the ParticipantID in the Participants table and link to the Excel spreadsheet 
D)  drag the Excel spreadsheet over the Participants table and the table will be updated 
A)  type the information for each participant in the Participants table in datasheet view 
B)  import the data from the Excel spreadsheet into the Participants table 
C)  type the ParticipantID in the Participants table and link to the Excel spreadsheet 
D)  drag the Excel spreadsheet over the Participants table and the table will be updated

Question 17

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 18

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 Design and orphaned record and Quick Start is...

Question 19

Case-Based Critical Thinking Questions Case 2-3
Syed and Marino Li own a small furniture consignment shop in Atlanta, GA. Syed is designing a database that will allow them to keep track of item information and seller information.  Each item is assigned to one seller; however, each seller may be assigned multiple items in the database. The database will contain the following information: item identification number, item description, seller code, condition of item, retail price of item, item quantity, date item received, condition of item, date the item is sold, the final sale price of the item, seller name, seller address, and seller contact information.  Using appropriate database design guidelines, answer the following questions.
Based on the information to be included in the database, what is the best way to avoid data redundancy in the database?

Accepted Answer

A)  store data for each field in only one table (excluding the common field) 
B)  store data for each field in multiple tables (excluding the common field) 
C)  create a composite primary key (including the common field) 
D)  change field properties for all fields to require data input 
A)  store data for each field in only one table (excluding the common field) 
B)  store data for each field in multiple tables (excluding the common field) 
C)  create a composite primary key (including the common field) 
D)  change field properties for all fields to require data input

Question 20

The default Field Size for the Short Text data type is ____________________ characters.

Accepted Answer

The answer of The default Field Size for the Short...

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

The ____ property specifies the number of decimal places displayed to the right of the decimal point.

Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database.

In the accompanying figure, the field size is set to ____.

Predefined display formats for fields with the Date/Time data type may be chosen from the ____ field property.

In the accompanying figure, once the selected field is moved it will appear above which field in Design view?

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

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

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

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

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

It is important that data being imported from a text file into Access are separated by a character, such as a comma, which defines the text file as a(n) ____ text file.

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

In the accompanying figure, what is the name of the table being edited?

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

The default Field Size for the Short Text data type is ____________________ characters.

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

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

The ____ property specifies the number of decimal places displayed to the right of the decimal point.

Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database.

In the accompanying figure, the field size is set to ____.

Predefined display formats for fields with the Date/Time data type may be chosen from the ____ field property.

In the accompanying figure, once the selected field is moved it will appear above which field in Design view?

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

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

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

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

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

It is important that data being imported from a text file into Access are separated by a character, such as a comma, which defines the text file as a(n) ____ text file.

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

In the accompanying figure, what is the name of the table being edited?

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

The default Field Size for the Short Text data type is ____________________ characters.

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