Book your Access 2003 Level 1 Training Course

This one day course is being run 23 times between Tuesday 14th February 2012 and Monday 3rd September 2012 in Reading, Manchester, Birmingham, London, Milton Keynes, Bristol, Glasgow, Leeds, Edinburgh,

Book this course with us today from as little as £220.50 + 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.

See all courses provided by QA

Expert Help

If you would like
advice, or to book, call
one of our experts on
01920 460232

Open: 9am - 5:30pm
Monday- Friday

Locations/dates for this course
DateLocationRatingPrice
Tuesday 14 February 2012ReadingSave £24.50£220.50+VAT
Friday 02 March 2012ManchesterSave £24.50£220.50+VAT
Friday 02 March 2012BirminghamSave £24.50£220.50+VAT
Monday 05 March 2012LondonSave £24.50£220.50+VAT
Monday 02 April 2012LondonSave £24.50£220.50+VAT
Monday 02 April 2012Milton KeynesSave £24.50£220.50+VAT
Wednesday 04 April 2012BristolSave £24.50£220.50+VAT
Monday 23 April 2012GlasgowSave £24.50£220.50+VAT
Tuesday 01 May 2012LondonSave £24.50£220.50+VAT
Friday 04 May 2012BirminghamSave £24.50£220.50+VAT
Friday 11 May 2012LeedsSave £24.50£220.50+VAT
Friday 01 June 2012ManchesterSave £24.50£220.50+VAT
Monday 11 June 2012LondonSave £24.50£220.50+VAT
Monday 02 July 2012LondonSave £24.50£220.50+VAT
Tuesday 03 July 2012ManchesterSave £24.50£220.50+VAT
Thursday 05 July 2012BirminghamSave £24.50£220.50+VAT
Friday 06 July 2012LondonSave £24.50£220.50+VAT
Friday 03 August 2012LeedsSave £24.50£220.50+VAT
Friday 03 August 2012LondonSave £24.50£220.50+VAT
Monday 06 August 2012EdinburghSave £24.50£220.50+VAT
Monday 06 August 2012Milton KeynesSave £24.50£220.50+VAT
Monday 13 August 2012BristolSave £24.50£220.50+VAT
Monday 03 September 2012GlasgowSave £24.50£220.50+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!
Download Course Outline

Summary: 

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management, computer based applications, is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools.

PreRequisites: 

To ensure the successful completion of Microsoft Access 2003: Level , we recommend completion of one of the following or equivalent knowledge from another source:

  • Windows 2000: Introduction
  • Windows XP: Introduction
  • Windows XP: Level 1
  • Windows XP: Level 2
Audience: 

This course is designed for students who wish to learn the basic operations of the Microsoft Access Database program to perform their day to day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes.

Objectives: 

Upon successful completion of this course, students will be able to:

  • Examine the Microsoft® Office Access 2003 database application.
  • Manage the data in a database.
  • Examine existing table relationships.
  • Query the database.
  • Design simple forms.
  • Create and modify Access reports.

An Overview of Access 2003

  • Relational Databases
  • Access Environment
  • The Database Environment
  • Examine an Access Table

Establishing Table Relationships

  • Identify Table Relationships
  • Identify Primary and Foreign Keys in the Relationships Window
  • Working with Subdatasheets

Querying the Database

  • The Select Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform a Calculation on a Record Grouping

Managing Data

  • Examine an Access Form
  • Add and Delete Records
  • Sort Records
  • Display Record Sets
  • Update Records
  • Run a Report

Designing Forms

  • Form Design Guidelines
  • Create AutoForms
  • Create a Form Using the Form Wizard
  • Modify the Design of a Form

Producing Reports

  • Create an AutoReport
  • Create a Report by Using the Wizard
  • Examine a Report in Design View
  • Add a Calculated Field to a Repor
  • Modify the Format Properties of a Control
  • AutoFormat a Report
  • Adjust the Width of a Report

Description: 

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management, computer based applications, is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools.

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.

Want to leave your own testimonial? click Here
No Testimonials have been left for this course.