Question 1

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

Accepted Answer

A) mm/dd/yyyy 
B) m/ddd/yy 
C) mmm/d/yyyy 
D) m/dd/yy 
A) mm/dd/yyyy 
B) m/ddd/yy 
C) mmm/d/yyyy 
D) m/dd/yy

Question 2

The ____________________ Field Size property of a Number field stores positive and negative numbers to precisely seven decimal places in four bytes.

Accepted Answer

The answer of The ____________________ Field Size property of a...

Question 3

____________________ is the process that allows data to be copied to an Access database table from a source without having to open the source file.

Accepted Answer

The answer of ____________________ is the process that allows data...

Question 4

Identify the letter of the choice that best matches the phrase or definition.
-The term used when the same data is stored in more than one place which can cause inconsistencies in the database.

Accepted Answer

A) Cascade Update Related Fields Option 
B) Cascade Delete Related Records Option 
C) Composite key 
D) data redundancy 
E) Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity 
A) Cascade Update Related Fields Option 
B) Cascade Delete Related Records Option 
C) Composite key 
D) data redundancy 
E) Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity

Question 5

Identify the letter of the choice that best matches the phrase or definition.
-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

A) Cascade Update Related Fields Option 
B) Cascade Delete Related Records Option 
C) Composite key 
D) data redundancy 
E) Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity 
A) Cascade Update Related Fields Option 
B) Cascade Delete Related Records Option 
C) Composite key 
D) data redundancy 
E) Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity

Question 6

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

Accepted Answer

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

Question 7

Identify the letter of the choice that best matches the phrase or definition.
-The Access option that deletes a record in the primary table and also deletes all records in related tables that have matching foreign key values.

Accepted Answer

A) Cascade Update Related Fields Option 
B) Cascade Delete Related Records Option 
C) Composite key 
D) data redundancy 
E) Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity 
A) Cascade Update Related Fields Option 
B) Cascade Delete Related Records Option 
C) Composite key 
D) data redundancy 
E) Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity

Question 8

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 9

Identify the letter of the choice that best matches the phrase or definition.
-The Access database view that allows users to define or modify a table structure or field properties in a table.

Accepted Answer

A) Cascade Update Related Fields Option 
B) Cascade Delete Related Records Option 
C) Composite key 
D) data redundancy 
E) Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity 
A) Cascade Update Related Fields Option 
B) Cascade Delete Related Records Option 
C) Composite key 
D) data redundancy 
E) Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity

Question 10

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 11

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 12

Identify the letter of the choice that best matches the phrase or definition.
-A record in a table that is related to a primary table but has no matching record established with the primary table.

Accepted Answer

A) Cascade Update Related Fields Option 
B) Cascade Delete Related Records Option 
C) Composite key 
D) data redundancy 
E) Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity 
A) Cascade Update Related Fields Option 
B) Cascade Delete Related Records Option 
C) Composite key 
D) data redundancy 
E) Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity

Question 13

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

Accepted Answer

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

Question 14

Identify the letter of the choice that best matches the phrase or definition.
-A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.

Accepted Answer

A) Cascade Update Related Fields Option 
B) Cascade Delete Related Records Option 
C) Composite key 
D) data redundancy 
E) Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity 
A) Cascade Update Related Fields Option 
B) Cascade Delete Related Records Option 
C) Composite key 
D) data redundancy 
E) Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity

Question 15

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

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

The ____________________ Field Size property of a Number field stores positive and negative numbers to precisely seven decimal places in four bytes.

____________________ is the process that allows data to be copied to an Access database table from a source without having to open the source file.

Identify the letter of the choice that best matches the phrase or definition. -The term used when the same data is stored in more than one place which can cause inconsistencies in the database.

Identify the letter of the choice that best matches the phrase or definition. -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.

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

Identify the letter of the choice that best matches the phrase or definition. -The Access option that deletes a record in the primary table and also deletes all records in related tables that have matching foreign key values.

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

Identify the letter of the choice that best matches the phrase or definition. -The Access database view that allows users to define or modify a table structure or field properties in a table.

Which of the following is the most logical data type to use if a field will contain long comments or explanations?

Identify the letter of the choice that best matches the phrase or definition. -A record in a table that is related to a primary table but has no matching record established with the primary table.

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

Identify the letter of the choice that best matches the phrase or definition. -A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.

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

Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters

Exam 2: Building a Database and Defining Table Relationships

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

The ____________________ Field Size property of a Number field stores positive and negative numbers to precisely seven decimal places in four bytes.

____________________ is the process that allows data to be copied to an Access database table from a source without having to open the source file.

Identify the letter of the choice that best matches the phrase or definition. -The term used when the same data is stored in more than one place which can cause inconsistencies in the database.

Identify the letter of the choice that best matches the phrase or definition. -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.

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

Identify the letter of the choice that best matches the phrase or definition. -The Access option that deletes a record in the primary table and also deletes all records in related tables that have matching foreign key values.

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

Identify the letter of the choice that best matches the phrase or definition. -The Access database view that allows users to define or modify a table structure or field properties in a table.

Which of the following is the most logical data type to use if a field will contain long comments or explanations?

Identify the letter of the choice that best matches the phrase or definition. -A record in a table that is related to a primary table but has no matching record established with the primary table.

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

Identify the letter of the choice that best matches the phrase or definition. -A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.

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

Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters