Why is this training very special?
Data storage, Data administration and data structuring
are the areas of application of ACCESS. All kinds of data can be stored at small
expenditure, ordered and afterwards evaluated on the basis of many criteria.
However, the more extensively an ACCESS - application becomes, the more
importantly is perfect technical knowledge of the concerned the business
processes, as well as much knowledge of general data base developments.
This Training for a perfect development of ACCESS
applications and data base design will arrange the necessary knowledge for you.
It will help you to organize and administer your data. You will get the
necessary detailed knowledge over the functions for handling of the integrated
tools of Access. You will extend your knowledge about useful methods and
techniques while using ACCESS. And you will learn how these tools can support
you with the daily work.
Use the chance of this offer and receive you the
certificate as "Certified MS ACCESS User", where we confirm that you
have successfully absolved this training.
Conditions for visiting this seminar
Very good knowledge about
MS Windows and MS Office
Certificate
After absolving this
training and an agreement of the trainer we will make out a certificate with
the title “Certified MS Access User”
with detailed information about the learned subjects. You will receive this
certificate 2 weeks after finishing the training.
Your level of qualification
will be tested each day. But don’t worry – we will not produce examination
stress but our target is that you will be able to practice the learned
subjects.
Seminar Organization
Generally we plan to
organize the training location and the training schedule together with you. We
are prepared for organizing the training at the location of your company or at
an external location.
|
Location |
Hotel / Company’s
location |
|
Seminar Date |
According to our
agreement |
|
Seminar Duration |
4 days (maximal 5
participants) |
|
Seminar Language |
English or German or
Romanian |
|
Seminar Price (individual) |
€ 1.600,-
per Person. This price doesn’t include VAT. |
|
Seminar Price (Groups, up 3) |
€ 1.440,-
per Person. This price doesn’t include VAT. |
|
Seminar Price (Company) |
According to our
agreement, but exclusive accommodation and traveling costs of the trainer.
This price doesn’t include VAT. |
|
|
|
|
Hotel / Restaurant |
In case that the seminar will
be organized at a Hotel / Restaurant, the hotel costs (accommodation) and the
restaurant costs (food and drinks) are
not included into the seminar price and have to be paid directly at
the reception desk of the Hotel / Restaurant by the participants. |
MS Access - Training :
Contents
·
Overview and introduction
o
Bases of MS Access
o
Data base Design
o
Normalization of data bases
o
Access and evaluation from the
data bases
·
Data base
tables
o
Data model
o
The first data base
o
Table Design
o
That Primary key
o
Navigation and treatment of a
table
o
Data field types - information on
the lowest level
o
Further data field characteristics
o
Table characteristics
o
Filtering and sorting of table
contents
o
Relations between tables
o
Support by the table assistant
·
Representation
at the screen - forms
o
Production of forms
o
Form Design
o
Control members for interaction
with the user
o
Control member characteristics
o
Sub forms for detail data records
o
Printing of forms
o
Definition of dialog fields
o
Development of Page header and
page footing
·
Inquiries
of data contents
o
Provide of inquiries
o
Criteria to record selection
o
Joining of several tables
o
Sort of data records
o
Grouping of data records
o
Domain functions for the data base
analysis
o
Execution of calculations in a
data base inquiry
o
Parameter controlled inquiries
o
Action controlled inquiries
o
Using of the inquiry assistant
·
Reports –
Data output on paper
o
common attributes of forms and
reports
o
Grouping and current sums in the report
o
Reports print
o
Range characteristics
o
Using of the report assistant
·
Macros and
modules
o
The first macro
o
Structure and functionality of
macros
o
Moduls