MS ACCESS Programming
MS ACCESS End User
MS End User
Training Manuals
Back
 
There are two levels of MS Access End User trainings.
MS ACCESS, Part1
MS ACCESS, Part 2
The training is always given by an experienced MS Access developer.
MS Access, Part 1
What is Access?
Access is a database software of Microsoft. You can enter data, search for data and generate your own screens and reports.

Objective:
By the end of a session, you will be able to create your own database, enter the data, make queries and set up reports and forms using the access wizards.

Audience:
This course is intended for every user of Microsoft Access without any particular experience.

Prerequisites:
Knowledge required of the Window environment.

Duration: 2 days.

Contents of the Course:

  • What is Access?
  • Designing a Database
  • Working with Existing Objects
  • Working with Existing Data
  • Table Basics (creating a table, index, records ...
  • Relationships between Tables
  • Import, Export and Link a Table
  • Creating Select-Queries
  • Creating Action-Queries
  • Creating a form and report using the wizards
Top
MS Access, Part 2
What is Access?
Access is a database software of Microsoft. You can enter data, search for data and generate your own screens and reports.

Objective:
By the end of a session, you will be able to create your own reports, forms and use the macros without the use of Wizards.

Audience:
This course is intended for the Access user who wants to get a clear overview of the form and report facilities.

Prerequisites:
Knowledge required of the Window Environment as well as the design of a database, table and the use of queries.

Duration : 2 days.

Contents of the Course:

  • Form Basics, Designing a Form
  • Customising Forms
  • Creating Forms Based on more than one Table
  • Using Expressions and Pictures in Forms
  • Report Basics, Designing Reports
  • Sorting and Grouping Data
  • Using Expressions in Reports
  • Macro Basics
  • Using a Macro in a Form
Top