Home >> Training >> Courses Available
Oryx XL - excelling in IT support services
Microsoft Access. Introduction & Intermediate (2 Days) Download Microsoft Access PDF
Course Contents:
| Introduction to Databases Database concepts Database layout Creating a new database Opening a database |
Working with Tables Sorting the Table Deleting a Table Table Layout Changes |
| Tables Creating Tables Using the Table Wizard Creating Tables in the Design View Data Types Field Properties Data Entry Problems Moving and Copying Records |
Queries The Simple Query Wizard The Design View Modifying the Query Using Basic Criteria Additional Criteria Parameters Multiple Object Queries |
| Types Of Query The Crosstab Query The Make Table Query The Append Query The Update Query |
Reports Reports. AutoReport The Report Wizard Creating a Report With Calculated Totals. Using the Label Wizard Modifying and Redesigning The Report. |
| Customising Forms Forms. Using AutoForm Creating A New Form Using the Form Wizard Creating A Form With A Subform. Modifying And Redesigning The Form |
Macros Simple Macros Autoexec Macro |
| Switchboards Creating a Switchboard Editing a Switchboard |
Cost: The fee for the course is fully inclusive of certificate, student manual,
lunch and refreshments throughout the day.
Support: Each trainee will receive six months free telephone support after the
course. This is available during office hours.
Other courses you may be interested in:
Microsoft Excel. Introduction, Intermediate & Advanced (1 day each)
Microsoft Word. Introduction, Intermediate & Advanced (1 day each)
