Access - Chapter 1

External data

One of five main Ribbon tabs

Ctrl+spacebar

Selects current column

Hierarchy of data

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

A template

A pre-designed database that contains various pre-build objects is called:

Tables

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

Append

Add

Microsoft Access

DBMS

Long Text

Data type w 255+ Characters

Datasheet

Default view for a new Access database

Table

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

64 Characters

Field name limit

Widen the column

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

Compound criteria

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

A Field

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

Primary Key

In a database, the special field that contains a unique value for each record is the:

Template

Pre-designed database

Objects

Tables and forms are examples of database:

Append Row

The last row in an Access table is called the:

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

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

In ascending order

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

Form

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

Filter

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

Rich Text

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

Caption

An alt to a field name

Gridlines

Frames for rows and columns