| Available 24 Hours Monday - Friday | 01344208452
Please enter course

Got a quick question or comment?
Send us enquiry.

Enter your details and we will call you back to discuss your requirements

Microsoft Access Training | Microsoft Access Training Courses

  • Official Microsoft Access Training in luxury nationwide venues
  • GUARANTEED LOWEST PRICE IN THE INDUSTRY
  • Learn how to use and apply Access by your accredited Microsoft Partner
  • Courses delivered by highly experienced certified Access instructors
  • Competitive pricing and unrivalled choice of course dates
  • All delegates are provided with an official detailed user-friendly manual
  • Includes pre & post course email support
  • Enhance your productivity at work
  • Book Online or Call 01344 203999 to speak to a Learning advisor today
Schedule
Course Dates, Locations & Prices (Top) | View Course Info
Course Name Date Location Duration Price Book Online
Microsoft Access 2013 Intermediate 02/06/2017 Manchester
1 day £1299 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 London
1 day £1299 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Birmingham
1 day £1299 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Norwich
1 day £1499 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Glasgow
1 day £1499 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Bristol
1 day £1499 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Belfast
1 day £1499 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Milton Keynes
1 day £1499 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Newcastle
1 day £1499 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Liverpool
1 day £1499 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Dublin
1 day €1499 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Cardiff
1 day £1499 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Cambridge
1 day £1499 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Aberdeen
1 day £1499 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Nottingham
1 day £1499 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Reading
1 day £1499 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Leeds
1 day £1499 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Reading
1 day £1499 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Edinburgh
1 day £1499 Book now Enquire
Microsoft Access 2013 Intermediate 02/06/2017 Sheffield
1 day £1499 Book now Enquire

Course Information (Top) | View Dates & Pricing

Overview

Who Should Attend the Course? 

New, recent or intending users of Access 2003 or XP who have little or no existing database knowledge. Note : A basic understanding of PCs and familiarity with the layout of a PC style keyboard, mouse and Windows is required.

Course Outline   

Getting Started

Starting Out: • Basic Terminology • Opening Microsoft Access • Interface Overview • Closing Microsoft Access
Using the Access Interface: • UsingThe Access Menus • Access Task Panes • Using Toolbars • Adding, Removing, and Moving Toolbars • The Switchboard • Using the Database Window
Getting Help: • The Help Menu • The Help Task Pane • The Office Assistant • Using the Type a Question Box • Getting Help in a Dialog Box • Using the Sample Databases

Creating a Database

First Steps: • Planning a Database • Creating a Blank Database • Database Objects
Records: • What is a Record? • Adding Records • Editing Records • Deleting Records • Printing Records
Creating a Table: • About Tables • Creating a Table in Design View • Creating a Table using the Wizard • Entering Data into a Table • Formatting a Table
Formatting Text: • The Zoom Toolbar • Selecting Data • Cutting, Copying, and Pasting • The Format Painter • Undo and Redo • Checking your Spelling
Formatting Controls: • Changing the Colour of a Control • Control Properties • Aligning Controls • Applying Special Effects

Doing More with Your Database

Creating Forms: • What is a Form? • Bound vs. Unbound Controls • Creating a Form with the Wizard • Creating a Form in Design View • Using Forms
Creating Queries: • What is a Query? • Creating a Query with the Wizard • Using Design View to Modify a Query • Using Queries
Reports: • What is a Report? • Creating a Report with the Wizard • Creating a Report in Design View • Using Reports
Sorting and Filtering Data: • Using Find and Replace • Sort Ascending or Descending • Using Filter by Form • Using Filter by Selection • Creating a Filter

Viewing and Printing Your Data

Formatting a Datasheet: • Adjusting Row Height and Column Width • Rearranging Columns • Freezing a Row or Column • Hiding a Column • Changing the Datasheet Font
Viewing Data: • The View Menu • The Window Menu • Hiding and Unhiding Windows • Arranging Windows • Closing Individual Windows
Printing a Database Object: • The Print Icon • Print Preview • Page Setup 

FAQs
  • Course Availability

    The spaces remaining on all courses across the website reflect the availability of the maximum printed course materials and equipment available in stock for any given event. If the spaces remaining do not appear, then there is comfortably enough lead time to provision course materials and equipment upon booking.


  • What is Microsoft Access?

    Microsoft Access is a desktop database application, packaged with Microsoft Office Professional. Unlike Excel, Access is able to work with millions of records, allowing large databases to be created, updated, searched and reported on by multiple users. From simple data capture to complex automation and user interfaces, Access brings all the powerful functionality of a complete database, without the need for expensive servers and administration.


  • What time shall I arrive at the venue?

    Please arrive at the venue for 08:45am


  • Am I using Microsoft Access 2003?

    Click HELP menu, click ABOUT, find your version.


  • Am I using Microsoft Access 2007?

    Click Microsoft OFFICE button, click relevant OPTIONS button. Within OPTIONS click RESOURCES to find your version.


  • What level is best for me within Microsoft Access?

    INTRODUCTION - You can open files, save them, creating a database and printing your data. INTERMEDIATE - Fairly confident in customising and formatting tables, creating a query and working with reports. ADVANCED - Able to perform all tasks within ACCESS.


What's Included?
  • Highly Experienced Instructor
  • Detailed User-Friendly Manual
  • Pre/Post Course Email Support
  • Refreshments
  • Attendance Certificate

best-price      customer-charter

Why Choose us?
  • Certified and Approved

    We're accredited by leading training organisations including AXELOS, BCS, The Chartered Institute of IT, APMG, PMI, The Open Group and many more.


  • Best Price Guarantee

    As well as providing the best training in the industry, we'll also provide it at the best price. We'll beat any like for like quote from our competitors.


  • World's Largest Global Training Provider

    We offer training in the more locations than any other provider with over 1200 training locations globally.


  • Trusted by Industry Leading Brands

    We're proud of our range of high-profile clients including brands such as JP Morgan, HSBC, British Airways, BskyB, Sony, AT&T to name only a few


  • Hands-on, Expert Instructor-led Classroom Training

    All our trainers are hand-picked, highly experienced, subject matter experts, who can not only train you but also use real world and practical examples.


  • Dedicated 24/7 Support

    We are here to provide help and guidance before, during and after your training course to make sure you get the most from your training

Reviews
 Contact Us  More Courses

Send us your onsite requirements and we will
provide a tailor made course for you!

Happy Customers

Excellent- would be happy to recommend to anyone
520
Nice venue good facilities easy access. Trainers excellent and helpful. Exam moderators professional
This is a professional training company who has some of the most fantastic trainers. The trainer I had for my course was really experienced and used real life experienced in order to explain the methodology. This, I found extremely beneficial to my learning and essentially helped me pass my exam.
I really enjoyed my time with The Knowledge Academy and found that the trainer was excellent and extremely talented in her field. I found the company to be extremely experienced and value for money.
I recently took this training course and found it to be remarkable. The trainer was brilliant, as were the staff who navigated me to the training centre. The location of my course was gorgeous with a lovely view out of the window, and air conditioning. I really couldn't have asked for any more.
I recently took the Access course and thankfully passed! The course is intense but the trainer was great at keeping us all engaged. I have the fantastic trainer to thank for my exam result. This company is great at providing training courses.
Value for money and a trainer who knows his stuff. The Knowledge Academy are the company to go with for sure.
The trainer was brilliant, really experienced in his field. It was an honour to be taught by him. I would recommend this company.
Really interesting course, fantastic trainer, guaranteed to pass!
I have done Access courses before at colleges but they have nothing on this, this is what I want to know. thanks to the trainer and The Knowledge Academy.
Thanks to TKA for a great service. I will be updating to the latest version in the new year.
I've done database courses before but struggled to learn anything new - this was great thanks.
It is difficult to find fault, a very clear and informative course.
I have now completed my third course with The Knowledge Academy and all of your tutors have been first class. I plan to attend more in the near future.
Course was perfect; not too basic nor advanced.
It was challenging at times but very rewarding - I feel I have got a lot out of this course!
Good course.
Very good course, excellent trainer and booking was painless. Thanks TKA.
I enjoyed and learned a lot. Thank you for your services TKA!
A great service overall, concise and clear. It will be very helpful for the future!