Covid-19 Update

At Transform Learning Academy, we are determined to support your learning goals. Henceforth, all our programmes will be run interactively by our specialist team using remote webinar. Remote students will receive the same high-level of support we pride ourselves on.

Learn how to become a Project manager in less than 12 weeks

Microsoft Access

Home / Courses / Microsoft Access

Microsoft Access is a highly worthwhile skill to have at your command as this very popular database application is widely used across many employment sectors. Offering training in either 2010 or 2013, in this detailed and varied training programme you'll be guided through many aspects of Access including; database terminology; planning and design; defining relationships and creating a table; editing data; using advanced tools; using the query wizard; adding a field; exporting an HTML document; adding charts to forms; and creating macros.

Powered By Pitman Training

ACCREDITED BY

REASONS TO CHOOSE

Microsoft Access

Applicable to numerous industries

Accredited and desired worldwide

Gain skills that can be implemented in real workplace situations

Save on costings

Attain a qualification employers are desperate for

Best Price in the Industry

Microsoft Access

Trusted & Accredited by CPD


Best Price in the Industry


Save Costings


Available delivery methods for this course

COURSE INFORMATION

Is this for you?

This popular database programme is used in many industries by those wishing to keep accurate, up to date records of customers, projects, products etc. So, for example, if you’re working as a PA, EA, VA, Secretary, Administrator or Customer Services Executive, learning how to use this software properly will help you and your skill stand out from the crowd.

Career ladder

Gaining knowledge on how to effectively set up and manage databases within the Microsoft Access programme can be useful in many work environments.

Those working in Data Entry for example would need a good working knowledge of this system. If you work as a Personal Assistant (PA) it’s a good tool to help manage large amounts of data or utilise as a way to extract information from a large data set. Similarly, Project Managers might find this a good tool to keep track of client contact information or essential project information and again, be able to extract information to assess.

It’s uses are very adaptable and can be applied in most office-based jobs.

What does the Course cover

The lesson plan content for both the 2010 and 2013 versions of this Access course are very similar and follow the example structure below: 

Lesson One – Including: terminology, working with existing databases, opening a table, query, form and report, entering new records, searching and sorting.

Lesson Two – Including: planning and design, relationships, defining fields, data types and properties, creating tables, entering data, re-sizing columns, using the lookup wizard

Lesson Three – Including: defining relationships, creating tables, formatting, modifying, using the input mask wizard, using templates, renaming an object

Lesson Four – Including: editing data, adding records, printing preview, changing page orientation, enforcing referential integrity in a relationship, creating a relationship report, creating a form, working with controls in form design, using AutoFormat, modifying properties in a form

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

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

Lesson Seven – Including:  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 and modifying the design of a report, using the concatenate expression, adding a subreport to an existing report

Lesson Eight – Including: exporting an html document, understanding object dependencies, importing and exporting a spreadsheet, importing a text file, using the analyze table function, using the analyze performance function, using the database documenter

Lesson Nine – Including: adding and modifying a chart, changing the tab order in a form, displaying the current date and time in a form, applying conditional formatting to a field

Lesson Ten – Including: 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.

Start Date

Flexible Date (You can start the course Anytime)

Study Type

Online

Training Type

Course

Duration

20-22 Hours

What does the Course cover

 

The lesson plan content for both the 2010 and 2013 versions of this Access course are very similar and follow the example structure below: 

 

Lesson One – Including: terminology, working with existing databases, opening a table, query, form and report, entering new records, searching and sorting.

Lesson Two – Including: planning and design, relationships, defining fields, data types and properties, creating tables, entering data, re-sizing columns, using the lookup wizard

Lesson Three – Including: defining relationships, creating tables, formatting, modifying, using the input mask wizard, using templates, renaming an object

Lesson Four – Including: editing data, adding records, printing preview, changing page orientation, enforcing referential integrity in a relationship, creating a relationship report, creating a form, working with controls in form design, using AutoFormat, modifying properties in a form

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

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

Lesson Seven – Including:  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 and modifying the design of a report, using the concatenate expression, adding a subreport to an existing report

Lesson Eight – Including: exporting an html document, understanding object dependencies, importing and exporting a spreadsheet, importing a text file, using the analyze table function, using the analyze performance function, using the database documenter

Lesson Nine – Including: adding and modifying a chart, changing the tab order in a form, displaying the current date and time in a form, applying conditional formatting to a field

Lesson Ten – Including: 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.

Key points about this course

Method: Online

Accredited: Yes

Start Date: Anytime

Dates & Prices

Select your course

Upon purchase of this course you will receive a series of emails which will provide access to your learning portal. All of your courses will appear here and you will have 4 weeks access.

Was
Now
Course Price
£540
£450
Add-on Features
£0
Total
£450
ENQUIRE

Choose a Month

How many employees need training

When would you like to take the course?

What is your name?
What is Your Job Title?*
Company Name*
Email Address*
Phone Number*
Additional Details*
The information you provide shall be processed by Transform Learning Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry.

Why Choose

98% Exam Pass Rate We have managed to get our delegates into a job within a 4 month period. All we ask is for your full dedication.

Best Price in the Industry You won’t find better value in the marketplace for the full end-to-end career transformation.

Nationwide Training We constantly run classroom sessions from the North of England to London. Sessions run all year round!

Nationwide Training You can work on any of our projects, whilst working full time.

CONGRATULATIONS

You're On Your Way To Success

Full Name*
Email Address*
Phone Number*
PLEASE SCHEDULE AN APPLICATION CALL HERE

You Will Receive An Email

Please check your inbox and spam for further information on the programme and to schedule an application call.

LET US KNOW HERE WHEN IS A GOOD TIME TO TALK TO YOU