Microsoft
Access 2007
Introduction
Looking for Access 2007 training in a friendly, non-threatening atmosphere?
Then come along to our full day Microsoft Access introduction course. Small class size for greater attention.
Date: Thursday 5 August 2010
Venue: Sun House, 23 Queen Edith's Way, Cambridge CB1 7PH
Start Time: 9.30pm
End Time: 4.30pm
Price: £197 (+VAT)
How to book:
- Email karen@roem.co.uk OR
- Call Karen on 01223 214177
Unless otherwise agreed to, payment is due before the training event. Roem Limited reserves the right to refuse entry to any attendee should payment not have been received.
The price includes buffet lunch and refreshments, a Microsoft Office Specialist (MOS) approved seminar handout with your own USB stick packed with exercise files for you to work through and take away, as well as one month post course advice.
The maximum class size is four, providing computer training in a friendly, non-threatening atmosphere. You will be led through each topic and there will be plenty of opportunity for hands-on exercises, questions and individual support. The practical work will be done on laptops using Access v2007.
|
||
|
||
|
The entire day was a pleasure! The venue is so unique and lovely; the atmosphere very
relaxed and informal; the post course material incredibly useful; the trainer is personable, helpful and friendly.
I cannot recommend the course and trainer enough! Environment and trainer-very relaxed; made me feel at ease throughout the day.
The Access course was very useful and pitched at just the right level.
Karen provided everything you could possibly need in a superb relaxed environment.
I would highly recommend this course to anyone who is looking to use or is using Access 2007. Good and very enjoyble - a hugely useful course and I look forward to
putting what I learnt into practice.
This is the best course I have attended. Small groups is by far the best way to learn. The handbooks are excellent. |
||
|
Course outline:
Getting Started
- what is Access, starting Access, the Access application window
- using the Access menu system, using the Microsoft Office button
- using the quick access toolbar, basic Access terminology
- examining Access objects
- resetting the database folder, displaying help information
- exiting from Access
Setting up a new database
- designing and creating a new database, creating a new table
- entering records in datasheet view
- printing the datasheet of a table
- navigating through records in datasheet view
- closing a table/closing a database file
Creating a form/modifying and manipulating data
- reopening a database file/reopening a table
- creating a form
- navigating through records in form window/closing a form
- reopening a form
- switching between form view and datasheet view
- entering records in form view
- editing records in datasheet view and form view
- using the find feature
- deleting records in datasheet view and form view
- modifying the datasheet view of a table
- sorting the records in a table
Displaying selected records
- filtering the records in a table
- creating and running a query, modifying a query
- including a numeric condition in a query
- including a calculated field in a query
Creating a report
- creating a simple tabular report
- creating a grouped tabular report, modifying a report
Additional Access features
- copying, renaming and deleting database objects
- compacting and repairing a database, backing up a database
- importing spreadsheet data into an Access table
- importing text into an Access table
Final case study
Home
Training
Support
Clients
Contact Details
What's New
Disclaimer