Microsoft Office Access
For a scalable relational database solution suitable for SME use, Microsoft Office Access takes some beating. Few people harness the real power of Access, which lies in the relationships it is possible to create between entities and the graphical nature of the software that allows the construction of complex joins without any knowledge of SQL.
Access can be found in use in a wide cross-section of businesses, and in web applications using Windows servers. Our courses are tailored to the levels our clients demand. Introduction covers the concepts in database creation, including the terminology so many people find difficult to fathom. Out Intermediate course builds on this foundation, while the Advanced offers Form creation, Internet integration and a look at SQL statements to create more sophisticated queries.
Access 2000 (XP and 2003 use the 2000 engine) and 2007 versions are offered.
Introduction - Course content
| Database Concepts | Working with Fields and Records |
| Database concepts and terminology | Changing the design of a table |
| Exploring the Access environment | Adding and deleting records |
| Planning and designing databases | Finding and editing records |
| Getting help | Sorting and filtering records |
| Closing a database and Access | |
| Access Basics | Creating Databases |
| Exploring tables | Creating a database |
| Examining queries | Using the table wizard |
| Exploring reports | Working in design view |
| Querying Tables | Creating and Using Forms |
| Creating and using queries | Creating forms by using AutoForm |
| Modifying query results and queries | Using the form wizard |
| Using calculations in queries | Using design view |
| Importing, Exporting and Linking | Creating and Using Reports |
| Importing Access objects | Using the report wizard and queries |
| Exporting Access objects | Creating, modifying and printing reports |
| Linking Access objects |
Intermediate - Course content
| Creating relational databases | Working with related tables |
| Database normalising | The lookup wizard |
| Introducing relating tables | Changing lookup fields |
| Adding referential integrity | Inputting data to related tables |
| Defining data entry rules | Using advanced query features |
| Using input masks | How to join a table in queries |
| Setting a property | Creating a calculated field |
| Setting a validation rule | Using an action query |
| Creating advanced queries | Creating advanced form design |
| Summarise and group values | Working with graphics |
| Create a cross tab query | Working with calculations |
| Using a parameter query | Working with combo boxes |
| Using an index | Working with unbound controls |
| Using advanced report features | |
| Create customized headers and footers | |
| Add a calculated value | |
| Work with sub-reports |
Advanced - Course content
| Creating Advanced Forms | Macros |
| Designing a form based on joined tables | Create and run macros |
| Automating data entry | Attach macros to events of database objects |
| Grouped control | |
| How to improve the user interface | |
| Designing sub forms | |
| Creating Advanced Macros | Exploring Access SQL |
| Create macros to provide user interaction | Identify different clauses in an SQL statement |
| Create macros requiring user decision | Writing SQL statements |
| Use Auto Keys and AutoExec macros | Attach an SQL statement to database objects |
| Integrating the Internet | Managing Databases |
| Work with hyperlink fields | Work with database utilities to optimise resources |
| Work with data access pages | Secure data by database replication |
| Security Fundamentals | |
| Protect databases |

