Microsoft Access Foundations: Tables, Queries, Forms & Reports
Design and use a real desktop database for a fictional bike rental: tables, data types, primary keys, relationships, select and totals queries, criteria, forms, reports and imports, with every answer checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
Microsoft Access Foundations teaches you to design and use a real desktop database. You build the database of a fictional bike rental step by step: choose data types and field properties, set primary keys, split a flat Excel list into related tables and enforce referential integrity. Then you query it with the design grid: criteria, AND/OR rows, wildcards, date filters, calculated fields with IIf, joins, totals queries, parameters and top values. Finally you work with action queries, forms with subforms, grouped reports with running sums and data imports. Every answer is checked instantly, and the first lesson is free.
Lessons
- Tables, Records and Fields: Your First Access DatabaseFree
- Data Types and Field Sizes Locked
- Field Properties: Required, Default Value and Validation Rules Locked
- Primary Keys and AutoNumber Locked
- From One Flat List to Related Tables Locked
- Relationships: One-to-Many and Foreign Keys Locked
- Referential Integrity and Cascade Options Locked
- Select Queries in the Design Grid Locked
- Criteria: Between, In, Not and Is Null Locked
- AND and OR: Criteria Rows in the Grid Locked
- Like and Wildcards: Searching Inside Text Locked
- Calculated Fields and IIf Locked
- Dates: DateDiff, Month and Date Criteria Locked
- Joins: Inner Join, Outer Join and Unmatched Records Locked
- Totals Queries: Group By, Sum, Avg and Max Locked
- Totals with Criteria: Where versus Having Locked
- Parameter Queries and Top Values Locked
- Action Queries: Update, Delete, Append and Make-Table Locked
- Forms: Bound Controls, Calculated Controls and Subforms Locked
- Reports: Grouping, Totals and Running Sums Locked
- Importing and Exporting Data Locked
- Final Project: Velora's Net Revenue Report Locked