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 just one table is called a

Answer 3

simple database

Question 4

two or more tables of related information is called a

Answer 4

relational database

Question 5

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

a database stores data in or more spreadsheet-like lists called

Answer 5

TABLES

Question 6

each row in a table is called a

Answer 6

record

Question 7

records consists 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

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

a _____ is a user-friendly window that is used to input data

Answer 9

form

Question 10

A ___ extracts data from one or more database tables according to set criteria

Answer 10

query

Question 11

A ____ is a summary of database information pulled from the database specifically designed for printing or distributing

Answer 11

report

Question 12

tables, forms, queries, and reports are program components called

Answer 12

objects

Question 13

two basic ways to create an Access database

Answer 13

blank database

template

Question 14

the left pane where all database objects for the open database are listed

Answer 14

navigation pane

Question 15

you can add fields and view the data contained in the table

Answer 15

datasheet view

Question 16

each object within an Access database that you create will need to be

Answer 16

saved

Question 17

every table in a database must contain one field that is designated as the

Answer 17

Primary Key Field

Question 18

an assigned unique number for each record in the table, starts with 1. and cannot be edited

Answer 18

autonumber

Question 19

a word or string of word, numbers that do not require calculations, or a combination of text and number

Answer 19

short text

Question 20

numeric data to be used in calculations

Answer 20

number

Question 21

values that can only be yes or no; used to identify the presence or absence of specific criteria

Answer 21

yes/no. logical field

Question 22

displays a value that is the result of a formula that includes field values.

Answer 22

calculated

Question 23

it is often easy to add fields to a new or an existing table using

Answer 23

Design View

Question 24

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

Answer 24

Field descriptions

Question 25

use design view to view and change the designated

Answer 25

primary key field

Question 26

data characteristics that dictate how Access stores, handles, and display field data

Answer 26

field properties

Question 27

a label that appears in a form or in a Datasheet view in place of the field name to clarify the field’s contents for data entry or interpretation.

Answer 27

Caption property

Question 28

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

Answer 28

row selector

Question 29

the data you enter in each field is called a

Answer 29

field value

Question 30

the border between field names is called a

Answer 30

column separator

Question 31

a ____ is an efficient way to enter and edit data, it usually displays one record at a time and contains form controls

Answer 31

form

Question 32

_____ _____ are devices for inputting data: for example, text box, list arrow, or check box.

Answer 32

form controls

Question 33

to view different records, you use the buttons on the

Answer 33

navigation bar (at bottom of screen)