Microsoft
Access
Introduction
Looking for Access 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: Wednesday 2 July 2008
Venue: Sun House, 23 Queen Edith's Way, Cambridge CB1 7PH
Start Time: 9.30pm
End Time: 4.30pm
Price: £197 (+VAT)
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 a Microsoft Office Specialist (MOS) approved seminar handout with a CD 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 v2003. However, if you use an earlier version of Access this course will still be appropriate, as the versions are very similar.
|
||
|
||
|
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.
|
||
|
||
|
Course outline:
Getting Started
- what is Access, starting Access, the Access application window
- working with Access menus, 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
Creating a form/modifying and manipulating data
- reopening a database/reopening a table
- creating a form
- navigating through records in form view/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
- creating and applying a filter
- 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
- using the spelling checker
- copying, renaming and deleting database objects
- importing spreadsheet data into an Access table
Final case study
Home
Courses
Word
Excel
PowerPoint
Access
Outlook
Windows
Disclaimer