ACCESS

Question 1

Access is a

Answer 1

database management system (DBMS)

Question 2

a database is a powerful tool for

Answer 2

storing
organizing
retrieving information

Question 3

a database containing one table is called

Answer 3

simple database

Question 4

two or more tables of related information is called a

Answer 4

relational database

Question 5

A data base stores data in or more spreadsheet-like lists

Answer 5

tables

Question 6

each row in a table is called a

Answer 6

record

Question 7

records consist of _____, which are columns holding information about one aspect of a record.

Answer 7

Fields

Question 8

column headings are

Answer 8

field names

Question 9

this is a user-friendly window that is used to input data.

Answer 9

Form

Question 10

this extracts data from one or more database tables according to set criteria.

Answer 10

Query

Question 11

a condition

Answer 11

Query

Question 12

a summary of information pulled from the database specifically designed for printing

Answer 12

Report

Question 13

tables, forms, queries and reports are program components called

Answer 13

Objects

Question 14

A list of data organized in rows (records) and columns (fields)

Answer 14

Table

Question 15

A set of criteria you specify to retrieve data from a database.

Answer 15

Query

Question 16

A window that lets you view, enter and edit data in a database one record at a time.

Answer 16

Form

Question 17

A summary of database information designed specifically for distributing or printing

Answer 17

Report

Question 18

two ways to create an Access database

Answer 18

1. starting with a blank database

2. using a template

Question 19

a blank table datasheet with a temporary table name, Table 1

Answer 19

The right pane below the ribbon

Question 20

the left pane is called the ____________ ______, this is where all database objects for the open database are listed.

Answer 20

Navigation pane

Question 21

when working in a new database, a blank table opens in

Answer 21

Datasheet view

Question 22

In this view, you can add fields and view the data contained in the table.

Answer 22

Datasheet view

Question 23

before beginning to add fields to a table it is a good idea to

Answer 23

save the table with an appropriate name.

Question 24

every table in a database must contain one field that is designated as the _____ _____ ___, which uniquely identifies each record among all other records in the database

Answer 24

Primary Key Field

Question 25

It is often easier to add fields to a new or existing table using

Answer 25

Design view

Question 26

Identify the purpose of a field and help users understand the information that the field is meant to contain

Answer 26

Field description

Question 27

To view and change the designated primary key field use

Answer 27

Design View

Question 28

the best view for modifying a table structure is

Answer 28

Design view

Question 29

Data characteristics that dictate how Access stores, handles, and displays field data in design view

Answer 29

Field properties

Question 30

a label that appears in a form or in Datasheet view in place of a field name

Answer 30

Caption property

Question 31

the data you enter in each field is called a

Answer 31

Field value

Question 32

this is to the left of each record lets you select a record or records

Answer 32

Row selector

Question 33

An efficient way to enter and edit data: Usually displays one record at a time

Answer 33

Form

Question 34

devices for inputting data; for example, text box, list arrow, or check box

Answer 34

Form Controls

Question 35

To view different records, you use the buttons on the

Answer 35

Navigation bar.

Question 36

you can only open _____ Access database file at a time

Answer 36

one

Question 37

The field that is primary is called the

Answer 37

outermost sort field

Question 38

conditions that must be met for a record to be displayed

Answer 38

Criteria

Question 39

a database object that extracts data from one or more tables in a database according to criteria that you set

Answer 39

Query

Question 40

To relate tables, they must share a

Answer 40

common field

Question 41

the most common type of relationship to set up is ___ __ __ _____ in which the primary key field in one table is associated with multiple records in a second table

Answer 41

one-to-many relationship

Question 42

In the second table, the common field shared with the first table is called the

Answer 42

Foreign key

Question 43

a field that contains and expression

Answer 43

calculated field

Question 44

a combination of fields, values, and mathematical operators.

Answer 44

Expression

Question 45

a summary of database information designed specifically for printing

Answer 45

Report

Question 46

One way to create a report is by using the ______ ____, which automatically create a report based on setting that you specify.

Answer 46

Report Wizard

Question 47

choose the ______ _____ to select the database object from which a report gets data

Answer 47

record source

Question 48

Use _______ to organize a report by field or field values

Answer 48

Grouping

Question 49

see exactly how the report will look when printed

Answer 49

Print preview

Question 50

it displays the report in continuous flow without page break

Answer 50

Report view

Question 51

includes many tools for modifying a report, but shows only the structure of the report not the included data.

Answer 51

Design view

Question 52

does not include as many modification tools as design view, but it shows you report data. can resize, move, and delete columns.

Answer 52

Layout view

Question 53

A field is composed of two parts

Answer 53

the field label, and its associated control

Question 54

an object that displays information in a report

Answer 54

control

Question 55

five summary calculations you can use in your database reports.

Answer 55

``` SUM AVG COUNT MIN MAX ```

Question 56

______ ______ in a report displays statistics about one or more fields in a database.

Answer 56

summary calculations