Microsoft Access 2007

  • The Course
  • Contents of the Training
  • Shedule

NHK gives the course of Access 2003 contemplating concepts basic of the used data-base system of management more in the computers staffs.

Objectivs

In the end of the formation the participants will be apt to enunciate the rules for a database creation, to create empty databases.

For whom?

Any database user, who needs to use this TOOL.

Requirements

For this course Students must have basic knowledge of Windows environment.

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 (5 sessions of 2 hours each)

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

How to define database;
How to enunciate the concept of field, register and table;
How to enunciate the rules for the creation of a database;
How to structuralize a database;
How to enunciate the different forms to initiate the Microsoft Access;
How to enunciate the different components of the Application window;
Creation of Tables;
How to enunciate and to apply the different types of data;
How to apply primary keys

2nd. Session

How to describe the exclusive importance of Primary fields;
How to describe and to enunciate the relationships types;
How to create relations manually;
How to organize relations project;
How to eliminate relations;
How to enunciate the form concept;
How to create forms with the assistant;
How to use the form sight;
How to create forms with subforms;
Introduction of data;
Command Buttons;

3rd. Session

How to create consultations in structure sight;
How to create consultations using the assistant;
Simple Consultations;
Criteria Rank;
Parameters Rank;
Consultation to locate duplicates;
Crossed reference Consultation;
Consultation to locate not corresponding;
How to keep consultations;
How to use the option to show;
How to execute one consults;

4th. Session

How to enunciate report concept;
How to create reports for the assistant;
How to create reports with groupings;
How to use daily pay-visualization sight;
Assistants of labels;
How to format Reports;

5th. Session

Database Compacting and repairing;
How To create start form;
Database Starts;


To know more about this course please contact us.