| |
| |
| |
| Introduction to Access: Finding Your Way through a Database | |
| |
| |
| |
| Data and Files Everywhere! | |
| |
| |
| Exploring, Describing, and Navigating Among the Objects in an Access Database | |
| |
| |
| Understanding the Difference Between Working in Storage and Memory | |
| |
| |
| Practicing Good File Management | |
| |
| |
| Backing up, Compacting, and Repairing Access Files | |
| |
| |
| Hands-On Exercises 1 Introduction to Databases | |
| |
| |
| |
| Filters, Sorts, and Access Versus Excel | |
| |
| |
| Creating Filters | |
| |
| |
| Sorting Table Data on One or More Fields | |
| |
| |
| Knowing When to Use Access or Excel to Manage Data | |
| |
| |
| Hands-On Exercises 2: Data Manipulation: Filters and Sorts | |
| |
| |
| |
| The Relational Database | |
| |
| |
| Using the Relationship Window | |
| |
| |
| Understanding Relational Power | |
| |
| |
| Hands-On Exercises 3: Introduction to Relationships | |
| |
| |
| Summary | |
| |
| |
| Key Terms | |
| |
| |
| Multiple Choice | |
| |
| |
| Practice Exercises | |
| |
| |
| Mid-Level Exercises | |
| |
| |
| Capstone Exercise | |
| |
| |
| Mini Cases | |
| |
| |
| |
| Relational Databases and Multi-Table Queries: Designing Databases and Using | |
| |
| |
| |
| Related Data | |
| |
| |
| Table Design, Properties, Views, and Wizards | |
| |
| |
| Designing Data | |
| |
| |
| Creating Tables | |
| |
| |
| Hands-On Exercises 1: Table Design, Properties, Views, and Wizards | |
| |
| |
| |
| Multiple Table Database | |
| |
| |
| Understanding Table Relationships | |
| |
| |
| Sharing Data with Excel | |
| |
| |
| Establishing Table Relationships | |
| |
| |
| Hands-on Exercises 2: Imports and Relationships | |
| |
| |
| |
| Queries | |
| |
| |
| Creating a Query | |
| |
| |
| Specifying Criteria for Different Data Types | |
| |
| |
| Copying and Running a Query | |
| |
| |
| Using the Query Wizard | |
| |
| |
| Understanding Large Database Differences | |
| |
| |
| Hands-On Exercises 3: Multi-Table Query | |
| |
| |
| Summary | |
| |
| |
| Key Terms | |
| |
| |
| Multiple Choice | |
| |
| |
| Practice Exercises | |
| |
| |
| Mid-Level Exercises | |
| |
| |
| Capstone Exercise | |
| |
| |
| Mini Cases | |
| |
| |
| |
| Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions | |
| |
| |
| |
| Data Summary and Analysis | |
| |
| |
| Understanding the Order of Precedence | |
| |
| |
| Creating a Calculated Field in a Query | |
| |
| |
| Hands-On Exercises 1: Calculated Query Fields | |
| |
| |
| |
| Expression Builder | |
| |
| |
| Creating Expressions with the Expression Builder | |
| |
| |
| Creating and Editing Access Functions | |
| |
| |
| Performing Date Arithmetic | |
| |
| |
| Hands-On Exercises 2: Expression Builder, Functions, and Date Arithmetic | |
| |
| |
| |
| Data Aggregates | |
| |
| |
| Creating and Working with Data Aggregates | |
| |
| |
| Hands-On Exercises 3: Data Aggregates | |
| |
| |
| Summary | |
| |
| |
| Key Terms | |
| |
| |
| Multiple Choice | |
| |
| |
| Practice Exercises | |
| |
| |
| Mid-Level Exercises | |
| |
| |
| Capstone Exercise | |
| |
| |
| Mini Cases | |
| |
| |
| |
| Create, Edit and Perform Calculations in Reports: Creating Professional and Useful Reports | |
| |
| |
| |
| Appearance Matter | |
| |
| |
| Planning Reports | |
| |
| |
| Using Different Report Views | |
| |
| |
| Creating and Editing a Report | |
| |
| |
| Hands-On Exercises 1: Introduction to Access Reports | |
| |
| |
| |
| The Anatomy of a Report | |
| |
| |
| Identifying Report Elements, Sections and Controls | |
| |
| |
| Adding Grouping Levels Using the Layout View | |
| |
| |
| Adding Fields to a Report | |
| |
| |
| Hands-On Exercises 2: Create, Sort, Edit, Nest and Remove Groups from Reports | |
| |
| |
| |
| The Report and Label Wizard | |
| |
| |
| Using the Report Wizard | |
| |
| |
| Hands-On Exercises 3: Report Wizard | |
| |
| |
| Summary | |
| |
| |
| Key Terms | |
| |
| |
| Multiple Choice | |
| |
| |
| Practice Exercises | |
| |
| |
| Mid-Level Exercises | |
| |
| |
| Capstone Exercise | |
| |
| |
| Mini Cases | |