100 megs data gift for every genuine quote requested

So you’re ready to take your MS Access 2010 skills to the next level beyond simple database queries. This intermediate level course is designed to give you a deeper understanding of the powerful data mining tools available in this software.

The MS Access 2010 Intermediate Training Course provides training in setting table relationships, customising reports, create pivot tables and pivot charts, conducting self-join queries, work with orphan records and much more.

This dynamic training course is now available in Gauteng, Durban and Cape Town.

Contact us today for a group quote.

Excel

Word

PowerPoint

Outlook

Access

Project

Who Should Attend

This course caters for people who have attended the Access Beginner course or have a comprehensive working knowledge of Access.

During this course, you will learn how to build tables to store data, create forms for data entry, create and run queries to analyse data and produce printable reports.

Participants will learn how to normalise data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use Pivot Tables and Pivot Charts.

Learning Outcomes - Microsoft Access 2010 Intermediate Training Course

  • Normalise tables, use the Table Analyser, & identify object dependencies
  • Set relationships between tables
  • Implement referential integrity
  • Plan & print table relationships
  • Work with orphan records
  • Set and test cascading deletes & updates
  • Create & modify lookup fields
  • Work with controls
  • Enter data in a related table
  • Use the Query Wizard & Design view to create joins

Course Content - Microsoft Access 2010 Intermediate Training Course

Lesson 1: Controlling Data Entry
Topic A: Constrain Data Entry Using Field Properties
Topic B: Establish Data Entry Formats for Entering Field VTopic 1C: Create a List of Values for a Field

Lesson 2: Joining Tables
Topic A: Create Query Joins
Topic B: Join Tables with No Common Fields
Topic C: Relate Data Within a Table

Lesson 3: Creating Flexible Queries
Topic A: Set the Select Query Properties
Topic B: Retrieve Records Based on Input CriteriaTopic 3C: Create Action Queries

Lesson 4: Improving Forms
Topic A: Restrict Data Entry in Forms
Topic B: Organise Information with Tab Pages
Topic C: Add a Command Button to a Form
Topic D: Create a Subform
Topic E: Display a Summary of Data in a Form
Topic F: Change the Display of Data Conditionally

Lesson 5: Customising Reports
Topic A: Organise Report Information
Topic B: Format Reports
Topic C: Control Report Pagination
Topic D: Summarise Report Information
Topic E: Add a Subreport to an Existing Report
Topic F: Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications
Topic A: Import Data into Access
Topic B: Export Data to Text File Formats
Topic C: Export Access Data to Excel
Topic D: Create a Mail Merge