Access - Level 3

A course for delegates wishing to develop more sophisticated Access applications, this course contains the prerequisites for those going on to learn full-scale Application Development. A sound understanding of relational databases and basic table, query, form and report design skills are required.

Learning Objectives

• Design & Create a Relational Database
• Create Main / Sub Input Forms for Easy Data Entry
• Create Reports without the Wizard understanding report sections
• Understand and create specialized queries
• Create action queries to modify data on a large scale
• Create a Switchboard
• Create a Simple Dialog Box
• Create Macros
• Understand and Write Basic VBA

Focus

• Relational Database
• Main / Sub Forms
• Advanced Report Design
• Specialised Queries
• Action Queries
• Specialised Forms
• Macros
• Introduction to VBA

Duration: 2 Days