access

Database

An organized collection of facts about people, events, things, or ideas related to a specific topic

Regarding the sorting of query results, which of the following is FALSE?

Only the sort order specified in Datasheet view is saved with the query design

populate

The action of filling a database with records.

object

The basic parts of a database; for example tables, forms, queries, and reports

To add on to the end of an object, such as to add records to the end of an existing table, is to:

append

access forms can

be based on multiple tables.

The process of creating a query involves

choosing the table(s) and selecting the fields you want to include in the query result

The Access view that diplays data in columns and rows like an Excel worksheet is

datasheet view

The Access view that displays the table data in columns and rows is called

datasheet view

Resizing sections in a form must be done in

design view

The report wizard

enables you to specify how the report data is grouped and sorted.

Data

facts about people events, things, or ideas.

To create a query using the Simple Query Wizard, you choose the data source and

field names

Characteristics of a field that control how the field displays and how data is entered are

field properties

To rename a table, you can

ight-click the table name in the Navigation Pane.

To view a table in Design view:

in the Views group, click the View button and click Design View

Raw data that has been organized so as to become useful is also known as

information

The field that uniquely identifies a record in a table is known as the:

primary key

The object that retrieves specific data and then displays only the data that your specify is a:

query

Each table row contains all the categories of data pertaining to one entity and is called a

record

The box at the left of a record in Datasheet view that you click to select an entire record is the

record selector box

Information repeated in a databse in a manner that indicates poor design is said to be

redundant

To print just one record from a form, which of the following would you choose in the Print dialog box?

the selected records option

the table in design view shows

the structure of the table.

The characteristic that defines the kind of data you can enter into a field is

) data type

The object that displays fields and records from a table or query in a printable foramat is a

) report

When you are searching for a numbered street address on Maple, but aren't sure whether it's Maple Avenue, Maple Street, or Maple Way, which of the following criteria would you use?

*Maple*

The characteristic that defines the kind of data you can enter into a field is:

...

The object that displays fields and records from a table or query in a printable foramat is a

...

To print just one record from a form, which of the following would you choose in the Print dialog box?

...

When establishing a relationship, common fields do NOT necessarily need to have

...

Common field

A field in one or more tables that stores the same data

field

A single piece of information that is stored in every record and represented by a column in a table

first principle of good database design

A principle stating that data is organized in tables so that there is not redundant data

Second principle of good datanbase design

A principle stating that techniques are used to ensure the accuracy of data entered into a table

flat database

A simple database file that is not related or linked to any other collection of data.

Which of the following is a good candidate for a primary key

A student ID in a college registration database.

record

A table row that contains all of the categories of dat apertaining to one person, place, thing, event, or idea

To add on to the end of an object, such as to add records to the end of an existing table, is to:

A) append

information

Data that is organized in a useful manner

Which is NOT true concerning forms?

Every table must have at least one form

Which is the primary advantage of creating a new query based on an existing query?

It saves time if your new query uses the same fields as the existing query.

To view report data while making changes to a report, use

Layout view.

normalization

The process of applying design rules and principles to ensure that a database performs as expected

object window

The window area that displays each open object on its own tab

navigation pane

The window area that organizes the database objects and from which you open objects

Using a form for data entry can increase the usefulness of a database by increasing

accuracy`

Compared to the Form tool, the Form Wizard

allows more flexibility in the layout and design of the form

form Layout view differs from Design view in that

only Form Layout view allows modifications while viewing data

A flat database

not related to any other collection of data

A query isa data base is an object that

retrieves specific data from one or more database tables or queries.

One purpose of a form is to

simplify data entry in a table

Sorting a table in descending order by a Last Name field would NOT

sort ONLY the Last Name field, thus mixing up the records

The underlying design of a table is referred to as the

structure

table

the database object that stores the data, and which is the foundation of an Access database