|
Microsoft
Access
Microsoft Access
is a powerful and flexible database management program, that helps
organisations store and retrieve information. Suitable for both novice
database users and experienced programmers. Access allows its users
to build powerful, customisable business solutions that intergrate
easily with the Web.
Our Microsoft Access courses come in 3 levels - Beginners,
Intermediate and Advanced.
The Microsoft
Access beginners course covers 15 hours working through an instruction
manual with exercises and sample data. A trainer will get you started
with a tour of Access and the applications capabilities, before showing
you how to work through the exercises to create simple databases and
reports. Trainers will be available in the classrooms at all times
if you need assistance.
Syllabus
An Overview of Access 2003
Managing Data
Establishing Table Relationships
Querying the Database
Designing Forms
Producing Reports
back
to top
Access Intermediate will provide you with the knowledge to create
a new database from scratch. You will learn how to create and change
the design of Access Forms, add tables, relationships and create a
switchboard. The intermediate course is one step further towards becoming
a database developer.
Access Intermediate
covers 15 hours, working through an instruction manual with exercises
and sample data. A trainer will get you started with a tour of Access
and the applications capabilities, before showing you how to work
through the exercises to create simple databases and reports. Trainers
will be available in the classrooms at all times if you need assistance.
Syllabus
Planning a Database
Building the Structure of a Database
Controlling Data Entry
Finding and Joining Data
Creating Flexible Queries
Improving Your Forms
Customizing Your Reports
Expanding the Reach of Your Data
| Intermediate |
| Flexible |
| 15
hours |
| Anytime |
| £175 |
back
to top
At the advanced
level, your training covers complicated forms and subforms, mathematical
expressions in queries/forms and reports. We also cover specific data
analysis concepts, such as crosstabulation with crosstab queries,
and query enhancements with macros.
The Access advanced
course covers 30 hours working through an instruction manual, with
exercises and sample databases. A trainer will get you started with
the application before showing you how to work through the exercises,
to create and modify databases and reports. Trainers will be available
in the classrooms at all times if you need assistance.
Syllabus
Structuring existing
Data
Writing Advanced Queries
Simplifying Tasks with Macros
Adding Interaction and Automation with Macros
Making Forms More Effective
Making Reports More Effective
Maintaining an Access Database
back
to top
|
