Book your Introduction To Microsoft Access Training Course

This two day course is being run three times between Monday 30th April 2012 and Monday 29th October 2012 in London,

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

See all courses provided by Reed

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
Monday 30 April 2012London£350.00+VAT
Monday 23 July 2012London£350.00+VAT
Monday 29 October 2012London£350.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!
Download Course Outline

Summary: 

This course aims to develop your skills and confidence in using MS Access, by starting you off with a solid grounding in the basic techniques.

Audience: 

Those new to Access and those who are self taught and would like to consolidate or check their understanding.

Objectives: 

You will acquire the confidence and ability to manage the establishment and maintenance of Access databases.

Unit1: Database concepts

  • Database concepts and terminology
  • Starting with Access
  • The Access environment
  • Planning and designing databases
  • Getting Help
  • Closing a database and exiting Access

Unit 2: Access basics

  • Exploring tables and forms
  • Exploring queries
  • Exploring reports

Unit 3: Creating databases

  • Creating a database
  • Using the Table Wizard
  • Working in Design view

Unit 4: Working with fields and records

  • Changing the design of a table
  • Adding and deleting records
  • Finding and editing records
  • Sorting and filtering records

Unit 5: Querying tables

  • Viewing specific fields
  • Modifying query results and queries
  • Calculations in queries

Unit 6: Creating and using forms

  • Creating forms by using AutoForm
  • Using Form Wizard
  • Using Design view

Unit 7: Creating and using reports

  • Using the Report Wizard
  • Using reports to perform calculations

Unit 8: Importing and exporting objects

  • Importing Access objects
  • Exporting Access objects

Unit 9: Creating Relational Databases

  • Analysing Table Relationships
  • Relating Tables
  • Testing Referential Integrity

Unit 10: Working with Related Tables

  • Using the Lookup Wizard
  • Modifying Lookup Fields
  • Adding Data to Related Tables

Unit 11: Defining Data Entry Rules

  • Working with Input Masks
  • Setting Required Properties
  • Setting Validation Rules
  • Setting Lookup Fields

Description: 

This course aims to develop your skills and confidence in using MS Access, by starting you off with a solid grounding in the basic techniques. You will acquire the confidence and ability to manage the establishment and maintenance of Access databases.

Reed

Reed Learning has offered high quality professional business and management training since 1995, offering 100,000 days of training annually across the UK. Reed Learning is committed to having the most passionate business and management course trainers in the UK and it is because of this they can offer training courses of an award winning standard.

Want to leave your own testimonial? click Here
- T.C.