Learn to Get More Useful Information Out From Your Database
Course Code: VTLOKAAX3
Duration: 3 Days (21 Hours)
A 3-day hands-on follow on course designed to equip user with the ability to construct advanced queries, design forms using pivot table and pivot chart for more complex data retrieval and record handling. Add controls to reports for more targeted results and layouts to suit your needs.
Learn how to automate your tasks in Access with macros and connecting macros to your forms and tables. Jump into screens and panels quickly with Access’ switchboard features to save time. Receive valuable insights and tips to data handling and get the most out from Access.
This course is designed with appropriate hands-on exercises to allow you to practice key lessons taught to help you understand and become familiar with the components and features in Access.
This Course is Suitable For
Learners who have attended our Microsoft Acess 2013 Basic to Intermediate course or for users with good working knowledge and experience in using Microsoft Access 2013.
Public Sector – Division 1, 2 & 3
Private Sector – Applicable to All
- Simple Query Wizard
- Summarise Data
- Action Queries
- Form Design
- Create a Standard Form
- Manipulating Layouts
- Working with Form Template
- Form Control Essentials
- Report Design
- Working with Controls
- Add Field
- Page Break
- Creating Serial Number on a Report
- Adding the Calculated Control
- If…then…Else Macro Block
- Adding Comments
- Group Macro
- Built-in Functions
- Standalone Macro
- Embed Macro to Form Control
- Connect Macro to Table
- Navigation System
- Build Forms with Navigation
- Using MSysObjects
- Create Navigation Forms
- Designating a Startup Form
Questions to Ask Yourself
I’m very experienced in using an earlier version of MS Access; can I sign up for this course without attending the Basic to Intermediate course?
Yes, you can but ONLY IF you are very familiar with the Access 2010 or 2007 features covered in our basic to intermediate module.
For Your DelightRefreshments are provided for morning and afternoon tea breaks.
A Certificate of Attendance will be given subject to 90% attendance.
We can tailor this course to suit your needs in terms of course dates, times and location. If you are an organisation, we can further customise the course to meet your training needs and requirements.