An understanding of how to utilise Microsoft Access to its best is a highly worthwhile skill to have at your command. This is a popular database application that is widely used across many employment sectors.
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.
Awarded 22 CPD points upon successful completion
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.
To teach the Microsoft Access program to an employable level and to cover the Microsoft Certified Application Specialist test (MCAS) and ECDL Advanced (Database) exam.
You don’t need to have any specific previous experience or knowledge before starting this course.
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 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.
After your Access training, progression through other Microsoft Office training courses could lead to a full Microsoft Office Specialist (MOS) qualification a leading IT certification known globally. Holding this certification can be handy if you want to gain a role as a PA, EA, Office Manager or Operations Manager for example.