The data management system Microsoft Access from the Office family is used by many midsize companys for administrating and editing data. If you intend to work with this software the IT-WINGS Access basic training in Stuttgart or local is the best choice.
In our 3 day Access training you will learn theoretical and practical knowledge with which you can work independently on an existing or new Access database.
We accompany you step by step through practical orientated exercises, starting with the theoretical foundation e.g “What are relational databases” up to the creation of databases, modification and analysing of database content with querys and creation of additional objects (e.g. Formulars,reports, etc.).

Training audience / -goal

The Access training is for Access rookies with basic computer knowledge who want to establish and maintain databases. The purpose for the training is the independant work with Microsoft Access.
The following points conclude some of the topics which are discussed within the training:

Database theory
  • What are relational databases / models?
  • What does integrity mean?
  • What and for which use is a normalization?
  • etc.
  • EXERCISES WITH SOLUTIONS
Charts
  • Which data types exist?
  • Which formats can be chosen?
  • What is an index?
  • The meaning of a Key?
  • How do you create relations?
  • How to import external data?
  • How to export data?
  • etc.
  • EXERCISES WITH SOLUTIONS
SQL-requests
  • Which requests exist?
  • How can requests be worded and applied?
  • Data-handling with SQL-requests?
  • etc
  • EXERCISES WITH SOLUTIONS
Further requests
  • Use of criteria and expressions
  • Using aggregates
  • Contingency table
  • Find and edit doubles and inconsistencies
  • etc.
  • EXERCISES WITH SOLUTIONS
Reports
  • How to create reports?
  • Edit layouts of reports
  • Data grouping
  • Data calculation
  • Etiquette creation
  • etc.
  • EXERCISES WITH SOLUTIONS
Forms
  • How do you create forms?
  • Editing the layout of forms
  • Use of formular-assistants
  • Use of controls
  • etc.
  • EXERCISES WITH SOLUTIONS
What is imperative for us regarding in the training

For every point of the training we will include practise-orientated examples.After that you will get exercises that you solve in groups with Google Analytics.If there are points important to you , we will highlight them and further analyses review with you. If we cought your interest, please contact us for additional information.

Training requirements

Requirement for the training is basic Windows knowledge.

For the training in Stuttgart there should be at least 6 people. Maximum number of people per training is 12.

Database creation with Micrsoft Access

3 days Microsoft Access training (in Stuttgart)
595 Euro pro Person

Attendance fee 595,- € inkl. USt.
Inhouse-training at your company is possible!

sendclear