A range of 1-day training courses, aimed at a variety of levels, to give you all of the Microsoft Access XP skills needed to operate effectively in today's demanding and rapidly changing business world.
Microsoft Access XP - introduction course
Explore the potential of databases and develop the basic skills to use them effectively.
Enter and Edit Data * Find data * Manipulating tables * Creating a Database * Create a Table * Add Key Fields * Select Queries * Selection Criteria * Queries from more than one table * Create a form * Modify a Form design * Simple Reports.
Microsoft Access XP - intermediate course
Add to basic knowledge to produce more complex databases.
Customise Forms * Add Calculated controls, combo boxes, check boxes, command boxes to forms * Work with Form Properties * Generate Mailing Labels * Reports with Totals * More about Select Queries * Totalling Queries * Parameter Queries * Sort and Filter data.
Microsoft Access XP - advanced course
A series of advanced skills for the experienced user to get more out of Access.
Multi-table Queries * Action Queries (Make tables, Delete, Append, Update) * Cross-tab Queries * Query from a Form * Relationships * Forms and Sub-Forms * Macros * Planning an Application * Database Administration
Microsoft Access XP - workshop course
A combination of problem-solving and training using "real" data and systems.
Best carried out in 1:1 or small groups - for more experienced users * Can either use your own data or supplied examples of real systems * Can combine any topics from the above courses