Access Relationships, Sorting, Filtering, and Queries

Flashcards covering key concepts related to Access Relationships, Sorting, Filtering, and Queries.

Relationship

A connection between two tables based on common fields.

Primary Key

A unique identifier for each record in a table (e.g., StudentID).

Foreign Key

A field in one table that refers to the primary key in another table.

Related Table

A table linked to another table through a relationship.

Join Lines

Graphical lines in the Relationships window showing how tables are connected.

Referential Integrity

Rules ensuring valid relationships and preventing orphaned records.

Enforce Referential Integrity

Ensures that relationships between tables remain consistent.

Cascade Delete Related Fields

Automatically deletes related records if the primary record is deleted.

Cascade Update Related Fields

Automatically updates foreign keys if the primary key changes.

One-to-Many Relationship

One record in a table links to multiple records in another (most common type).

Data Redundancy

Unnecessary duplication of data; normalization helps reduce this.

Field Property

Settings that define a field’s behavior (e.g., format, validation rules).

Sort

Arranges records in a specified order.

Sort Ascending

Sorts from A-Z or 0-9.

Sort Descending

Sorts from Z-A or 9-0.

Filter

Displays only records that meet certain criteria.

Filter by Form

Allows filtering using a form-like interface with multiple criteria.

Filter by Selection

Filters records based on a selected value in a field.

Query

A request for data retrieval or manipulation from a database.

Criterion

A condition used in queries (e.g., ="NY" for New York).

AND Logical Operator

Requires all conditions to be true (e.g., City="NY" AND Age>30).

NOT Logical Operator

Excludes records matching a condition (e.g., NOT "NY").

Wildcard

Symbols like * (any characters) or ? (single character) for partial matches.

Simple Query Wizard

A guided tool to create basic queries.

Query Design View

A graphical interface to build and modify queries.

Field Row

The row in Query Design where fields are selected.

Table Row

Shows the source table for each field in a query.

Sort Row

Specifies sorting (Ascending/Descending) for query results.

Show Row

Toggles whether a field appears in query results.

Criteria Row

Defines conditions for filtering query results.

Run Command

Executes the query to display results.

Multitable Query

A query that pulls data from multiple related tables.

Select Query

Retrieves data without modifying it (most common query type).