Access Chapter 1

primary key

a field that contains a unique value for each record.

relational database

which means that the data are organized into a collection of related tables. Each table stores data about one type, or grouping, of information represented in the system.

If any of your database columns display the ###### symbols, you need to

widen the column

You need to design a new Access database. The first step is to organize the smallest to largest data, also called:

Hierarchy of data

When importing data records from Excel, which of these must be true

The first row of the Excel file must contain the field names from the Access table.

form

Used to create an interface to view, add, update, and delete data in a table

query

Used to find data in your database

report

Used to view and print the data in your database

In Access, a collection of numbers and/or characters that describes one aspect of a business object or activity is called

a field

A pre-designed database that contains various pre-built objects is called

a template

The last row in an Access table is called the

append row

If you need to find both a particular product type AND a price, you can do this through

compound criteria

When you want to view only certain database fields such as product type, use this function

filter

When you need to create an interface to view, add, update, and delete data in Access, you should use a:

form

When you first open a table in Datasheet view, Access uses the first field to sort the data records:

in ascending order

field

is a collection of characters that describes one aspect of a business object or activity—a single unit of data.

record

is a collection of related data fields.

table

is a collection of related records. Visually you see the table containing rows and columns. Each row is the equivalent of a record. A row contains many different columns or fields.

Template

is a predesigned database that contains various pre-built objects. A template provides you with a complete, ready-to-use database application.

database

is an organized collection of integrated and related tables.

Database Management System (DBMS)

is software that allows you to create a database; manage the data in the database by adding, deleting, and updating records; sort and retrieve data; and create queries and reports relating to that data.

tables and forms are examples of database:

objects

Which of the following is a special text format applied to a Long Text data type that allows you to store formatted text?

rich text

Each major subject or grouping of information you will store in your database should have a separate:

table

Access is a relational database, which means that the data are organized into a collection of related

tables