ACCESS Chapter 1: End of Chapter Quiz, Access Chapter 1, Access Chapter 2, BCIS Review 9

Shift

Select multiple controls to format by holding down

Referential integrity

Set of rules that ensures that the data between related tables is valid.

Ascending

Sorting order that arranges text alphabetically (A to Z) and numbers from the lowest number to the highest.

Descending

Sorting order that arranges text in reverse alphabetical order (Z to A) and numbers from the highest to the lowest.

Comparison operators

Symbols of =,<, and >.

autonumber

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

currency

The data type that describes monetary values and numeric data used in mathematical calculations involving data with one to four decimal places is:

short text

The data type that describes text, a combination of text and numbers or numbers that re not used in calculations, such as ZIP code is:

Table

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

Do not keep group together on one page

The default setting for grouping of records in a report is

primary key

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

Text box control

The graphical object on a form or report that displays the data from the underlying table or query

Control layout

The grouped arrangement of controls on a form or report

report

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

query

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

Tab order

The order in which the insertion point moves from one field to another in a form when you press the Tab key is

Normalization

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

Filtering

The process of displaying only a portion of the total records (a subset) based on matching specific values to provide a quick answer is

Detail section

The section of a form or report that displays the records from the underlying table or query

Bound

The term used to describe objects and controls that are based on data that is stored in tables

structure

The underlying design of a table is referred to as the:

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.

append

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

Design View

To align controls in a report, first display the report in

Unfiltered

To apply a filter that has been saved with a form, in the navigation area, click

Join line

Visual cue in the relationship window that indicates tables are related by connecting common fields

*

Wildcard character that serves as a placeholder for one or more unknown characters.

operating, application, utility

3 categories of software

cpu, clock speed, ram

3 components that determine comp speed

Field name, data type, field size

3 items to define a table

windows android macintosh

3 operating systems

quicken, numbers, calc

3 spreadsheet apps

Base, Dbase, Oracle

3 types of Database

notepad write pages

3 types of Word processing apps

micro server embedded

3 types of computers

antivirus system backup registry cleaner

3 utility programs

Labels, values, date, formulas, functions, links

6 items that go in a cell

Tables, Quieries, Forms, Reports, Pages, Macros, Modules

7 Objects of Database

AND

A condition in which records display only when all of the values are present in the selected fields is

Label control

A control on a form or report that contains descriptive information, typically a field name

Date control

A control on a form or report that inserts the current date each time the form or report is opened

Calculated control

A control that contains an expression, often a formula or function, that most often summarizes a field that contains numerical data

Unbound control

A control that does not have a source of data, such as a title in a form or report

Bound control

A control that retrieves the data from an underlying table or query

Group, Sort, & Total pane

An area that displays at the bottom of the window in which you can control how information is sorted and grouped in a report is the

Trust center

An area where you can view the security and privacy settings for your Access installation.

Relationship

An association that you establish between two tables based on common fields.`

Control

An object on a form or report that displays data, performs actions, and lets you work with information

Database

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

Message bar

Area directly below the ribbon that displays information such as security alerts.

25 GB 50 GB

Blu-Ray

700 MB

CD

field properties

Characteriestics of field that control how the field displays and how date is entered are:

Between and

Comparison operator that searches for values within a range.

Criteria

Conditions in a query that identify the specific data for which you're looking.

Parameter

Criteria that can be changed when a query is run.

Is null

Criteria that searches for fields that are empty.

4.7 GB

DVD

Information

Data that is organized in a useful manner.

Form header

Information, such as a form's title, that displays at the top of the screen in Form view and is printed at the top of the first page when records are printed as forms

And

Logical operator that requires all criteria to be met.

Design grid

Lower area of the query design window where criteria is entered.

Aggregate functions

Min, Max, Avg, and Sum are examples of..

the harddrive

Operating system manages

property sheet

Precise changes to the properties--characteristics of selected items in database can be made in the:

Foreign key

Primary key field is connected to this field in the related table to create a relationship.

Run

Process in which Access looks for records in a table based on the fields and criteria in the query design. Finds those records and then displays the records in a datasheet.

Sorting

Process of arranging data in a specific order based on the data in a field.

Parameter query

Query that prompts you for criteria when it is run.

Statistics, engineering, payroll, scheduling

Reasons to use Spreadsheets

One to many relationship

Relationship between 2 tables where one record in the first table corresponds to many records in the second table.

Cascade options

Relationship options that enable you to update records in related tables when referential integrity is enforced.

moves in the direction

Relative reference

volatile, fast, expensive

primary memory

nonvolatile, slow, inexpensive

secondary memory

Form

A database object that you can use to enter new records into a table, or to edit, delete, and display existing records in a table is a

Common field

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

Section bar

A gray bar in a form or report that identifies and separates one section from another

relational database

A more sophisticated type of database that stores multiple collections of data that are related to one another for example, data about the students, the courses, and the faculty members at a college is a:

Theme

A predesigned set of colors, fonts, lines, and fill effects that look good together and that can be applied to all of the objects in a database or to individual objects is a

First (principle of good database design)

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

Second (principle of good database design)

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

Crosstab query

A query that uses an aggregate function and displays data grouped by two types of information.

Flat database

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

Field

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

Layout selector

A small symbol that displays in the upper left corner of a selected control layout in a form or report that is displayed in Layout view or Design view and that is used to move or format an entire group of controls is the

Record

A table row that contains all of the categories of data pertaining to one person, place, thing, event, or idea.

stays the same

Absolute reference

Filter by Form

An Access command that filters the records in a form based on one or more fields, or based on more than one value in the field, is

Design view

An Access view that displays the detailed structure of a query, form, or report

Report wizard

An access tool that walks you step by step through the creation of a report is the

specific task

An application manages a

Data

Facts about people, events, things, or ideas.

Number, short text, currency, memo, attachment, date, hyperlink

Field Data types

Calculated field

Field that stores the value of a mathematical operation.

Colon

For a calculated field, the new field name must be followed by...

Subdatasheet

In Datasheet view, clicking the plus sign displays the related records in this format.

Outermost

In Datasheet view, when sorting using multiple fields, the field that is used for the 1st level of sorting.

Innermost

In Datasheet view, when sorting using multiple fields, the field that is used for the 2nd level of sorting.

Field list

In the query design window of the table area, the list of field names in a table.

Form footer

Information at the bottom of the screen in Form view that prints after the last detail section on the last page

Group Footer

Information printed at the end of each group of records in a report that is most commonly used to display summary information is the:

redundant

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

Layout view

The Access view in which you can make changes to a form or report while viewing the data

Datasheet view

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

Populate

The action of filling a database with records.

Objects

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

record selector box

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

data type

The characteristic that defines the kind of data you can store in a field is the: