Book your Access 2003 Level 3 Training Course
This two day course is being run six times between Monday 2nd July 2012 and Tuesday 4th December 2012 in London, Manchester,
Book this course with us today from as little as £531.00 + VAT and with our price guarantee you can be confident of getting great value. Our team of experienced independent booking administrators will make the joining process painless and by providing feedback on your experiences you’ll also influence the Coursebookers independent course ratings.
Expert Help
If you would like
advice, or to book, call
one of our experts on
Open: 9am - 5:30pm
Monday- Friday
Locations/dates for this course
| Date | Provider | Location | Rating | Price | ||
|---|---|---|---|---|---|---|
| Monday 02 July 2012 | QA | London |  | Save £59.00 | £531.00+VAT | |
| Thursday 02 August 2012 | QA | Manchester | | Save £59.00 | £531.00+VAT | |
| Thursday 20 September 2012 | QA | London | | Save £59.00 | £531.00+VAT | |
| Monday 22 October 2012 | QA | Manchester | | Save £59.00 | £531.00+VAT | |
| Wednesday 21 November 2012 | QA | London | | Save £59.00 | £531.00+VAT | |
| Tuesday 04 December 2012 | QA | Manchester | | Save £59.00 | £531.00+VAT |
|
|
Book your course now with Coursebookers!
Making an enquiry to Coursebookers couldn't be easier, just fill out the form to the left or call 01920 460232 and our team will be in touch within 48 hours.
Remember:
- Not only are we great value, we can also boast no booking fees
- Human administrators make booking & coordination simple and painless
- Coursebookers is vendor neutral we can offer unbiased and independent advice
- If you have complex booking requirements we're happy to help! Call our team on 01920 460232 to discuss your needs
- We ensure all our courses meet our high standards, meaning you'll only ever see "the best of the best" on Coursebookers!
Summary:
Your training in and use of Microsoft ® Office Access 2003 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft ® Office Access 2003. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities.
PreRequisites:
- Microsoft ® Office Access 2003: Level 1
- Microsoft ® Office Access 2003: Level 2
Audience:
This course is designed for the student who wishes to learn intermediate and advanced operations of the Microsoft ® Office Access 2003 database program.
Objectives:
Upon successful completion of this course, students will be able to:
- restructure an existing set of data to improve the design of a database.
- use a variety of techniques to summarize and present data with queries.
- create and revise basic Access macros.
- create macros that improve data entry efficiency and integrity.
- improve the effectiveness of data entry in forms.
- improve the effectiveness of data displayed in reports.
- maintain an Access database by using various utility tools.
Outline:
Structuring Existing Data
- Import Data
- Analyse Tables
- Create a Junction Table
- Improve Table Structure
Simplifying Tasks with Macros
- Create a Macro
- Attach a Macro to a Command Button
- Restrict Records Using a Where Condition
Adding Interaction and Automation with Macros
- Require Data Entry with a Macro
- Display a Message Box with a Macro
- Automate Data Entry
Making Forms More Effective
- Change the Display of Data Conditionally
- Display a Calendar on a Form
- Organize Information with Tab Pages
Writing Advanced Queries
- Create Unmatched and Duplicates Queries
- Group and Summarize Records Using the Criteria Field
- Summarize Data with a Crosstab Query
- Create a PivotTable and a PivotChart
- Display a Graphical Summary on a Form
Making Reports More Effective
- Cancel Printing of a Blank Report
- Include a Chart in a Report
- Arrange Data in Columns
- Create a Report Snapshot
Maintaining an Access Database
- Link Tables to External Data Sources
- Back Up a Database
- Compact and Repair a Database
- Protect a Database with a Password
- Determine Object Dependency
- Document a Database
- Analyse the Performance of a Database
Description:
Your training in and use of Microsoft ® Office Access 2003 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft ® Office Access 2003. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities.
QA
QA training has over 25 years of experience of supplying high standard training courses in many Business, Management and IT Technical areas. Since 1983 the company has grown to have 25 training centres across the UK offering businesses routes to advance on a local and national level.
QA have a dedicated team of permanent instructors and teaching consultants who constantly improve the courses to ensure the highest possible standard of training is available.