Microsoft Access Introduction 1

  • Select Location
Select a location then date
No dates available
Price (exc vat): £250
PrintDURATION: 1 day
TIME: 09:30 to 16:30 GMT

This course is only available for a group of delegates (4+). Please contact us for further details.

Delegates learn the key elements of a Microsoft Access database and also how it has advantages over Microsoft Excel.

About Microsoft Access Introduction 1

Microsoft Access Database

Microsoft Access training courses Southampton, Hampshire, Whiteley

Microsoft Access is a desktop application that can be configured to meet most business needs. It has many benefits over Excel functionality but needs to configured correctly to get the best results. The course will cover the basic operations of an Access database program and the advantages of using a relational database over and Excel spreadsheet. The course is informal but structured, and you will be encouraged to ask questions throughout.

Is this course for you?

You want to learn the basic functionality of an Access database including creating and editing new tables, relationships, forms, queries and reports and inputting and editing data. The course will provide a thorough understanding of detailed elements plus best practice techniques.

A typical Access course

There are usually between 3 and 6 delegates on the course, all from different companies. Some delegates have used Access before but have had no formal training. Others have not used Access but want to understand the differences, advantages and disadvantages between Access and Excel. We’ll have a 15 minute break in the morning and afternoon and approximately 45 minutes for lunch. Database(s) created on the course will be sent to you on completion for your reference.

Course Includes

  • Lunch and Refreshments – Lunch at Caffe Dallucci (Whiteley only)
  • Microsoft Training Manual
  • Post course training downloads
  • Certificate on completion
  • Post course support relating to course content

More information

Microsoft Word and Excel discounted courses

Microsoft Access resources

Microsoft Access shortcuts

Aim & Objectives

Course Aim

  • To create and edit a simple Microsoft Access database.

Course Objectives

By the end of this level you will be able to:
  •  Examine the Microsoft Access database application
  •  Manage data in an Access database
  •  Create and edit tables and relationships
  •  Create various types of Query to interrogate data
  •  Design forms for different uses
  •  Create and modify reports and link them to Queries

Course Content

Access Database (Get to know Access)

Understand Relational Databases – Examine the Access Environment – Open the Database Environment – Examine Access Tables

Data (Input and edit data using Forms)

Examine an Access Form – Add and Delete Records – Sort Records – Display Recordsets – Update Records – Run a Report

Table Relationships (Critical to your database)

Identify Table Relationships – Identify Primary and Foreign Keys in the Relationships Window – Work with Subdatasheets

Queries (Interrogate your data with questions)

Create a Select Query – Add Criteria to a Query – Add a Calculated Field to a Query – Perform a Calculation on a Record Grouping

Forms (Input and view your data)

Examine Form Design Guidelines – Create a Form using AutoForm – Create a Form using the Form Wizard – Modify the Design of a Form

Reports (Output from your Query)

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

Video Testimonials

Your trainer has almost 20 years experience providing training and consultancy of Microsoft Access databases.

Client Testimonials

  • Name: 200 + delegatesCompany: Via

    View all testimonials

  • Name: Scott SellarsCompany: More on

    APM Project Management Qualification (PMQ) course review

    I completed the PMQ course through IPSO FACTO and they were a pleasure to work with from the moment I first made an enquiry. Every piece of course administration was made simple for me and the classroom facilities were just perfect. The course instructor was professional, knew the subject very well and focused our learning in a practical way to help put it into perspective. Overall, a very professional experience and I would recommend IPSO FACTO as a quality training company. Thank you. [Scott Sellars]

    Link to more reviews: ipsofacto live reviews

    View all testimonials

  • Name: Simon M.Company: Career Change

    PRINCE2 Foundation and Practitioner course review

    I attended the project management qualification in December (having already attended the PRINCE2 course in November). Although a challenging subject, I found that the training was engaging because there was adequate time to not only listen but to also give examples and hear examples from other individuals from the class. This aids to help people’s understanding or misunderstanding in some cases and help breakdown the subject into easier chunks. It also helps that IPSO FACTO have in my opinion some of the most experienced instructors in the country, meaning that if you just don’t get something they bring their personal experience into the story to help your understanding. Simon M.

    Link to more reviews: ipsofacto live reviews

    View all testimonials

  • Name: Chelsea B.Company: More on

    APM PFQ (Introductory Certificate) course review

    The PFQ (APM IC) was for me a good introduction into understanding the ‘Project Management’ world better. It helped me to identify areas and processes that I am not yet familiar with but I now have more confidence in tackling. Passing this course has further confirmed that I do want to go on to study for the APMP qualification. Chelsea B.

    Link to more reviews: ipsofacto live reviews

    View all testimonials