Access Chapter One

Information Technology 150 with Higgins at Illinois State University

About this deck

By: Alise Gromala
Created: 2011-10-23
Size: 28 flashcards
Views: 22

About StudyBlue

STUDYBLUE makes things that make you better at school. Things like online flashcards with photos and audio. Things like personalized quizzes and friendly reminders about when (and what) to study next. Think of it as a digital backpack™: access to all of your study materials online and on your phone. STUDYBLUE exists to make studying efficient and effective for every student, for free. Join us.

“I have been getting MUCH better grades on all my tests for school. Flash cards, notes, and quizzes are great on here. Thanks!”
Kathy

Sign up (free) to study this.

Object

In an Access database, a main component that is created and used to make the database function.

Field

The smallest data element contained in a table. Examples of fields are first name, last name, address, and phone number.

Record

A complete set of all the data elements (fields) about one person, place, event, or concept.

Table

The foundation of every database, is a collection of related records.

Database

Consists of one or more tables to store data, one or more forms to enter data into the tables, and one or more reports to output the table data as organized information.

Navigation Pane

Organizes and lists the database objects in an Access database.

Datasheet view

Where you add, edit, and delete the records of a table.

Design view

Where you create tables, add and delete fields, and modify field properties.

Primary Key

The field (or combination of fields) that uniquely indentifies each record in a table.

Form

An object that enables you to enter, modify, or delete table data.

Query

A question that you ask about the data in the tables of you database.

Criterion (Criteria, plural)

A number, a text phrase, or an expression used to filter the records in a table.

Report

Contains professional-looking formatted information from underlying tables or queries.

Access Speed

Measures the time it takes for the storage device to make the file content available for use.

Compact and Repair

Reduces the size of the database.

Backup

Creates a duplicate copy of the database.

Filter

Displays a subset of records based on specified criteria.

Filter by Selection

Displays only the records that match the selected criteria.

Filter by Form

Displays table records based on multiple criteria. Filter by Form enables the user to apply the logical operators AND and OR.

Comparison Operator

Used to evaluate the relationship between two quantities to determine if they are equal or not equal; and, if they are not equal, a comparison operator determines which one is greater than the other.

Sort

Lists records in a specific sequence, such as ascending by last name or by ascending EmployeeID.

Ascending

Sorts a list of text data in alphabetical order or a numeric list in lowest to highest order.

Descending

Sorts a list of text data in reverse alphabetical order or a numeric list in highest to lowest order.

Relationship

A connection between two tables using a common field.

Relational Database Management System (RDBMS)

What Access is known as. Using an RDBMS, you can manage groups of data (tables) and then set rules (relationships) between tables.

Join Lines

Enable you to create a relationship between two tables using a common field.

Foreign Key

A field in one table that is also the primary key of another table.

Enforce Referential Integrity

Ensures that data cannot be entered into a related table unless it first exists in the primary table.

About this deck

By: Alise Gromala
Created: 2011-10-23
Size: 28 flashcards
Views: 22

About StudyBlue

“I have been getting MUCH better grades on all my tests for school. Flash cards, notes, and quizzes are great on here. Thanks!”
Kathy