Introduction to Microsoft Access

Course content

* Introduction to Database Concepts and Terminology
* Starting Access
* Access Databases
* Creating New Databases
* Creating an Object
* Creating a Table
* Changing Tables
* Entering Data in Datasheet View
* Copy, Move, Delete
* Changing the Datasheet’s Layout
* Designing Forms
* Types of Form
* Changing Forms using the Forms Design Work Surface
* Editing the Tab order
* Calculations within Forms
* Creating Forms from Scratch
* Multiple Screen Forms
* Filter/Sort Records
* Queries & Dynasets
* Sorting Data
* Calculations in Queries
* Grouping and Summarising Data
* Producing Cross Tabulated Results
* Customising Queries with Parameters
* Using Filters
* Queries to Link Data from Different Tables
* Queries with Calculated Fields
* Queries to Summarise Data
* Queries with Parameters
* Action Queries
* Action (Update) Query
* Action (Make table) Query
* Action (Delete) Queries
* Action (Append) Query
* Printed reports
* Using the Report Wizard
* Report Design Mode
* Calculated and Statistical Fields
* Including Graphs in Reports
* Organizing Reports
* Label Generation

More Depth, Less Spread - IT End-User & Technical Training courses that concentrate on the delegate, not on the trainer

Whilst larger class sizes are often more commercially viable, all training must have a valued benefit to the client.

At Adapt, we limit IT courses to a maximum group size of 6 and ensure that every delegate has their own individual PC (and sometimes 2 for technical training). The benefits of our approach are:

* More depth, less spread – delegates can ask questions on specific application skills making it easier when returning to the workplace to apply what they’ve learnt
* Less intimation – People in smaller groups often feel less intimidated to ask questions and discuss their work challenges (and solutions!) with each other
* Exercises and examples can be tailored ‘on-the-spot’ to meet all the delegates backgrounds maintaining interest and focus for all

Our guarantee of immediate business impact is backed by the reassurance of our Microsoft Certified Partner status which confirms that our skills, knowledge and application have been externally verified and accredited.

FREE 6 Month IT Support Package

The FREE 6-month helpline gives delegates the added peace of mind that if they have forgotten something, they can get support and assistance as many times as they like for 6 months after course attendance.

Timed and Adapted - to suit you

Traditionally training companies schedule courses to suit themselves, here our attitude is somewhat different. Subject to availability you can use any of the following options.

* 1-2-1 Coaching
* IT Floor-Walking
* Attendance on an Open course
* Closed Company Course
* Training at your site/venue

Open course guarantee

We guarantee that once we have your confirmed booking, the course will not be cancelled due to lack of numbers.