Questions and Answers
What is an Action Query?
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?
Signup and view all the answers
What does Backstage View provide?
Signup and view all the answers
What is a Backup Copy?
Signup and view all the answers
What is a Control in a form?
Signup and view all the answers
What is a Criteria Row?
Signup and view all the answers
What are Crosstab Queries used for?
Signup and view all the answers
What defines a Database?
Signup and view all the answers
What is Datasheet View?
Signup and view all the answers
What is a Delete Query?
Signup and view all the answers
What is Design View in Access?
Signup and view all the answers
What is a Field in a form?
Signup and view all the answers
What defines a Foreign Key?
Signup and view all the answers
What is a Form in Access?
Signup and view all the answers
What is Form Design?
Signup and view all the answers
What does the Form Wizard do?
Signup and view all the answers
What are Formulas in Access?
Signup and view all the answers
What does the IN Statement allow users to do?
Signup and view all the answers
What is an Inner Join?
Signup and view all the answers
What is an Input Mask?
Signup and view all the answers
What is a Label in a form?
Signup and view all the answers
What does Layout View provide in Access?
Signup and view all the answers
What is a Make Table Query?
Signup and view all the answers
What defines a Many-to-Many Relationship?
Signup and view all the answers
What is a Margin in a document?
Signup and view all the answers
What is a Multitable Query?
Signup and view all the answers
What does the NOT Statement allow users to do?
Signup and view all the answers
What are Naming Conventions?
Signup and view all the answers
What is a Navigation Pane?
Signup and view all the answers
What does Null represent in a database?
Signup and view all the answers
What defines a One-to-Many Relationship?
Signup and view all the answers
What is a One-to-One Relationship?
Signup and view all the answers
What is an Outer Join?
Signup and view all the answers
What is a Page Footer?
Signup and view all the answers
What does the Page Header contain?
Signup and view all the answers
What is a Parameter in Access?
Signup and view all the answers
What is a Primary Key?
Signup and view all the answers
What is a Query in Access?
Signup and view all the answers
What does the Query Wizard do?
Signup and view all the answers
What is a Record in a database?
Signup and view all the answers
What is Referential Integrity?
Signup and view all the answers
What is a Report in Access?
Signup and view all the answers
What is a Split Form?
Signup and view all the answers
What is a Table in Access?
Signup and view all the answers
What is a Template?
Signup and view all the answers
What are Validation Rules in Access?
Signup and view all the answers
What does a Wildcard Statement allow the user to do?
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.
User Interface and Navigation
- 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.