Menu

    Call us on:
    020 8108 0298

Introductory Microsoft Access 2013 trainingIntroductory Microsoft Access 2013 Training Courses

If you’re looking for really great Introductory Microsoft Access 2013 training you’re in the right place.

Companies large and small choose us – why? Your own tailored, Microsoft Introductory Access 2013 training course, at your own premises at the same price as a standard course from elsewhere.

Learn the basics of Microsoft Access tables, forms, queries and reports. You will learn how to input data into an Access database using tables and forms. You will also learn how to get information back of a database with the use of queries and reports. You will learn about creating relationships between tables and the use of primary keys. You will learn how to search for information within an Access database and how to print out queries and reports.

The JMD Training difference is clear:

  • We come to you - your Introductory Microsoft Access 2013 training will be given on your site
  • You get to keep the manuals - Advanced Access training manuals are provided as PDFs
  • We can train using your own Microsoft Access databases
  • There will only be people from your company on your course
  • We offer a money-back guarantee if any delegates are not completely satisfied
  • The training date is around you, not us!
  • Our prices are astounding
  • We can assess all learners in advance for free
  • Our courses are never cancelled

Organisations which have benefitted from our Introductory Access 2013 training include:

Request Course Now »

Course TypeCost per day
1 to 1 training£295
2 to 4 delegates£455
5 to 8 delegates£595

Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £595. All prices exclude VAT

Our Microsoft Access training courses include:

If you are new to Office 2013, you may also be interested in our Office 2013 upgrade training, workshops and floorwalking

Visit our blog If Only I’d Known That,; we have called it that because we hear it so many times in training sessions. In fact, if only we had an extra £100 for every time someone says “If only I’d known that.” …. There are many useful hints and tips about using Microsoft Access on the blog; why not visit it to find out how many you knew!

Sue was really approachable and happy to answer questions/ queries etc.

Our Microsoft Access training courses London, are available not only in London, but Surrey, Middlesex, Richmond, Twickenham, Hounslow, Brentford, Banstead, Ascot, Putney, Wimbledon, Staines, Egham, Feltham, Reading, Croydon, Leatherhead, Farnham, High Wycombe, Crawley, Sutton, Woking, St Albans, Fulha , Watford – in fact anywhere within the Home Counties and M25 corridor. We have Microsoft Access trainers in Twickenham, Richmond, Ashstead, Central London, New Barnet, Ilford, Bushey, Crowthorne, and Basingstoke

Aims of the Introductory Access 2013 course

This course aims to introduce delegates with little or no understanding of the Microsoft Access 2013 software to the basic features of the package.

Course Objectives

On completion of the course delegates should understand and be able to accomplish basic operations associated with developing, formatting and using an MS Access database. They should also be able to create and use tables and forms, and be able to retrieve information from a database using queries and reports.

The course is of one day's duration.

How the course is run

This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.

Pre-requisites

Delegates attending the course should preferably have a basic understanding of the Windows environment and use of the keyboard and mouse.

MS Access Database Concepts

  • Understanding what a database is
  • Understanding how a database is organised in terms of tables, records, fields and with field data types, field properties
  • Understanding what a primary key is
  • Understanding what an index is
  • Understanding the purpose of relating tables in a database
  • Understanding the importance of setting rules to ensure relationships between tables are valid

First Steps with Access 2013 Databases

  • Opening and closing Access 2013
  • The Getting Started with Microsoft Access dialog box
  • Opening an existing Access database
  • Creating a new Access database
  • Viewing the Access 2013 window
  • The Navigation Pane
  • Saving a database to a location on a drive
  • Using available Help functions
  • Closing an Access 2013 database

Adjusting Settings

  • Changing between view modes in a table, form, report
  • Working with toolbars

Tables

  • Creating and saving a table and specifying fields with their data types
  • Table templates
  • Adding and deleting records in a table
  • Adding a field to an existing table
  • The Field List pane
  • Field Templates
  • Adding and modifying data in a record
  • Deleting data in a record
  • Using the undo command
  • Navigating within a table to next record, previous record, first record, last record, specific record
  • Deleting a table
  • Saving and closing a table
  • Defining a primary key
  • Indexing a field with and without duplicates
  • Changing field format attributes such as: field size, number format, date format
  • Understanding consequences of changing field size attributes in a table
  • Creating a simple validation rule for number, text, date/time, currency
  • Changing column widths in a table
  • Moving a column within a table

Table Relationships

  • Creating a one-to-one, one-to-many relationship between tables
  • Deleting relationships between tables
  • Applying rules to relationships such that fields that join tables are not deleted as long as links to another table exist

Forms

  • Opening a form
  • Creating and saving a form
  • Creating a form using the Form Wizard
  • Using a form to enter, modify and delete records
  • Navigating to next record, previous record, first record, last record, specific record using form display
  • Adding and modifying text in form headers and footers
  • Deleting a form
  • Saving and closing a form

Searching and filtering

  • Using the search command for a specific word, number, date in a field
  • Applying a filter to a table or form
  • Removing a filter from a table or form

Queries

  • Creating a saving a query using specific search criteria
  • Adding a criteria to a query using the operators <, <=, >, >=, = <>, AND, OR
  • Editing a query by adding or removing criteria
  • Editing a query by adding, removing, moving, hiding, unhiding fields
  • Running a query
  • Deleting a query
  • Saving and closing a query

Sorting records

  • Sorting data in a table, form or query output in ascending, descending, numeric and alphabetical order

Reports

  • Creating and saving a report based on a table or query
  • Changing arrangement of data fields and headings within a report layout
  • Grouping data under a specific field in a report in ascending or descending order
  • Presenting specific fields in a grouped report by sum, minimum, maximum, average, count, at appropriate break points
  • Adding and modifying text in report headers and footers
  • Deleting a report
  • Saving and closing a report

Preparing outputs

  • Previewing tables, forms and reports
  • Changing report orientation: portrait, landscape. Changing paper size
  • Print a page, selected records, a complete table
  • Print all records or specific pages using form layout
  • Printing the results of a query
  • Printing a report or specific pages in a report

Request Course Now »

We provide Microsoft Access training courses, Microsoft Office training courses, other IT training courses  and Personal Development training courses in London, Richmond, Twickenham, Kingston, Hounslow, Brentford, Putney, Kingston, Wimbledon, Walton-on-Thames, Chiswick, Teddington, Hampton, Feltham, Acton, Ealing, Heathrow, Egham, Staines, Hanwell, Sunbury, Hammersmith, Fulham, Greenford, Clapham, Chertsey, Woking, Weybridge, Wandsworth, Middlesex, Surrey, the M25 corridor, High Wycombe and beyond. We will travel further if expenses are covered.

For Introductory Microsoft Access 2013 training courses Sydney, Australia, please visit our sister site at http://www.jmdtraining.com.au/microsoft-office-training/microsoft-access-training/introductory-access-2013-training