Microsoft
Access
Microsoft Access is a database management system from Microsoft, packaged with Office which combines the “Jet” relational database engine with a graphical interface intended to make it possible for relatively unskilled programmers and non-programmers to build sophisticated and complex databases. Microsoft Access delivers powerful tools for managing and analyzing data.Access is commonly used by small businesses and hobby programmers to create customised systems for handling small tasks.
Access Introduction
Overview and objectives
Access 2000 is the popular database from Microsoft designed specifically for a graphical environment. This course is designed to give you an understanding of some of the major features and functions within Access. An introduction to database theory and practice, plus hints and tips on good database design techniques are also given.
Who should attend?
New, recent or intending users of Access 2000 who have little or no existing database knowledge.
Course prerequisites
A basic understanding of PCs and familiarity with the layout of a PC style keyboard, mouse and Windows is required, gained either by previous experience or by attendance on a "PC Fundamentals" course.
Introduction to Access 2000
Getting started with Access 2000
Getting assistance with Access 2000
Creating tables and adding records
Designing table structures
Working with data
Forms
Simple select queries
Simple reports
Access Intermediate
Overview and objectives
This intensive course is designed to give existing Access 2000 users additional skills and knowledge on using the many features and functions of this software to make them more efficient and effective when processing data with Access. This entirely 'hands on' course will give participants experience in producing database applications and the ability to create a variety of data views, queries and reports.
Who should attend?
Existing users of Access 2000 who want to get grips with some of the more advanced features of this package as quickly as possible.
Course prerequisites
A basic understanding of PCs, Windows 95/98/NT/2000 and Access 2000 is required, gained from previous experience or by attendance on an "Access 2000 Introduction" training course.
Access 2000 Intermediate
Database design
Using field properties for protection
Table relationships
Queries
Forms
Reports
Access tools
Access Advanced
Overview and objectives
This one-day intensive course is designed to give existing users an insight into some of the more advanced features in Access. This entirely 'hands on' course will give participants a further understanding of database design principles, advanced forms, reports and query design, including using calculations.
Who should attend?
Existing users of Access for windows who want to customize forms, queries and reports.
Course prerequisites
A basic knowledge of Access gained through use of the product or by attending an "Access 2000 Intermediate" course.
Access 2000 Advanced
Database design
Access 2000 performance issues
Building and modifying forms
Access and the Internet
Advanced queries
Action queries
Producing reports
Access Professional
Overview and objectives
This intensive course is designed to give advanced users further tips about how to get the most out of Access. This entirely 'hands on' course will give participants a further understanding of customizing databases through command buttons, macros and menus and using the database management tools.
Who should attend?
Existing users of Access who want to customize databases using macros and gain knowledge of the more advanced tools.
Course prerequisites
A thorough knowledge of Access gained through use of the product or by attending an "Access 2000 Advanced" course.
Database management tools
Multi-user databases
Access Macros
Analyzing Access data in Excel
Designing an Access application