Question 1

Creating a new database simply makes a file that becomes the container for all database elements.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

A(n) ____________________ database is very flexible because it can store data for several different but related categories.

Accepted Answer

The answer of A(n) ____________________ database is very flexible because...

Question 4

Data import options are listed on Access's IMPORT/EXPORT DATA tab.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following icons should you click to save the table?

Accepted Answer

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

Question 6

Referring to the accompanying figure, which callout points to the button you can click to create simple queries quickly?

Accepted Answer

A)  E 
B)  B 
C)  C 
D)  H 
A)  E 
B)  B 
C)  C 
D)  H

Question 7

New records are always added at the ____________________ of the table.

Accepted Answer

The answer of New records are always added at the...

Question 8

A _____ contains one record.

Accepted Answer

A)  cell 
B)  column 
C)  row 
D)  table 
A)  cell 
B)  column 
C)  row 
D)  table

Question 9

A primary key is a field that ____________________ identifies each record.

Accepted Answer

The answer of A primary key is a field that...

Question 10

The field that uniquely identifies records in a table is called a(n) _____.

Accepted Answer

A)  secondary key 
B)  primary key 
C)  search key 
D)  identifier 
A)  secondary key 
B)  primary key 
C)  search key 
D)  identifier

Question 11

To identify the table you should give it a(n) _____ name.

Accepted Answer

A)  unique and short 
B)  numeric 
C)  unique and descriptive 
D)  automatically generated 
A)  unique and short 
B)  numeric 
C)  unique and descriptive 
D)  automatically generated

Question 12

Use the AutoNumber data type for fields that contain numeric data.

Accepted Answer

A) True 
 B)False

Question 13

An empty table does not contain any fields.

Accepted Answer

A) True 
 B)False

Question 14

Microsoft Excel is the component of the Microsoft Office suite best suited for working with large collections of data.

Accepted Answer

A) True 
 B)False

Question 15

All of the following are controls for operations that can be performed on a table, except _____.

Accepted Answer

A)  Delete a record 
B)  Sort records 
C)  Move a record 
D)  Search 
A)  Delete a record 
B)  Sort records 
C)  Move a record 
D)  Search

Creating a new database simply makes a file that becomes the container for all database elements.

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

A(n) ____________________ database is very flexible because it can store data for several different but related categories.

Data import options are listed on Access's IMPORT/EXPORT DATA tab.

Which of the following icons should you click to save the table?

Referring to the accompanying figure, which callout points to the button you can click to create simple queries quickly?

New records are always added at the ____________________ of the table.

A _____ contains one record.

A primary key is a field that ____________________ identifies each record.

The field that uniquely identifies records in a table is called a(n) _____.

To identify the table you should give it a(n) _____ name.

Use the AutoNumber data type for fields that contain numeric data.

An empty table does not contain any fields.

Microsoft Excel is the component of the Microsoft Office suite best suited for working with large collections of data.

All of the following are controls for operations that can be performed on a table, except _____.

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

Exam 17: Creating a Database

Creating a new database simply makes a file that becomes the container for all database elements.

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

A(n) ____________________ database is very flexible because it can store data for several different but related categories.

Data import options are listed on Access's IMPORT/EXPORT DATA tab.

Which of the following icons should you click to save the table?

Referring to the accompanying figure, which callout points to the button you can click to create simple queries quickly?

New records are always added at the ____________________ of the table.

A _____ contains one record.

A primary key is a field that ____________________ identifies each record.

The field that uniquely identifies records in a table is called a(n) _____.

To identify the table you should give it a(n) _____ name.

Use the AutoNumber data type for fields that contain numeric data.

An empty table does not contain any fields.

Microsoft Excel is the component of the Microsoft Office suite best suited for working with large collections of data.

All of the following are controls for operations that can be performed on a table, except _____.

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