access HW

Question 1

Which view does not display the data, but allows you to change the field properties?

Datasheet view

Form view

Design view

Layout view

Question 2

Constants, functions, operators, and identifiers are combined to create this. 

Formula

Action query

Expression

Control

Question 3

This view displays exactly how a report will look when printed and can be used to modify the page layout.

Layout view

Design view

Print Preview

Reading view

Question 4

The 348 area code has been changed to a new 704 area code. To quickly update all your records, use this feature. 

Drag and Drop

Hide and Seek

Cut and Paste

Find and Replace

Question 5

A symbol or word in an expression that indicates the operation to be performed is called a: 

variable

operator

value

symbol

Question 6

You can change the column order in a query datasheet by: 

choosing Edit/Columns/Order

choosing Format/Display Order

using drag and drop

right-clicking the column header and choosing Move

Question 7

The smallest unit of information about a record in a database is called a: 

query

field

cell

record

Question 8

If you want your database to perform optimally, you should do this on a regular basis.

Restart it

Re-format it

Clean it

Compact it

Question 9

Which of the following is NOT an example of a comparison operator? 

*

=

>

<>

Question 10

The Page Up and Page Down keys can be used to move between ________ in a form.

fields

New (blank) records

records

controls

Question 11

This data type is a unique, sequential number that is automatically incremented by one whenever a new record is added to a table

Number

Linked Number

Field Number

AutoNumber

Question 12

A _____ establishes the association between common fields in two tables. 

line

hyperlink

relationship

ScreenTip

Question 13

Which of the following CANNOT be accomplished using a query? 

viewing data in different ways

creating new data

analyzing data

changing existing data

Question 14

Which of the following report-building methods guides you through step-by-step? 

Report Tool

Blank report Tool

Report Design

Report Wizard

Question 15

A request for specific data contained in a database is called: 

Sort

Filter

Criteria

Query

Question 16

This database object is used to make displaying and changing records easier.

Query

Report

Table

Form

Question 17

The Sales Person table contains one record for each sales person. The related Client table contains one record for each client. A particular sales person is assigned to several clients records but each of the clients only have one sales person. This is an example of a ________ relationship. 

one-to-many

many-to-many

one-to-one

parent-to-child

Question 18

This object must be created first, before any other types of objects are created, since it is the basic unit of a database.

Table

Query

Report

Form

Question 19

The professional-appearing output generated from tables or queries is called: 

Record

File

Report

Form

Question 20

A field name can be up to ___ characters. 

16

32

64

128