Can't find what your looking for?

Call us on +44 (0)1273 622272 or contact us.

Courses

showing {{courseLimit}} of {{(courses | filter:query).length}} results Show All

Hide All

Categories

showing {{courseLimit}} of {{(tags | filter:query).length}} results Show All

Hide All

Beginners Access Training

Great trainer, patient & open to all questions. I never felt out of my depth.

See More Reviews

Make an enquiry Download Course Outline

To discuss this, or any other course, please contacts us at +44 (0)1273 622272 or use the form below.

{{response}}

Most businesses have a lot of data, from customer details and employee records to product specifications data and invoicing and scheduling systems.

Beginners Microsoft Access Training

By learning the basics of Microsoft Access from Microsoft Office, you can get to grips with how to store that data effectively in ways that make it easy to update, query and report on it for a range of outputs.

This is an intensive Access training course, introducing delegates to the concepts of creating relational databases using MS Access.

Microsoft Access is a very powerful database application designed to save you time and make creating relational databases easier.

This Beginners Access Training Course will give attendees the skills needed to go on our advanced Microsoft access training course.

We also provide in-company Microsoft Access courses. Call +44 (0)1273 622272 to discuss your requirements.


Course Objectives

By the end of the Beginners Microsoft Access training course, delegates will be able to:

  • Create a simple relational databases using Access
  • Design & use Access queries, forms and reports
  • Understand how relational databases work and how queries, forms and reports improve productivity

Course Feedback

Clear and graduated learning with easy steps by progression

Great course - this morning I didn't know where to start - now I have the confidence to get going.

I felt that the course was very well structured & delivered. A very open, relaxed environment.

Excellent course giving me the fundamental knowledge of the database needed for my role.

Beginners Access Training Course Content

Introduction to Microsoft Access

  • What is a relational Database
  • What are Access Objects
  • Database design concepts
  • Relationships between tables

Working with an Access Table

  • What are fields and records
  • How to navigate through records
  • How to enter, edit and delete records
  • How to format tables
  • Filtering data in tables

Designing Access Tables

  • Using design view
  • Adding and naming fields
  • Assigning Field types
  • Assigning Field Properties
  • Creating Key Fields
  • Creating relationships

Designing Access Queries

  • Using And and Or statements
  • Parameter Queries
  • Autolookup Queries

Designing Access forms

  • What are forms
  • Designing a Form using the Wizard
  • Formatting forms
  • Working with Combo Boxes

Access Report Design

  • Creating a report using the Wizard
  • Formatting Reports

Book/Buy Now

Book/Buy Now

Course Details

Course Title
Beginners Access Training
Duration
1 day
Price
£795.00 + VAT

Upcoming Dates

  1. Aberdeen, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  2. Belfast, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  3. Birmingham, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  4. Bournemouth, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  5. Brighton, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  6. Bristol, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  7. Cambridge, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  8. Cardiff, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  9. Dublin, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  10. Edinburgh, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  11. Glasgow, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  12. Leeds, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  13. Liverpool, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  14. London, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  15. Manchester, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  16. Milton Keynes, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  17. Newcastle, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  18. Norwich, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  19. Nottingham, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  20. Reading, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 6 Oct 2017
    4. 3 Nov 2017
    5. 1 Dec 2017 Less Dates
  21. Sheffield, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates
  22. Southampton, UK
    1. 1 Sep 2017 More Dates
    2. 6 Oct 2017
    3. 3 Nov 2017
    4. 1 Dec 2017 Less Dates

Onsite Training

This course can be run in-company anywhere in the world & we can tailor the content to focus on your requirements.

We regularly provide training in London, Manchester, Bristol and all over the United Kingdom.

Who is this course for?

This course is for anybody who needs to use Access databases on a daily basis but has no previous experience.

BookingRequest a Quote

* Required

For in-company or private training please request a quote

We provide this training on a private or in-company basis only.
Please request a quote using the form below.


One of our training team will be in contact shortly to provide a quote and answer any questions.

Office hours are Monday-Friday 8.30am-5.30pm.

{{message}}

This course is delivered online as a flexible eLearning solution which you complete at a time and pace to suit you.

 

 
There are no scheduled dates for this course.

Total price (excluding any discounts and offers)
£{{ (cartItem.course_cost * cartItem.delegates) | noNeg | number:2 }} ex VAT
£{{ ((cartItem.course_cost * cartItem.delegates)*1.2) | noNeg | number:2 }} Inc VAT

Success

{{cartItem.course_title}} for {{cartItem.delegates}} delegatedelegates has been added to your basket.

Would you like to checkout now or continue browsing?