Question 1

The primary key is an important field in an Access table. Please describe a primary key. Does Access create the primary key or can you create it yourself?

Accepted Answer

- A primary key is a field that uniquely identifies each record. It's very important that no two records are ever assigned the same value for this unique field. 
- It's usually best to have Access create the primary key .  If the ID field's data type is AutoNumber, Access automatically assigns a unique value to each record, beginning with 1 for the first record. 
- As an alternative, you can select your own primary ke y. For example, you could use each contact's Social Security number as the primary key.

Question 2

You should use the _____ data type for fields that contain variable length data, such as comments, notes, and reviews.

Accepted Answer

A)  Short Text 
B)  Long Text 
C)  Number 
D)  AutoNumber 
A)  Short Text 
B)  Long Text 
C)  Number 
D)  AutoNumber B

Question 3

You should use the _____ data type for fields that contain True/False values.

Accepted Answer

A)  Short Text 
B)  AutoNumber 
C)  Number 
D)  Yes/No 
A)  Short Text 
B)  AutoNumber 
C)  Number 
D)  Yes/No D

Question 4

When you create a new database, Access creates an empty table called _____.

Accepted Answer

A)  Access Table1 
B)  Database Table1 
C)  New Table 
D)  Table1 
A)  Access Table1 
B)  Database Table1 
C)  New Table 
D)  Table1

Question 5

An ID field's data type is IntNumber .

Accepted Answer

A) True 
 B)False

Question 6

A(n) ____________________ contains criteria that specify what you would like to find.

Accepted Answer

The answer of A(n) ____________________ contains criteria that specify what...

Question 7

When you start Access, which of the following options are available?

Accepted Answer

A)  create a new database only 
B)  save a database 
C)  open an existing database only 
D)  create a new database or open an existing one 
A)  create a new database only 
B)  save a database 
C)  open an existing database only 
D)  create a new database or open an existing one

Question 8

Which of the following buttons should you click to add all fields to the query?

Accepted Answer

A)    
B)    
C)    
D)    
A)    
B)    
C)    
D)

Question 9

Each category of data is stored in a database ____________________.

Accepted Answer

The answer of Each category of data is stored in...

Question 10

Import options are listed on Access's _____ tab.

Accepted Answer

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

Question 11

Elements that make up the database include tables, requests , forms, and queries.

Accepted Answer

A) True 
 B)False

Question 12

You should use the _____ data type for fields that contain words and symbols of up to 255 characters in length.

Accepted Answer

A)  Short Text 
B)  Long Text 
C)  Number 
D)  AutoNumber 
A)  Short Text 
B)  Long Text 
C)  Number 
D)  AutoNumber

Question 13

Access provides several tools you can use to manipulate the database, and they are contained in the Navigation Pane on the right side of the database window.

Accepted Answer

A) True 
 B)False

Question 14

The Short Text data type is used for fields that contain words and symbols of up to _____ characters in length.

Accepted Answer

A)  128 
B)  256 
C)  255 
D)  64 
A)  128 
B)  256 
C)  255 
D)  64

Question 15

A(n) ____________________ file is simply data separated by commas.

Accepted Answer

The answer of A(n) ____________________ file is simply data separated...

Question 16

The quickest way to save a table is to click the Save button on the ____________________ toolbar.

Accepted Answer

The answer of The quickest way to save a table...

Question 17

What is the maximum length for a field name?

Accepted Answer

A)  32 characters 
B)  64 characters 
C)  16 characters 
D)  20 characters 
A)  32 characters 
B)  64 characters 
C)  16 characters 
D)  20 characters

Question 18

To enter the field name, simply type it, then press the ____________________ key.

Accepted Answer

The answer of To enter the field name, simply type...

Question 19

After a query is saved, you can run it repeatedly to display all the records that match the criteria you've specified.

Accepted Answer

A) True 
 B)False

Question 20

The field you use for the primary key should have a checkmark in the _____ box.

Accepted Answer

A)  Required 
B)  Indexed 
C)  Validated 
D)  Unique 
A)  Required 
B)  Indexed 
C)  Validated 
D)  Unique

Exam 17: Creating a Database

The primary key is an important field in an Access table. Please describe a primary key. Does Access create the primary key or can you create it yourself?

You should use the _____ data type for fields that contain variable length data, such as comments, notes, and reviews.

You should use the _____ data type for fields that contain True/False values.

When you create a new database, Access creates an empty table called _____.

An ID field's data type is IntNumber .

A(n) ____________________ contains criteria that specify what you would like to find.

When you start Access, which of the following options are available?

Which of the following buttons should you click to add all fields to the query?

Each category of data is stored in a database ____________________.

Import options are listed on Access's _____ tab.

Elements that make up the database include tables, requests , forms, and queries.

You should use the _____ data type for fields that contain words and symbols of up to 255 characters in length.

Access provides several tools you can use to manipulate the database, and they are contained in the Navigation Pane on the right side of the database window.

The Short Text data type is used for fields that contain words and symbols of up to _____ characters in length.

A(n) ____________________ file is simply data separated by commas.

The quickest way to save a table is to click the Save button on the ____________________ toolbar.

What is the maximum length for a field name?

To enter the field name, simply type it, then press the ____________________ key.

After a query is saved, you can run it repeatedly to display all the records that match the criteria you've specified.

The field you use for the primary key should have a checkmark in the _____ box.

Computer Hardware

Peripheral Devices

System and Application Software

Installing Software

Getting Started With Windows

Working With Windows Settings and Accounts

Working With Files

Getting Started With Application Software

Creating a Document

Formatting a Document

Finalizing a Document

Creating a Worksheet

Formatting a Worksheet

Finalizing a Worksheet

Creating a Presentation

Finalizing a Presentation

Finalizing a Database

Networks

Working With E-Mail

Browsing the Web

Computer Benefits and Risks

Filters