Managing the Challenge of Constant Change

Text Box: Training
Text Box: Microsoft Access Fundamentals 2007 *
Text Box: Microsoft Access Develop & Program 2007/2010

*

V. 2010 in preparation

v. 2003 also available

Text Box: To purchase a course on-line, download the Overview pdf file. Follow steps prescribed.

The course is designed to comply with and exceed the Microsoft Access certification program and with full understanding of this manual, passing the examination should present few problems.

In database design, we are concerned with the primary objects, tables, queries, forms etc. that together provide a productive solution to very specific information needs. The fundamentals of table normalisation, data types, relationships and the individual properties of fields or controls need full comprehension if a database is to perform as planned.

 

The course requires that delegates have a basic understanding of the Windows operating environment and a sound knowledge of a spreadsheet program or a data management system.

The course assumes that the delegate has a sound understanding of Microsoft Access, specifically, table normalisation rules, field data types and the organisation of tables as related entities. In addition, the creation of complex queries, forms and reports should be known. Ideally, the Access Fundamentals course should be completed first.

 

The course is designed for people who wish to pursue the development and implementation of Access in a multi-user environment.

The manual is complimented by a wealth of follow-up information on CD, invaluable to delegates designing their initial databases.

Most code examples are taken from databases currently in use by our clients. The manual does not take an academic approach to programming, rather the down-to-earth, practical application of code in real-life situations.