Microsoft Access
Access is a relational database which means it can split your data into multiple interlinked tables thereby reducing the amount of data duplication required. It has the ability to link to data in Excel and use this data for viewing, editing and writing queries for reporting purposes.
Our training courses will help you understand design principles, starting with tables and field properties, and how to create relationships between them. Once these are in place we will look at creating forms for data entry; writing queries to extract data or perform actions on existing data; and writing reports from tables or queries.
COURSE AIMS |
This one-day course is intended for new users of Access. The course introduces delegates to the main Access components: tables, queries, forms, and reports. Delegates design a new database by first creating a table, and adding data, and then create queries, forms and reports to enhance the database.
The course is highly interactive and will encourage all delegates to join in, to enhance their own learning process and understand how this application can be applied in a business environment for the handling of large quantities of information.
|
|
Read more: Microsoft Access Introduction
COURSE AIMS |
To provide delegates with a knowledge of how to manipulate data within a database with particular emphasis on data entry, extraction and the use of reports. It will also examine the structure of a relational Database to provide efficient functionality and ease of accessing the data via reports and Queries.
It will also review more complex Queries and cover the Formatting of Reports including the incorporation of calculations.
|
|
Read more: Microsoft Access Intermediate
COURSE AIMS |
This one-day course is designed for experienced users of Access who wish to develop their knowledge in order exploit the advanced functionality of Access in order to build more complex databases.
It will cover using Switchboards to allow users easy access to reports or data entry; cover using expressions to total reports as well as exploring different join types between relational tables.
The courses is highly interactive to provide practical as well as a theoretical understanding of the advanced functionality of Access.
|
|
Read more: Microsoft Access Advanced