Microsoft Access Computer Training

Level 1 – New User (1 day)

• what's new in your version?
• overview of Access features and capabilities
• functional elements of the Access screen
• obtaining help
• opening, closing, saving and searching for files
• recap of database terminology and introduction to 'objects'
• overview of good database design - choice of fields and keys
• creating a new data table plus entering, viewing and editing data
• using simple sorts and filters on a table
• using the Find and Replace function to update multiple records
• creating and using simple find queries
• producing a basic report
• basic printing techniques, (including printing a table's structure)

Level 2 – Regular User (1 day)

• more database design concepts - normalisation, indexing and relational concepts)
• changing a table’s structure, (and what might be lost)
• using different ‘joins’ and establishing referential integrity between related tables
• updating a data table with an update query
• designing and using a form, (including sub-forms)
• creating a graph from your data, (including customising)
• creating a crosstab query, (PivotTable)
• creating more complex reports, (including grouping and sorting)
• designing and building a simple ‘switchboard’ user interface
• importing and exporting data between other software packages
• compacting, repairing and protecting your database

Level 3 – Advanced User (1 day)

Using Access reports effectively…

• grouping reports
• creating mailing reports, (e.g. for labels)
• working with reports and embedded sub-reports
• using expressions and functions
• creating graphics in reports
• using hyperlinks in reports

Using Access forms effectively…

• creating ‘splash’ screens
• working with forms and embedded sub-forms
• using graphics in forms
• using command button controls

Access macros…

• introduction to creating and editing Access macros