Microsoft Access Training starts with a simple single table database. Users will understand how each object works within Microsoft Access. The first session covers some of the core concepts followed by basic tables, queries, forms and reports. The second session involves using Access as a relational database and covers creating relationships, calculation in queries, linked forms and reports. The advanced session looks at macros to automate your database and more detailed reports. Users will learn how to customise a database and attach events to object properties.
Venue & Duration: Newcastle Training Room. 1 Day Duration. Free sandwich lunch is provided and parking is available.
Costs: Between £125 for a group book and £250 for a single delegate. Ask about One to One prices.
Objectives: Microsoft Access is a powerful database package – yet many people find it difficult to master. Whether you are a beginner looking to learn the basics or a regular user looking to develop your skills, our courses will equip you with the skills you need to master Access databases.
Benefits: We help users of Microsoft Access to learn and develop their skills with our range of Access Training courses. This helps people to be more productive at work and feel much more confident when using Access. We offer three courses: Beginners, Intermediate and Advanced; we can also customised training to suit your needs. We can help individuals who would like to attend an open course or we can provide bespoke training for a business or organisation. 1-2-1 and private tuition is also available. If you are unsure as to what level or format will suit your needs, simply contact us and we can find the best solution for you.
Suitable For: This course is suitable for all skill levels and will be made appropriate to attendees. We offer three levels: Introduction, Intermediate and Advanced. Check what level is best for you by using our Check Skill Level.
This is an example of the sort of topics that are covered on the Introduction to Microsoft Access course.
This is an example of the sort of topics that are covered on the Intermediate Microsoft Access course.
This is an example of the sort of topics that are covered on the advanced Microsoft Access course.
Access training courses listed below are a guide only, each course can be tailored if required, just ask.
Learn about the key Objects in Microsoft Access, such as Tables, Queries, Reports and Forms.
Learn about Data type and properties.
Learn how to create a Table using the wizard options and in design view.
Learn how to import data from other programs such as Microsoft Excel
Learn how to use Microsoft Access to mail Merge in to Word.
Learn how to create simple select Queries to filter records.
Learn how to create simple Forms and their relationship with Tables and Queries.
Learn how to Create Reports and how they work with Tables and Queries
Learn how to Sort and filter table records.
Learn how to set default properties and create Lookup lists and Tables
Learn how to create Table relationships in Microsoft Access, linking two tables together using a One to Many link
Learn how and when to use the Join Type feature.
Learn how to create Update, Delete, Make Table, Cross Tab and Duplicate Queries
Learn how to create and use Parameter Queries and how they work with Reports in Microsoft Access
Learn how to use the Pivot Tables and Pivot Chart features
Learn to create a Sub Form and Sub Report.
Learn how to use option groups and Tab controls in Forms.
Learn how to use Command buttons and the wizard to create a Main Menu Form.
Learn how to create an Automated Start Up in Microsoft Access.
Learn how to use the Totals feature in Queries and how to create calculations at Query level in Microsoft Access
Learn how to use the Expression Builder.
Learn how to create macros and attach them to command button and Form controls
Learn how to create calculations across multiple tables
Learn how to use the IIF and DataDiff functions in Microsoft Access
Learn to use Macros to run commands and export data.
Learn how to use the Where feature in Macros.
Learn how to use the AutoExec Macro.
Learn how to create calculations in Forms and Reports.
Learn how to use Conditional formatting in Forms.
Learn how to create and use a Switchboard in Microsoft Access, learn how to add photos to a form and create parameter forms