Microsoft Access Course

Microsoft Access Course - Self-paced study in London - High Holborn or Notting Hill & Manchester

Learn the latest version of Microsoft Access in depth, starting at any time and studying at your own pace during our long opening hours.

A quick look at the job adverts for secretarial and admin positions will confirm the popularity of this advanced database programme which forms part of the MS Office suite.

You'll need to dedicate 25-30 hours of study at our comfortable Notting Hill or Holborn or central Manchester training centres to master the programme, enhancing your employability all the while.

Find out more about Pitman Training and how this Microsoft Access Course in High Holborn or Notting Hill London or Manchester can help you here.

This Microsoft Access Course is essential for anyone who wants to work in secretarial and admin positions and learn the advanced database programme which forms part of the MS Office suite.

No previous knowledge or experience is required to study this course.

Contact us to find out if this course is suitable for you here

Come and visit us to sample this course, free.

Just call our friendly Course Advisors:

London Notting Hill - 020 7792 5214

London High Holborn - 020 7025 4700

Manchester - 0161 923 6814

We're looking forward to hearing from you.

Learn how our self-paced learning methodology means you can study our Microsoft Access 2007 Course at your own pace in our London & Manchester training centres. Contact us here now.

Contact us here to find out how long this course could take you to complete

This Microsoft Access Course is made up of 10 core modules.

Lesson One:
The terminology used in an Access database,
starting the Access 2007 program opening an existing sample database, opening a
table, query, form and report, entering a new record, finding records, sorting
records, printing a report, closing a database.

Lesson Two:
Planning and design, relationships, design
view, defining fields, data types and properties, creating a new blank database,
creating tables, entering data using datasheet view, re-sizing columns, using
the lookup wizard.

Lesson Three:
Defining relationships, creating a table
using the datasheet view, formatting the datasheet, modifying the table design,
using the input mask wizard, creating a database using a template, renaming an
object.

Lesson Four:
Editing data in form and datasheet views,
adding new records, using print preview, changing page orientation, printing a
datasheet, enforcing referential integrity in a relationship, creating a
relationship report, creating a form using the form tool, working with controls
in form design, using AutoFormat, modifying properties in a form.

Lesson Five:
Using advanced sort, using filter by form,
importing a table from an external database using a junction table to resolve a
many to many relationship, defining a composite (primary) key, adding a new
field to a form, using a calculated control on a form, creating a multi-value
field, creating an attachment field, creating a form using the form wizard.

Lesson Six:
Using query wizard, setting sort criteria,
using 'or' and 'and' in queries, using expressions to set criteria, creating
different types of queries, creating and naming a calculated field in a query
using aggregate functions.

Lesson Seven:
Adding a field with data validation in a
table, creating a form with subform, entering data using a form/subform
combination, creating a split form, creating a basic report, using the report
wizard, creating and modifying the design of a report, using the concatenate
expression, inserting a logo to a report, adding a subreport to an existing
report.

Lesson Eight:
Exporting an HTML document, understanding
object dependencies, importing an excel spreadsheet into a table, exporting a
spreadsheet, importing a text file into a table, using the analyse table
function, using the analyse performance function, using the database documenter.

Lesson Nine:
Adding a chart to a form, modifying a
chart in a form, creating a pivot table, creating a pivot chart, creating a
switchboard, changing the tab order in a form, displaying the current date and
time in a form, applying conditional formatting to a field.

Lesson Ten:
Deselecting the automatic switchboard
option, creating a macro, adding a control button to a form, backing up a
database, viewing database properties, compacting and repairing a database,
encrypting a database using a password, saving the database as a previous
version, splitting a database.

Find out how this is one of the most comprehensive courses in Britain. It's a lot to learn, but don't worry, our course advisors will be with you every step of the way.

Nationally recognised Pitman Training certificate.

The price of this Microsoft Access Course is just £414.36 (inc VAT) 

(NB: Government funding is not available for this course and attendance is required in London's Notting Hill or High Holborn or Manchester to complete the course.)

You can start this course at any time (no waiting for term to start) and come in to study at times to suit you during our long opening hours which include evenings and Saturdays.

This course leads to a nationally recognised Pitman Training qualification.