Learn Essential Techniques to Handle Data the Right Way
Course Code: VTLOKABX3
Duration: 2 Days (14 Hours)
Whether you’re a novice or an expert wanting to refresh your skills on Microsoft Access, this 2-day course will guide you how to determine what fields are needed for the database/system, how many tables are needed and which fields and tables go together using essential normalization approach.
• How do I determine what fields are needed for the database/system?
• How do I determine how many tables are need?
• How do I determine which field goes into which table?
You will also learn how to use the various data types, input masks to create an effective and relational table.
Once all the required normalised tables are properly created, you can use them to generate useful queries, forms and reports. You will also learn how to import data to the access table and export queries, forms and reports to other Microsoft applications
Why spend weeks to create your reports manually, when you can save time creating a report by setting an effective and accurate database using Microsoft Access?
This Course is Suitable For
Learners with zero to little knowledge of using Microsoft Access 2013. Also suitable for those who what to refresh the MS Access skills from earlier versions.
Public Sector – Division 1, 2 & 3
Private Sector – Applicable to All
- Introduction to Database
- Database Normalisation
- Getting Started with MS Access
- Naming Conventions
- Table Design
- Understanding Relationships
- Import Data
- Working with Datasheet View
- Query Design
- Export Data from Access Table to an Excel File
Questions to Ask Yourself
I’m very experienced in using an earlier version of Microsoft Access; can I skip this course and join the Access 2013 Advanced course?
Yes, you can but we do not recommend it.
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.