Training M S B Lane Office Automation Tools Designs
Training and Learning Consulting | Learning Consulting | Customised Training Solutions | Writing and Editing Services
Full Course List | Business Writing | Presentation Skills | Facilitation Skills | Business Etiquette | MS Excel | MS Access | MS Word | Toolbook | Adobe Captivate

MS Office Skills: MS Access 2007/2010

Workshop

Is it for you?

What will it cover?

What will it cost?

Relational Database Design

½ day

Prerequisite: None
Ask yourself:
  • Do you need to build an MS Access or other relational database from scratch?
  • Are you unsure about how to structure your data to minimise repetition and maximise flexibility?
  • Are you unsure about how to structure your data so that you can generate the reports you need?
  • Do you want to ensure that data does not go missing or that unneeded data is automatically deleted?
If you can answer “yes” to any of these questions, this workshop is for you!
Designed for anyone who wants to design a relational database for the most effective and efficient result.

The workshop will enable you to:

  • Understand normalisation rules
  • Understand database relationships
  • Implement referential integrity
R750 per person (min 2 participants)

R7,500 per group (up to 12 participants)
Work with Queries

1 day

Prerequisite: None
Ask yourself:
  • Do you want to be able to go beyond a basic query in MS Access to create queries that sort on multiple values or display specific data based on multiple criteria?
  • Do you want to be able to count records that meet specific criteria?
  • Do you want to modify all data that meets specific criteria at the click of a button?
  • Do you want to be able to show information in a query that pulls from multiple tables?
  • Do you want to combine queries into a single list of data?
  • Do you want to create a query that shows 3-dimensional data?
If you can answer “yes” to any of these questions, this workshop is for you!
Designed for anyone who wishes to use simple and complex queries in MS Access to sort, filter and manipulate data.

The workshop will enable you to:

  • Create a simple query
  • Create simple and complex sorts in queries
  • Create simple and complex filters in queries using Boolean logic
  • Add summarised data to queries (totals, averages, counts)
  • Create action queries and use them to add, modify and delete data
  • Create crosstab queries to present data
  • Create unmatched queries to check data integrity
  • Use Domain lookup and summary functions
  • Understand SQL basics
  • Create UNION queries
R1,500 per person (min 2 participants)

R15,000 per group (up to 12 participants)
Work with Forms

1 day

Prerequisite: Basic Query skills
Ask yourself:
  • Do you want to use forms to make capturing data easier and more efficient?
  • Do you want to allow data entry into multiple related tables on a single form?
  • Do you want to display data on your forms based on information in or summarised from separate tables?
  • Do you want to enhance the look of your forms?
  • Do you want to make it easy for your users to find specific records on your forms?
  • Do you want to display interactive summaries of information in tabular or graphic format on your forms?
  • Do you want to add custom buttons that perform common functions to your forms?
If you can answer “yes” to any of these questions, this workshop is for you!
Designed for anyone who wishes to use simple and complex forms in MS Access to automate data input.

The workshop will enable you to:

  • Create simple forms (single and continuous) based on a query
  • Add bound and unbound controls
  • Format forms and form controls (including autoformats)
  • Work with grouped controls
  • Create subforms
  • Add calculated fields
  • Add a tab control
  • Add sub-forms
  • Create a drop-down list for navigation between records
  • Set form properties
  • Add graphic backgrounds to a form
  • Add lookup fields using Domain Lookup and Aggregate functions
  • Work with pivot tables and charts
  • Add buttons to forms
  • Use forms to create a custom menu
R1,500 per person (min 2 participants)

R15,000 per group (up to 12 participants)
Work with Reports

1 day

Prerequisite: Basic Query skills
Ask yourself:
  • Do you want to present your data in an easy-to-read and easy-to-understand format?
  • Do you need to send your reports to people who do not have MS Access installed?
  • Do you want to highlight specific data automatically in your reports?
  • Do you want to ensure column headings appear on every page in your report?
  • Do you need to display sub-totals and totals at multiple levels in your reports?
  • Do you want to be able to generate a report based on current data on a form?
  • Do you want to summarise your report data in graphic form?
If you can answer “yes” to any of these questions, this workshop is for you!
Designed for anyone who wishes to use simple and complex reports in MS Access to analyse and present data.

The workshop will enable you to:

  • Create simple reports (with totals) based on a query
  • Format report sections and controls using the ribbons and properties
  • Create sub-reports
  • Control how reports print
  • Add calculated fields to reports
  • Use conditional formatting in reports
  • Open reports from a form with filtered data
  • Add charts to reports
  • Share reports in PDF or MS Word format
R1,500 per person (min 2 participants)

R15,000 per group (up to 12 participants)
Use VBA to Automate Processes in MS Access

2 days

Prerequisite: Advanced MS Access skills
Ask yourself:
  • Do you want to be able to create basic applications in MS Access?
  • Do you want to go beyond the built-in functions in MS Access to create your own?
  • Do you want to automate basic calculations or tasks in MS Access?
  • Do you want to pass values from function to function or make a specific value available to any function in your database?
  • Do you want to make sure that the values passed to a function are a specific type?
  • Do you want to be able to create queries on the fly in your functions?
  • Do you want to be able to get specific summary information in your code without using SQL statements?
  • Do you want to be able to automate tasks that affect a specific number or set of records in a table?
  • Do you want to know how to debug your code?
If you can answer “yes” to any of these questions, this workshop is for you!
Designed for anyone who wishes to use VBA to automate tasks and processes in MS Access.

The workshop will enable you to:

  • Understand object properties
  • Understand object events
  • Create a standard module
  • Create procedures and functions
  • Understand data types
  • Work with variables and understand their scope
  • Write a simple procedure
  • Create a simple function
  • Use Domain Functions
  • Work with DAO recordsets
  • Understand and work with SQL statements
  • Use IF statements
  • Use For…Next loops
  • Use Do…While and Do…Until loops
  • Add comments
  • Use debugging tools


The last half day of the workshop will be set aside for participants to work on their own projects.
3,000 per person (min 2 participants)

R30,000 per group (up to 12 participants)
Packaging MS Access Solutions

½ day

Prerequisite: Intermediate MS Access skills
Ask yourself:
  • Do you want users who do not have MS Access installed to be able to use your application?
  • Do you want to ensure that you can upgrade the functionality in your database without affecting the data?
  • Do you want to create an installation package for your MS Access application?
If you can answer “yes” to any of these questions, this workshop is for you!
Designed for anyone who wants to package an MS Access application for ease of installation, distribution and maintenance.

The workshop will enable you to:

  • Create a splash screen and a custom menu switchboard
  • Split a database
  • Use the MS Access runtime environment to run the application in any Windows environment without the need for installing Access
  • Add an icon for your application
R750 per person (min 2 participants)

R7,500 per group (up to 12 participants)
Customised MS Access Workshop

Prerequisite: Depends on training needs
Ask yourself:
  • Do you have specific MS Access skills that you want to improve?
  • Do you need targeted MS Access training?
  • Do you have specific types of data that you need to work with?
  • Do you need to combine some basic, intermediate and advanced skills training?
  • Do you have specific time-frames within which you would like training (e.g., 1 hour/day or 2 hours/week)?
If you can answer “yes” to any of these questions, this option is for you!
Designed for anyone with specific needs around improving MS Word skills.

Customise an MS Word workshop to meet your specific needs.

Choose from the topics in any of the MS Word workshops or specify your own.
R250 per person/training hour (min 2 participants)

R300 per person/training hour (1 participant)


Other MS Office Training: MS Word | MS Excel

For more in-depth training and consulting around building tools in MS Access to automate business processes, see Office Automation Tools.

+27 (0)72 614 6010 M S B LANE msblane@yahoo.com, PO Box 354, Derdepark 0035, South Africa