 |
MS Access Training |
|
| |
MS Excel Training |
|
 |
MS Word Training |
|
 |
MS PowerPoint Training |
|
 |
MS Project Training |
|
 |
MS Visio Training |
|
 |
MS Outlook Training |
|
 |
|
| |
|
|
|
 |
 |
Microsoft Access Training Courses in London and the UK
Microsoft Training Courses (MTC) can provide training in Microsoft Access for all versions and levels, from Access Beginners or Introduction to Advanced Access and Macros. This includes Microsoft Office Access 2007. Our MS Access training courses are designed to ensure you gain the most from your training course by making use of MOS Master instructors, excellent training course notes and Access Training Manuals.
We also believe we offer the best value for money on our Access Course. That doesn't mean you don't get quality training. Our existing clients are more than happy provide references if required.
Training takes place on a date that suits you and your colleagues. All Access and MS Office training courses are closed to you, which means you get exactly what you paid for, instead of course hi-jacking by other delegates from another company or institution.
If you would like more information on our MS Access Training Courses, please contact us
|
 |
MS Access Training Courses Information |
Training starts at 09:30 and lasts until 16:30 - 17:00. You will receive a Training Manual CD, course exercises and after course support all included in the cost. We offer fantastic refreshment throughout the day, like hot drinks, snacks and a selection of bottled water and soft drinks
Our Introduction course runs for 2 consecutive days.
All other levels are 1 day training courses. |
 |
| Select the Contact Me Now!!! button below to have a member of our team contact you regarding this course, or contact us |
|
| |
|
| |
| |
MS Access Training Course Levels and Contents
|
- Introduction
- Advanced
- Macros
Access Introduction Training Course Contents |
| Course Objectives -To understand the concept and purpose of a database and to gain a good working knowledge of Access to be able to create and edit Access databases. |
Screen Layout |
- Navigating Microsoft Access
|
|
Access Overview |
- Database Container
- Tables
- Queries
- Forms
- Reports
- Macros
- Pages
- Modules
- Grouping Favourites
|
| |
Planning a Database |
- Designing a Database
- Normalisation
- Relational Databases
|
| |
Creating Tables |
- Create a Database
- Designing a Table
- Rules for entering Field Names
- Enter data types, field descriptions
- Setting a Primary Key
- Setting Multiple Primary Keys
- Removing a Primary Key
|
| |
Table Properties and Structure |
- Defining Field Properties
- Working with Input masks
- The Input Mask Wizard
- Validation Rule
- Validation text
- Other field Properties
- Insert fields
- Delete fields
- Move Fields
- Rename Fields
- Table Wizards
|
| |
Entering and Editing Data |
- Switching Views in Access
- Enter data into a table
- Modify data in a table
- Working in Data Entry Mode
- Sorting Data
- Finding & Replacing Data
- Hiding and Unhiding Fields
|
| |
Importing and linking data |
- Importing from Access and Excel
- Linking to an external Access Database Table
- Linking to an Excel Workbook using the Wizard
- Renaming and Copying Tables
|
| |
| Using Filters and Select Queries |
- Create a filter by selection
- Create a filter by form
- Save a filter by form as a select query
- Running a Select Query
- The Query Design Window
- Creating a query from the query window
- Adding fields to a query
- Display/Suppress the display of a field
- Removing fields from a query
- Specifying Text, numeric, date, and logic criteria
- Specifying sub string searches using wild Card Characters
|
|
 |
- Working with multiple criteria
- Working with Conditions - BETWEEN, AND, OR, NOT, NULL
- Calculated fields
- Simple Query Wizard
- Removing fields from a query
- Specifying Text, numeric, date, and logic criteria
- Specifying sub string searches using wild Card Characters
- Working with multiple criteria
- Working with Conditions - BETWEEN, AND, OR, NOT, NULL
- Calculated fields
- Simple Query Wizard
|
Relationships |
- Why create relationships between tables?
- Different types of relationships
- Conditions for setting up a relationship
- Referential Integrity
- Cascade Update
- Cascade Delete
- Relationships Report
- Inserting Subdatasheets
- Removing Subdatasheets
- Expanding and Contracting Subdatasheets
|
| |
Multi-Table Queries |
- Multiple Table Queries
- Joining Tables for a query
- Join Properties - Inner and Outer Joins
- Find Unmatched Query Wizard
- Find Duplicates Query Wizard
|
| |
Creating Forms |
- Creating Forms using the Auto Form Tabular/Datasheet/Pivot Form wizard
- Creating Forms Using the Form Wizard
- Data Entry in Forms
- Resizing and Moving Controls
- Changing Text Attributes
|
| |
Form Layout and Formatting |
- Resizing Forms
- The Field List Box
- Selecting Controls
- Formatting Controls
- Format Painter and AutoFormat
- Resizing and Moving Controls
- Properties of an item
|
| |
Creating Reports |
- Standard Reports using Wizard
- Inserting, Moving, Sizing, deleting controls
- Customising Reports
- Grouping Data
- Using Expressions
- Mailing Labels
- Page setup
|
|
Access Advanced Training Course Contents |
| Course Objectives -
To build on previous knowledge and explore advanced functionality within Access, giving delegates a greater understanding of advanced queries, forms and reports to retrieve the information required. |
Relationships |
- Why create relationships between tables?
- Different types of relationships
- Conditions for setting up a relationship
- Referential Integrity
- Cascade Update
- Cascade Delete
|
| |
More on Queries |
- Calculated fields
- Parameter Queries
- Summary Queries
- Crosstab Query Wizard
- Editing a Crosstab Query manually
- Top Values Query
|
| |
| Action Queries |
- Make Table
- Append Query
- Delete Query
- Update Query
|
| |
| Advanced Forms |
- Composite Forms including Main Form and sub forms
- Displaying Yes/No values
- Option groups
- Command buttons
- Setting form properties
|
| |
|
 |
| Advanced Forms Continues |
- Calculations within Forms
- Combining Text Values
- Changing the data source
- Keyboard Short Cuts for Fields
- Tab Order
- Adding and Removing Filters(Selection and Forms)
- Defining Validation Rules
- Template Forms
|
| |
Advanced Reports |
- Using Expressions
- Adding Sub Reports
- Parameter reports
- Rreport Templates
- The Keep Together property
- Group on and group
- nterval properties
- Advanced Grouping techniques
- Page setup
|
| |
Charts |
- Formatting a chart
- Changing the type of chart
- Parameter chart Charting based on individual record
|
|
Access Macros Training Course Contents |
| Course Objectives -
Use Microsoft Access to Automate and simplify navigation. |
What is a Macro |
What are Macro Actions |
| |
Macros |
- Creating Macros
- Running Macros
|
| |
| Using the Names Macro |
| Auto Keys |
- Using ^ + letter
- Using ^ + Number
- Function keys
|
| |
| Conditional Macros |
| Exploring macro Actions |
- Msgbox
- Set value
- Using functions
|
| |
Event Procedures |
- On open/close
- On got/lost focus
|
|
 |
Creating A switchboard |
- Designing a switchboard
- Using Macros associated with Command Buttons
- Using Macros associated with Code
- Formatting switchboard forms
- Creating a Splash Screen
- Using autoexec
- Custom toolbar
- Custom menu
- Start-up Menu
|
| |
VBA |
- Sample subroutine
- Sample function
|
|
|
|
|
 |
|
 |
 |
| Course Costs |
| 1 to 1 Training |
1 to 1 training is charged at £450 per day. This means you will have the best training possible and only focus on topics you will use and actually benifit from. Read more about the benifits of 1 to 1 training here
All our courses are closed to you. |
| |
| Groups of 2-8 |
If you need to have more than 1 person trained, then our group pricing cannot be beaten.
For 2 Delegates = £475 per day. That's less than £200 per day per delegate
For 3 Delegates = £495 per day. Thats less than £170 per day per delegate
For 4 Delegates = £695 per day. Thats less than £150 per day per delegate
For 5 to 8 delegates = £695 per day. That could be as little as £90 per day per delegate.
All prices are excluding VAT |
| |
All our courses are closed to you and your company. |
 |
| How to book |
Simply call us on 020 7920 9502
or
Email Us
or
use our Contact Us form
We will then confirm the course and dates with you and send joining instructions
Thats it.
Remember that you do not pay until your course has run. This ensures that you are 100% satisfied with your course. If not, we run it free or you simply do not pay.
|
 |
 |
|
|