Database Queries Flashcards

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is an Action Query?

A query that allows a user to create a new table from specified data.
A query that allows a user to make changes or move records in the applied tables. (correct)
A query that allows the user to view data without changing it.
A query that allows the user to delete records.

What does Alignment refer to in a document?

The position of items in a document in relation to each other or the grid.

What is an Append Query?

A query that allows the user to create a new table from specified data in applied tables.

What are Application Parts?

Prebuilt combinations of tables, queries, forms, and reports that are easily added to a database. Signup and view all the answers

What does Backstage View provide?

Important options for managing files and the data in them, including creating new documents and editing document properties. Signup and view all the answers

What is a Backup Copy?

A copy of a database that is saved in a different location from the original database. Signup and view all the answers

What is a Control in a form?

A button, drop-down box, or other interface tool designed to enhance the functionality of a form. Signup and view all the answers

What is a Criteria Row?

A row in the Design grid that allows the user to enter data to be placed in a query. Signup and view all the answers

What are Crosstab Queries used for?

Queries that allow the user to calculate aggregate functions such as sum and average in a query. Signup and view all the answers

What defines a Database?

A collection of data organized into tables which may be used to keep track of information. Signup and view all the answers

What is Datasheet View?

A view that shows a clear table of the information that has been specified in the Design View. Signup and view all the answers

What is a Delete Query?

A query that allows the user to delete records as specified in entered criteria. Signup and view all the answers

What is Design View in Access?

A view setting that allows a user to make changes to a form; provides a more structural look at a form. Signup and view all the answers

What is a Field in a form?

The area of a form where data is entered; also known as a text box. Signup and view all the answers

What defines a Foreign Key?

A field that relates to a primary key in another table. Signup and view all the answers

What is a Form in Access?

An Access document which allows users to add and delete information from the database. Signup and view all the answers

What is Form Design?

The process of creating a form to fulfill organizational purposes for specific data. Signup and view all the answers

What does the Form Wizard do?

A program within Access that provides a step-by-step guide to creating a form. Signup and view all the answers

What are Formulas in Access?

A set of instructions that performs mathematical operations using entered data. Signup and view all the answers

What does the IN Statement allow users to do?

Combine more than one OR statement in a single criteria row. Signup and view all the answers

What is an Inner Join?

A table join that combines information from the tables if the linked value is in both applied tables. Signup and view all the answers

What is an Input Mask?

A function that conforms input information to a specified format. Signup and view all the answers

What is a Label in a form?

The area that designates the type of information to be entered into a corresponding field. Signup and view all the answers

What does Layout View provide in Access?

A more realistic view of the form than Design View, showing real data from tables. Signup and view all the answers

What is a Make Table Query?

An action query that allows the user to move records in the applied tables. Signup and view all the answers

What defines a Many-to-Many Relationship?

An Access relationship between two foreign keys. Signup and view all the answers

What is a Margin in a document?

The term describing the border around a page; the white space around a page. Signup and view all the answers

What is a Multitable Query?

Allow users to search for related records in more than one query. Signup and view all the answers

What does the NOT Statement allow users to do?

Search applied tables for an opposite of any criteria. Signup and view all the answers

What are Naming Conventions?

A set of rules regarding the naming of Access objects. Signup and view all the answers

What is a Navigation Pane?

The pane which appears when a project or database is opened. Signup and view all the answers

What does Null represent in a database?

A static variable that represents the value of an empty field. Signup and view all the answers

What defines a One-to-Many Relationship?

An Access relationship between a primary key and a foreign key. Signup and view all the answers

What is a One-to-One Relationship?

An Access relationship between two primary keys. Signup and view all the answers

What is an Outer Join?

A table join that shows all the data in specified fields of a specified table. Signup and view all the answers

What is a Page Footer?

The bottom portion of a database form or report which may contain information such as title or page number. Signup and view all the answers

What does the Page Header contain?

The uppermost portion of a database, form, or report which may contain information such as title or author. Signup and view all the answers

What is a Parameter in Access?

A placeholder in an expression or formula for user input. Signup and view all the answers

What is a Primary Key?

A field in a table whose values are unique to each record. Signup and view all the answers

What is a Query in Access?

An Access inquiry about the data stored in a table. Signup and view all the answers

What does the Query Wizard do?

A function used to create queries, specifying data from a database. Signup and view all the answers

What is a Record in a database?

An individual entry in a table made up of multiple fields. Signup and view all the answers

What is Referential Integrity?

A setting that ensures records are entered in one table before being used in another. Signup and view all the answers

What is a Report in Access?

An Access database object where users can print organized information from tables. Signup and view all the answers

What is a Split Form?

A view of a form that provides two different views at once: form view and datasheet view. Signup and view all the answers

What is a Table in Access?

The basic unit of data storage in an Access database. Signup and view all the answers

What is a Template?

A set of predesigned formats and layouts applied to a document for a specific purpose. Signup and view all the answers

What are Validation Rules in Access?

A function which ensures that input information meets a certain criteria. Signup and view all the answers

What does a Wildcard Statement allow the user to do?

Search for a partial match in the database. Signup and view all the answers

Study Notes

Key Concepts of Queries in Access

Action Query: Changes or moves records in applied tables.
Append Query: Creates a new table from data in existing tables.
Delete Query: Removes records based on specified criteria.
Make Table Query: Moves records into a newly created table.

Database Fundamentals

Database: Organized collection of data in tables for easy reference.
Table: Basic data storage unit with rows (records) and columns (fields).
Record: Individual entry within a table composed of multiple fields.
Field: Area in a form for data entry, synonymous with column.

Data Management Features

Crosstab Queries: Calculate aggregate functions such as sum and average.
Multitable Query: Searches for related records across multiple queries.
Inner Join: Combines information from linked tables based on common values.
Outer Join: Displays all data from specified fields, including unmatched records.

Data Input and Control Elements

Control: Interface tools (like buttons or drop-downs) that enhance form functionality.
Input Mask: Ensures information is entered in a specified format.
Label: Designates the type of information in a corresponding field.

Database Relationships

Foreign Key: Links to a primary key in another table.
One-to-One Relationship: Connection between two primary keys.
One-to-Many Relationship: Links a primary key to multiple foreign keys.
Many-to-Many Relationship: Relates two foreign keys in Access.

Form and Report Functionality

Form: Organizes and allows data entry in a database; pulls data from tables.
Form Design: Process of creating forms tailored for specific data needs.
Form Wizard: Step-by-step tool in Access for form creation.
Report: Object for printing organized information from tables as per user specs.

View Options in Access

Datasheet View: Displays a clear table of specified information.
Design View: Allows structural editing of forms for better customization.
Layout View: Provides a realistic view of forms with live data.
Split Form: Combines form view and datasheet view for dual perspectives.

Backstage View: Options for managing database files, including document properties.
Navigation Pane: Task pane that appears upon opening a project or database.

Data Integrity and Rules

Referential Integrity: Ensures related records are entered correctly across tables.
Validation Rules: Functions to ensure input meets specified criteria.
Criteria Row: Design grid row for entering query data filters.

Miscellaneous

Wildcard Statement: Enables search for partial matches within data.
Parameter: Placeholder for entering new criteria in queries.
Backup Copy: Safeguard of database stored separately to prevent data loss.
Template: Pre-designed document formats for specific uses.
Margin: Describes the white space around a document page.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Description

Test your knowledge of database queries with these flashcards. Each card provides important definitions and concepts related to various types of queries such as Action and Append Queries. Perfect for learners looking to enhance their understanding of database management.