Microsoft Access Advanced
Who is the course for?
This is a practical hands-on course designed for experienced Access users to extend their skills and expertise
Is this course suitable for me?
Take the Skills quiz
Pre-requisites
The course assumes that you have a good understanding of relational databases, that you know how to create various types of queries
What are the objectives of the course?
By the end of the course, you will be able to
Design and create complex forms and reports, including graphics, sub forms and sub reports
Automate a database using macros and command buttons
Add finishing touches to a database application including switchboard forms and start-up options
Set security level to control access to your database and objects
Customise menus and toolbars
What does the course cover?
Design form: Understanding the design window; form sections; adding controls bound, unbound and calculated controls; adding tab controls; synchronising sub-forms; using list and combo boxes; using a combo box to set query parameters
Designing reports: Designing a report; grouping, sorting and summarising; report sections and properties; controlling layout, pagination and page setup; embedding a subreport; creating a report snapshot; embedding pictures and graphics in forms and reports
Understanding events: Exploring access events; default behaviours for events; how to customise and control event behaviours
Automating your database: Creating macros; adding actions, arguments and comments; macros which respond to different events; macros for positioning and sizing forms; automating data entry with macros; using macros to print records; creating pop-up forms with macros
Creating an application: Toolbars and key assignments; creating custom menus; creating keyboard assignments, customising toolbars; attaching custom toolbars to form
Implementing security: Splitting the database; setting passwords; setting a database password; protecting the front end database; testing security settings
How long does the course last?
1 day
