Advanced Microsoft Access 2013 Training Courses
Short course
In Twickenham
Description
-
Type
Short course
-
Location
Twickenham
-
Duration
1 Day
-
Start date
Different dates available
This course aims to give delegates an insight into some of the more advanced features in MS Access 2013.
Facilities
Location
Start date
Start date
About this course
On completion of the course delegates will have added to their skills in using Microsoft Access. They will be able to:
Use advanced forms features
Use Access in conjunction with the Internet
Create advanced queries
Produce reports
Record and assign macros
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 14 years
Subjects
- Access
- Microsoft Access
- Produce reports
- Assign macros
- Forms features
- Unmatched values
- NOT values
- Advanced Forms
- Split forms
- Macros
- Reports
Course programme
Creating and using a query to update data in a table
Creating and using a query to delete records in a table
Creating and using a query to save the selected information as a table
Appending records to a table using a query
Refining Queries
Showing duplicates
Showing unmatched values
Showing the highest or lowest range of values in a query
Parameter queries - allowing query input from a data prompt
Refining queries using Null and NOT values
Advanced Forms
Creating arithmetic and logical expression controls on a form
Setting sequential order of controls on a form
Creating a subform and linking it to parent
Modifying the subform to change records displayed
Split forms
Calculations in Reports
Creating arithmetic and logical expression controls in a report
Calculating percentages in a report
Using formulas and expressions in a report such as sum, count, average, max, min, concatenate
Creating running summaries in a report
Macros
Recording a simple macro
Running a macro
Assigning or attaching a macro to a form, report, control
Additional information
1 to 1 training £295
2 to 4 delegates £455
5 to 8 delegates £595
Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £595. All prices exclude VAT
Advanced Microsoft Access 2013 Training Courses