Trusted Training Partners
Home / Non-Accredited / Software & IT Non-Accredited / Microsoft Access 2010 Intermediate Course
Quick Look Course Summary:Microsoft Access 2010 Intermediate Course
-
Next Public Course Date:
-
Length: 1 day(s)
-
Price (at your venue): 1 Person R 4,811 EX VAT 3 Person R 3,654 EX VAT 10 Person R 2,719 EX VAT
-
Certification Type:Accredited
-
Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.
Get Free & personalised
Training Advice
Microsoft Access 2010 Intermediate Course
Course Introduction
In the intermediate Access course we teach students the more advanced functions of Access. At the end of the course students will understand how to maintain data integrity, how to create custom forms, successfully create queries and create custom reports.
Course Outline
1. Maintaining Data Integrity
Type of Data
Restricting the Amount of Data
Data Formatting
Validation Rules
Restricting Data to Values in Lists
Restricting Data to Values in Other Tables
2. Creating Custom Forms
Customising Wizard created Forms
Adding Controls
Adding Sub forms
Using E-Mail forms to Collect Data
3. Creating Queries
Creating Queries using Wizard
Creating Queries Manually
Summarising Data from Queries
Performing Calculations from Queries
Updating Records from Queries
Deleting Records Using Queries
4. Creating Custom Reports
Creating Reports Manually
Customising Report Content
Adding Sub-Reports
Course Duration
1 day/s
Who should attend
This course is intended for intermediate users of Microsoft Access.
**Quote does not include Any Exam Fees (if applicable)
IMPORTANT ACTION: Do Not Wait To Improve Your Skills. Â
Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal
About this course
This course is not accredited. It is delivered as a professional skills programme, and delegates receive a BOTI certificate of attendance.
If you need a credit-bearing outcome for B-BBEE skills development, SETA grant or learnership purposes, please see our accredited qualifications and skills programmes, or read about BOTI accreditations.
Frequently Asked Questions
Is this course accredited?
No. This course is delivered as a practical, facilitator-led skills programme and delegates receive a BOTI certificate of attendance. If you need a credit-bearing outcome for B-BBEE skills development, SETA grant or learnership purposes, ask us about our accredited qualifications, skills programmes and unit standards.
Can this course be delivered in-house at our premises?
Yes. Every BOTI course can be delivered on-site at your offices anywhere in South Africa, or at a scheduled public venue, and can be customised to your team and industry.
How do I book or get a quote?
Use the enquiry form on this page for a tailored quote, or call 011 882 8853 / email [email protected]. The course length and next public course date are shown in the Quick Look summary.
Can this training count towards our B-BBEE scorecard?
Spend on this course still counts as skills development expenditure for B-BBEE purposes, but it does not count as accredited training spend, and the Codes limit how much non-accredited training can contribute. Please confirm the treatment with your skills development facilitator or B-BBEE verification agency.
Do you tailor the training to our industry?
Yes. Our training is built around your business, using practical, real-world examples relevant to your team and sector.