Microsoft Access Advanced

  • The Course
  • Contents of the Training
  • Shedule

NHK gives the course of Advanced Access 2003, which include advanced concepts of management of databases.

Objectivs

In the end of the formation the participants will be apt to use the most advanced functionalities of the Access.

For whom?

Any person that needs to use the advanced functionalities of Access, forms, modules and macros.

Requirements

For this course the persons must have basic knowledge of Windows environment and also Microsoft Access.

Pedagogical Methodology

Mixing sessions with practices and theory, with description of the subjects and experimentation in a personal computer. Exercises with individually resolution.

Duration

10 hours

Price

122,34€
Exemption of VAT - n.º 53 of the Art. 9º Cod. of the IVA from 30/01/2003

If you liked this course, then we sugest:

Word | Excel

 

1st. Session

Import and export Access objects;
Linkings of tables

2nd. Session

How to use formulas
How to use functions
How to apply properties in calculated fields
Description of the different types of Queries
Automatic formats
How to create formatting styles
How to insert Images

3rd. Session

How to use the forms properties;
Types of Control;
How to use the tools box;
How to create a text box with calculations;
How to apply functions on a text box;
Create a form that allows to accede to remaining forms;
Insert Graphs;

4th. Session

Creation of access pages for insertion of data;
Creation of access pages for consultation of data;
Creation of access pages for analyzes of data;

5th. Session

What's a macro;
Different kinds of actions for macros;
How to create macros;
Attribute macros to the access objects;
Create navigation displays;
How to apply a password to the database;