Microsoft Access Advanced

Introduction
This course will enable sophisticated users of Access to further build on their existing knowledge and equip them with the skills to utilise the advanced functions of Access. Post course support is available for 3 months following the course via Telephone or Email.

Course Content

• Validating data: table and form level validations
• Using default fields
• Setting required fields and limiting field size
• Using input masks and formatting fields
• Creating hyperlinks and saving as a Web page
• Working with PivotCharts
• Working with simple validation macros
• Optimising performance, compacting and repairing databases
• Using the User Level Security Wizard

Suitability

Delegates who wish to fine tune their databases, use Access security and integrate with the Internet.
This course outline can be adapted to meet the needs of an organisation, department or team. Details and prices are available on request.

Assessment

No formal assessment

Duration

1 day (9:30am - 4:30pm)
Course notes and / or manuals are provided

Progression