Grasp the concepts of databases and how to apply them using Microsoft Access. Create customisable databases from scratch, learn about importing and manipulating data, create user-friendly interfaces and analyse your data before producing relevant reports.
Our courses help you to understand the fundamentals of database design and how to create and manage your own databases. During the initial discussion, we can help you to identify which areas you want to cover. You may find the topics listed below a useful starting point although this is only a sample of the training we cover which is always customised to meet your needs.
|Familiarisation of Access||Default Values||Importing Data|
|General Database Concepts||Customised Forms||Exporting Data|
|Creating Tables||Macro Buttons||Using the Expression Builder|
|Working with Tables||Forms & Subforms||Customising Table Relationships|
|Tables & Relationships||Simple Switchboards||Creating Action Queries|
|Searching for Data||Managing Switchboards||Parameter Forms|
|Filtering Data||Joining Tables in a Query||Advanced Reports|
|Data Entry Forms||Calculations in Queries||Creating Macros|
|Creating Select Queries||Creating Parameter Queries||Editing Macros|
|Creating Reports||Reports with Totals||Familiarisation of SQL|