Microsoft Access in Practice: Relationships, Queries, Macros & Reports
Design related tables, enforce referential integrity and work out exactly what Access joins, totals, crosstab, parameter and action queries, macros and grouped reports produce, with every answer checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
Microsoft Access in Practice takes you from table design to finished reports with a fictional garden supply shop. You set up one-to-many and many-to-many relationships, test composite keys, find orphan records before enforcing referential integrity and measure how far a cascade delete reaches. Then you work out exactly what Access queries return: inner and left joins, date criteria with the Between trap, calculated fields with Nz, totals queries with Where and HAVING, parameter and crosstab queries, TOP values with ties and domain functions. You finish with update, append and delete queries, macros, grouped reports and a monthly sales report project. Every answer is checked instantly, and the first lesson is free.
Lessons
- Tables, Keys and the One-to-Many RelationshipFree
- Data Types and Field Sizes That Fit Locked
- Composite Keys and Finding Duplicates Locked
- Referential Integrity and Orphan Records Locked
- Cascade Update and Cascade Delete: How Far a Delete Reaches Locked
- Many-to-Many Relationships with a Junction Table Locked
- Joining Tables in a Query: INNER JOIN Locked
- LEFT JOIN, Unmatched Records and the WHERE Trap Locked
- Query Criteria: Dates, Ranges, Lists and Wildcards Locked
- Calculated Fields, IIf and Nz: Expressions Without Null Surprises Locked
- Totals Queries: Group By, Where and HAVING Locked
- Parameter Queries: One Query, Many Questions Locked
- Crosstab Queries: TRANSFORM and PIVOT Locked
- TOP Values and the Tie Surprise Locked
- Domain Aggregate Functions: DCount, DSum, DMax, DAvg Locked
- Update Queries: Change Many Rows Safely Locked
- Append, Delete and Make-Table Queries: Archiving Safely Locked
- Macros: If Blocks, OpenReport Filters and Data Macros Locked
- Reports with Groups: Footers, Running Sums and Shares Locked
- Report Group Intervals and Page Layout Locked
- Final Project: Monthly Sales Report Locked