Microsoft Access Training
Excel is one of the most widely used software packages currently in use. The package can be used for a variety of tasks. On a basic level, you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction.
For more demanding uses, Excel can be used to create charts, automate spreadsheets, apply advanced formulas, create Pivot tables and much much more!
Please select the version that you’re interested in
Please select the version that you’re interested in
Microsoft Access 2016 Intermediate
Course Overview
- Using Advanced Table features
- Create Action Queries
- Create Advanced Forms
- Create Advanced Reports
- Understand and Create a Switchboard
Audience:
This course is designed for existing Microsoft Access users with sound basic database skills. The course will focus more on advanced features of Tables, Queries, Forms and Reports.Prerequisite:
You must have sound Access skills and understand key concepts of a database, equivalent to our Access Introduction course contents.Duration:
This is a 1 day MS Access Intermediate course. The course starts at 09:30 and runs until 16:30. Alternate timings can be arranged upon request. The course can be held on a date that suits you.Location:
Our Microsoft Access Intermediate course be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.Access 2016 Intermediate Course Outline
ADVANCED TABLESInput mask Applying validation Validation text Calculating a field Multiple primary keys Lookup fields Formatting a field Link to external data source Recap and More on Relationships Why create relationships between tables? Different types of relationships Adding tables to the relationship window Creating, editing and deleting relationships Conditions for setting up a relationship Understanding Referential Integrity Using the Cascade Update option Using the Cascade Delete option Saving relationshipsADVANCED & ACTION QUERIESCreating Calculated fields Creating Parameter Queries Creating Summary Queries Creating a Crosstab Query Editing a Crosstab Query Use the Top Values option in a Query Create and use a Make Table Query Create and use an Append Query Create and use a Delete Query Create and use an Update QueryADVANCED FORMSMain Form and sub forms Exploring Layout View Split forms Using Checkboxes & toggle buttons Using combo boxes Adding Option group controls Adding Command button Controls Setting more form properties |
Calculation in a Form
Concatenating Text Values
Changing the data source options
Setting the Tab Order
Adding and Removing Filters (Selection and Forms)
Defining Validation Rules
Using advanced controls
Template Forms
ADVANCED REPORTSCustomise your Report Format the controls Using Expressions Adding Sub Reports Parameter reports Report Templates The Keep Together property Mailing Labels Grouping interval properties Group Headers/footers calculations Page setup Page breaksIMPORTING & LINKING DATAImporting from Access and Excel Linking to an external Access Database Table Linking to an Excel Workbook Renaming and Copying Tables Linked table manager Export to various formatsCHARTS AND PIVOTSCreate a PivotChart / PivotTable Edit Pivot Table options Formatting a chart Changing the chart type Parameter chart Chart based on single record |
One to One
(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training
Group for up to 8 learners
What Our Clients Say
Extras
This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.