| |
| Aim of Course | To provide the experienced user with knowledge to use more advanced functions within Microsoft Access 2000 |
| Target Audience | Users of Microsoft Access 97 who have existing knowledge and need to expand their uses within the package. |
| Structure of Course | Throughout the course the participant is given a series of exercises to complete more advanced queries, work with forms, macros and report designs. This will to enable successful and efficient use of the program. |
| Training Facilities | Training will take place in one of 3 fully equipped training suites delivered by professional lecturers. Up to date multimedia and interactive software/smartboards. Free on-line back-up support after training. |
| Course Content | Database Design and Structure Working with Menus &Toolbars/Customising Toolbars Working with Index and Keys Creating Primary Keys Defining Relationships Creating a Relational Database Designing Tables Optimise General Performance Working with Form Design/Customised Design Working with Advanced Forms Design Sharing a Database Importing or Linking Tables Creating Fields to Store OLE Objects & Pictures Creating Fields for True/False Scenarios Creating Fields to Store Hyperlinks Completing Multi Queries Creating and using Report Functions Working with Controls on Forms/Reports Inserting Command/Action Buttons Writing Expressions Working with Macros/Using Conditions in Macros Use Address Tables With Word Mail Merge |
