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.
Quick EnquiryThis 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
Start Date
Study Type
Training Type
Duration
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.
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.
• Learn how to use this popular database program
• The flexibility and value of a self-study course designed to enable you to work at your own pace
• A reference guide to use and refer to on completion of the course.
• The opportunity to gain the widely recognised Pitman Training Certificate
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
Request more details or call the team on 1800 532632
Simply enter your details below and we'll email you a copy of all the course details straightaway. One of our friendly course advisors will be in touch to see how we can help and answer all your questions.
We offer a range of training packages in a range of subject areas and can offer blended learning opportunities to best meet your needs.
Our courses are practical in nature and focus on a single subject and can last anywhere from a few hours to a few days.
Diplomas are designed to give you a complete skillset mapped to a specific career path and contain a number of core and elective courses.
Click below for more details or call us on 1800 532632.
Call us now and transform your career today
Connect with us on