Access Skills Library

Easy

• What is a database
• Tables, fields and data types
• Setting primary keys
• Importing data from Excel
• Creating simple queries
• Sorting and filtering records

Intermediate

• Relationships between tables
• Query criteria and wildcards
• Calculated fields in queries
• Totals and grouping queries
• Find duplicates and unmatched queries
• Building forms for data entry
• Creating and formatting reports
• Combo boxes and drop-down lists
• Input masks and validation rules

Advanced

• Action queries (append, update, delete)
• Splitting a database into front end and back end
• Linking Access to SQL Server
• Introduction to macros in Access
• Compacting and repairing a database