Trusted Training Partners
Home / Software & IT / Software & IT Courses / 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,810.63 EX VAT 3 Person R 3,653.99 EX VAT 10 Person R 2,719.12 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
