Microsoft Access Intermediate

A Look At Relationships, Creating A One-­?To-­?One Relationship, Creating A One-­?To-­?Many Relationship, Creating A Many-­?To-­?Many Relationship, Enforcing Referential Integrity, Cascade Update Related Fields, Cascade Delete Related RecordsOn Your Own

Setting Validation Rules, Formatting Fields, Indexing Fields, Requiring Data Entry, Creating An Input Mask, Creating A Lookup Field, Creating A Value List, Modifying A Value List, Creating Calculated Fields, Creating Multiple Primary Keys

Creating Multi-­?Table Queries, Using Calculations In Queries, Changing Query Properties, Working With The Expression Builder, Creating A Totals Query, Creating A Parameter Query, Creating A Find Duplicates Query, Creating A Find Unmatched Records Query, Modifying Query Joins

Adding Headers And Footers, Adding Controls To A Form, Moving And Sizing Controls, Creating A Calculated Control, Changing Control Properties, Changing Form Properties, Changing The Tab Order, Adding A Lookup Control, Inserting Graphics, Creating A Subform

Working With Report Sections, Adding Controls To A Report, Changing A Control’S Data Source, Changing A Report’S Data Source, Sorting And Grouping Data, Changing Report Section Properties, Applying A Theme To A Report