Computer Applications FINAL Pt. 3 (Access)

Unlike other Office software applications, you must _________ a new Access database file before you can create any objects in the file.

Name and save

In the Microsoft Access Database Window, the _________ displays a list of the database objects that can be opened.

Navigation pane

The process of applying design rules and principles to ensure that your database performs as expected is called ______________.

Normalization

In the Microsoft Access Database Window, the __________ displays the active or open object(s), including tables, queries, forms, and/or reports.

Object window

________ are the basic parts of a database, created to store data, to work with data, and to display data.

Objects

A database is useless until the table is _____________ with data, which may be accomplished by typing the data directly into the table or by importing the data

Populated

_________ data is critical to maintaining accuracy in a database, especially when multiple people may be inputting data.

Proofreading

Each row in a database table is called a/n __________--all of the categories of data pertaining to one person, place, event, thing, or idea.

Record

The _____________ data type describes text, a combination of text and numbers, or numbers that do not represent a quantity or are not used in calculations, such as the zip code; allows entry of up to 255 characters in that field.

Short text

When appending or creating a new table from an Import, the file that is being imported is called the ____________ file

Source

When designing a new database, the first question users should ask themselves is _________

What questions should this database be able to answer?

What is the keyboard shortcut to open and close the Navigation Pane in Access?

F11

Each column in a database table is called a/n _____________--a single piece of information for every category of data.

Field

To organize data in database tables so that redundant data does not occur is the ___________ principle of good database design; reduces the likelihood of errors when inputting new data.

First

Databases that are not related or linked to any other collection of data are called __________ databases

Flat

The tables of information in a relational database are linked or joined to one another by _____________--a unique entry in each table row that stores the same data.

A common field

A more sophisticated type of database is called __________, because multiple collections of data in the database are linked to one another—for example, information about students, courses, and instructors at a college.

A relational database

When creating a new table, Access creates the first field and names it ID, in which Access assigns _________ to each new record as it is entered into the table.

A unique sequential or random number

The _____________ data type describes a unique sequential or random number assigned by Access as each record is entered.

AutoNumber

To use the Append option to add records to an existing table, the column heading in the Excel worksheet must ______________.

Be identical to the field names in the table

An Access ___________ is stored on your computer or storage device; it initially has no data and database tools—you create the data and the tools as you need them.

Blank database file

By default, a new, blank Access database table displays in __________, which arranges the data in columns and rows similar to an Excel worksheet.

Datasheet view

There are two views for tables in Access: Datasheet view and ___________view.

Design

One of the ways to view a database table is in ___________, which displays the underlying structure of the table's fields and where the structure may be created or edited.

Design view

By using the _____________ feature, users do not have to manually enter data into tables if the information already exists in a Word table or Excel spreadsheet.

Import

_________ are similar in structure to an Excel worksheet and are the foundation for all Access databases

Tables

Which of the following is NOT one of the four most common database objects?

Template

When linking two tables in a relational database, a user will use a ________ to create the link.

common field

A very important classification for each database table field is the __________, which classifies the kind of data that can be stored in each field such as number, text or date; can be only one to each field.

data type

A _______________ is an organized collection of data related to a specific topic or purpose

database