Question 1

In Access,field names cannot contain digits.

Accepted Answer

A) True 
 B)False

Question 2

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

Accepted Answer

A) True 
 B)False

Question 3

____________________ view has more functionality for creating a table than Datasheet view.

Accepted Answer

The answer of ____________________ view has more functionality for creating...

Question 4

A field whose data type is ____ can contain any characters.

Accepted Answer

A)  Alpha 
B)  Character 
C)  Normal 
D)  Short Text 
A)  Alpha 
B)  Character 
C)  Normal 
D)  Short Text

Question 5

Identify the letter of the choice that best matches the phrase or definition.
-View that shows a report as it will appear when printed.

Accepted Answer

A) AutoNumber 
B) Layout view 
C) DBDL 
D) Report view 
E) Long Text
F)Currency
G)Metadata
H)Print Preview
I)Short Text
J)status bar 
A) AutoNumber 
B) Layout view 
C) DBDL 
D) Report view 
E) Long Text
F)Currency
G)Metadata
H)Print Preview
I)Short Text
J)status bar

Question 6

The ____________________ data type in Access is referred to as Money in SQL Server.

Accepted Answer

The answer of The ____________________ data type in Access is...

Question 7

To rename a database object,press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

Accepted Answer

A)  New Name 
B)  Redefine 
C)  Rename 
D)  Save Name 
A)  New Name 
B)  Redefine 
C)  Rename 
D)  Save Name

Question 8

Identify the letter of the choice that best matches the phrase or definition.
-Can include such information as the file's author,title,or subject.

Accepted Answer

A) AutoNumber 
B) Layout view 
C) DBDL 
D) Report view 
E) Long Text
F)Currency
G)Metadata
H)Print Preview
I)Short Text
J)status bar 
A) AutoNumber 
B) Layout view 
C) DBDL 
D) Report view 
E) Long Text
F)Currency
G)Metadata
H)Print Preview
I)Short Text
J)status bar

Question 9

-As shown in the accompanying figure,you can move to the first record in a table by clicking the Start record Navigation button.

Accepted Answer

A) True 
 B)False

Question 10

The rows in the tables are called ____________________.

Accepted Answer

The answer of The rows in the tables are called...

Question 11

In Datasheet view,a table is represented as a collection of rows and columns called a list.

Accepted Answer

A) True 
 B)False

Question 12

Identify the letter of the choice that best matches the phrase or definition.
-Presents information about the database object,the progress of current tasks,and the status of certain commands and keys.

Accepted Answer

A) AutoNumber 
B) Layout view 
C) DBDL 
D) Report view 
E) Long Text
F)Currency
G)Metadata
H)Print Preview
I)Short Text
J)status bar 
A) AutoNumber 
B) Layout view 
C) DBDL 
D) Report view 
E) Long Text
F)Currency
G)Metadata
H)Print Preview
I)Short Text
J)status bar

Question 13

Changing the column width in a datasheet changes the structure of a table.

Accepted Answer

A) True 
 B)False

Question 14

To import data to a table,tap or click the ____ tab on the ribbon.

Accepted Answer

A)  DATABASE TOOLS 
B)  FILE 
C)  EXTERNAL DATA 
D)  IMPORT 
A)  DATABASE TOOLS 
B)  FILE 
C)  EXTERNAL DATA 
D)  IMPORT

Question 15

Case 1-2
Now that Joe has created the tables and determined the primary and foreign keys,he needs to determine the data types for the fields in each table.
-What data type should Joe use for the Completion Date field?

Accepted Answer

Joe should use the D

Question 16

To delete a record,tap or click the record selector for the record,and then press the ____ key(s).

Accepted Answer

A)  CTRL+DELETE 
B)  CTRL+Y 
C)  DELETE 
D)  CTRL+K 
A)  CTRL+DELETE 
B)  CTRL+Y 
C)  DELETE 
D)  CTRL+K

Question 17

Landscape orientation means the printout is across the length (height)of the page.

Accepted Answer

A) True 
 B)False

Question 18

A field whose data type is ____ can store an OLE object,which is an object linked to or embedded in the table.

Accepted Answer

A)  Illustration 
B)  Image 
C)  Bitmap 
D)  OLE object 
A)  Illustration 
B)  Image 
C)  Bitmap 
D)  OLE object

Question 19

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

Accepted Answer

A) True 
 B)False

Question 20

The Currency data type is used for fields that contain only monetary data.

Accepted Answer

A) True 
 B)False

In Access,field names cannot contain digits.

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

____________________ view has more functionality for creating a table than Datasheet view.

A field whose data type is ____ can contain any characters.

Identify the letter of the choice that best matches the phrase or definition. -View that shows a report as it will appear when printed.

The ____________________ data type in Access is referred to as Money in SQL Server.

To rename a database object,press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

Identify the letter of the choice that best matches the phrase or definition. -Can include such information as the file's author,title,or subject.

-As shown in the accompanying figure,you can move to the first record in a table by clicking the Start record Navigation button.

The rows in the tables are called ____________________.

In Datasheet view,a table is represented as a collection of rows and columns called a list.

Identify the letter of the choice that best matches the phrase or definition. -Presents information about the database object,the progress of current tasks,and the status of certain commands and keys.

Changing the column width in a datasheet changes the structure of a table.

To import data to a table,tap or click the ____ tab on the ribbon.

Case 1-2 Now that Joe has created the tables and determined the primary and foreign keys,he needs to determine the data types for the fields in each table. -What data type should Joe use for the Completion Date field?

To delete a record,tap or click the record selector for the record,and then press the ____ key(s).

Landscape orientation means the printout is across the length (height)of the page.

A field whose data type is ____ can store an OLE object,which is an object linked to or embedded in the table.

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

The Currency data type is used for fields that contain only monetary data.

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Introduction to Technology

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

Excel: Working With Large Worksheets, Charting, and What-If Analysis

Access: Querying a Database

Access: Maintaining a Database

Filters

Exam 15: Access: Databases and Database Objects: an Introduction

In Access,field names cannot contain digits.

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

____________________ view has more functionality for creating a table than Datasheet view.

A field whose data type is ____ can contain any characters.

Identify the letter of the choice that best matches the phrase or definition. -View that shows a report as it will appear when printed.

The ____________________ data type in Access is referred to as Money in SQL Server.

To rename a database object,press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

Identify the letter of the choice that best matches the phrase or definition. -Can include such information as the file's author,title,or subject.

-As shown in the accompanying figure,you can move to the first record in a table by clicking the Start record Navigation button.

The rows in the tables are called ____________________.

In Datasheet view,a table is represented as a collection of rows and columns called a list.

Identify the letter of the choice that best matches the phrase or definition. -Presents information about the database object,the progress of current tasks,and the status of certain commands and keys.

Changing the column width in a datasheet changes the structure of a table.

To import data to a table,tap or click the ____ tab on the ribbon.

Case 1-2 Now that Joe has created the tables and determined the primary and foreign keys,he needs to determine the data types for the fields in each table. -What data type should Joe use for the Completion Date field?

To delete a record,tap or click the record selector for the record,and then press the ____ key(s).

Landscape orientation means the printout is across the length (height)of the page.

A field whose data type is ____ can store an OLE object,which is an object linked to or embedded in the table.

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

The Currency data type is used for fields that contain only monetary data.

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Introduction to Technology

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

Excel: Working With Large Worksheets, Charting, and What-If Analysis

Access: Querying a Database

Access: Maintaining a Database

Filters