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
|
