Microsoft Access Workshops | Rugby
Microsoft Excel Workshop Rugby
 
Course Price: £145.00 Exc VAT
Support: Focus4 Training | Lumonics House, Valley Drive, Swift Valley Industrial Estate, Rugby, CV21 1TQ
Course Length: 1 Day
Contact Call us on (01455) 550622 or email info@focus4training.com


Choose a Date:


Level:


Select Version:


 
The standard Access course outlines are below. If you wish to book one of the dates above today you can either choose one of these levels or choose the option for us to send you a link to our Training Needs Assessment. You have the opportunity to choose any topics you particularly wish to study or practice. The online assessments are straight forward and take minutes to complete. Once your date is booked we will send you a custom course outline for you to approve. We will work with you until you or your delegates are happy with the content. If you wish to book multiple delegates on different dates or you have any questions please contact us using the details below.

Access Essential Skills
Access Interface
Database Terminology
Database Structure
Creating a Database
Understanding Key Fields
Creating Key Fields
Adding Records
Amending Records
Editing an Existing Database Table Changing Table Field Names
Creating a Form
Creating a Report
Working with Queries
Access Intermediate
Templates
Building a Table
Field Properties/Input masks
Importing Data
Customising Forms
Using Subforms
Amending Forms
Creating Relationships
Form Properties
Adding Combo Boxes
Controls
Tab Order
Using the Switchboard

Access Advanced
Entering Expressions
Calculated Controls
Calculations in Queries
Changing the Field Properties
Using Aggregate Functions
Calculated Fields/Parameter Queries
Using Numbers and Expressions
Using an Aggregate Function
Defining the Parameter Data Type
Using Wildcards/Using Parameters Changing the Order of Parameters Crosstab Queries/Referential Integrity Setting Up Two Row Criteria
Append and Delete Queries
Removing Duplicate Records
Course Location
Focus4 Training | Lumonics House, Valley Drive, Swift Valley, Rugby, Warwickshire

Our modern training rooms and comfortable rest areas provide a welcoming and relaxed learning environment. On arrival please proceed to the top floor where you will meet with your trainer and other course delegates over tea or coffee. A light lunch is provided with refreshments available throughout the day. Laptops are provided for the day and you receive full course notes to take away.

Course Schedule
Arrival: 9.15 am
Start: 9.25 am
Break: 11.30 am
Lunch: 1.15 pm
Finish: 4.00 pm