Microsoft Access - Advanced
|Presentation Style:||Tutor-led Classroom|
|Course Time:||09:30 - 16:30hrs|
|Cost:||Public Courses: £480 + VAT per delegate (call for group discounts)
Closed Courses: please enquire
|Click a date to book:||No upcoming courses|
What will you learn on this Microsoft Access Training Course?
In this course, you will extend your knowledge of some of the most specialised and advanced capabilities within Microsoft Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports and maintaining a database.
Understanding Properties Building forms, forms based on joined tables, automating data entry using grouped controls, enhancing the user interface, sub-forms, changing tab order, inserting the date and time into a form header
Create a PivotTable, modify a PivotTable, working with a PivotChart
Creating and running macros, attaching macros to events, macros and database objects
Macros to provide user interaction, user decision defined macros, using auto keys, auto exec macros
Working with hyperlink fields
Protecting databases and user level security
- Buffet lunch included and free parking (only for courses held at Paradise Training Centre)
- Joining instructions will be sent prior to attending the course