Get to know the latest version of Microsoft Access in detail, studying at your own pace, and add a nationally recognised Pitman Training certificate to your CV when you successfully complete the course.
Once you’ve mastered this popular database program, you’ll find more doors opening for you – a quick look at the job adverts for secretarial and admin positions confirm how essential it is to be skilled in Microsoft Access.
Pitman Training’s self-paced course consists of nine lessons, in which you’ll gain extensive, practical skills in Microsoft Access 2010 or 2013.
Enquiring from the Manchester area? Click here for further details.
Microsoft Access – Course Content
At the end of the course, you’ll have the skills and knowledge required to be able to start, build, update and maintain a database in Access.
You’ll work through the following lessons:
Lesson One: The terminology used in an Access database, starting the Access 2013 program, opening an existing sample database, opening a table, query, forma 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, 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 themes, 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, adding a calculated field to a table
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, changing the tab order in a form, displaying the current date and time in a form, applying conditional formatting to a field, creating a navigation form, customising the ribbon
For a full course outline or to try a free course demo, just get in touch!
How Pitman Training’s Access Course Works
You can study the Microsoft Access course in your own time, at your own pace, and receive support from our training team as and when you need it.
The course is audio based, and you’ll also receive a workbook which is yours to keep at the end of the course for future reference.
You can drop into the centre at times to suit you to study, and you can even study from home if getting to one of our centres is not convenient for you.
At the end of the course, you’ll take an exam leading towards your nationally recognised Pitman Training certificate.
Who Should Study This Microsoft Access Course?
If you’re looking to gain skills in a widely used database, then this is the course for you.
It’s also suitable if you’re familiar with previous versions of Microsoft Access and need to update your skills in line with the latest version.
Want to try a free demo to help you decide if this is the course for you?
Call our friendly Course Advisors today!
You can study Pitman Training’s Microsoft Access 2013 course in the following locations:
Can’t get to one of our centres? Get in touch today to find out about our home study options.
More Career Building Courses
You might also be interested in the following Microsoft Office courses:
- Microsoft Office Plus Diploma
- Microsoft Office Fast Track Diploma
- Word – Beginners to Intermediate
- Word – Advanced
- Excel – Beginners to Intermediate
- Excel – Advanced
- MS Project
- Microsoft Access 2010
Please note – we are able to offer both Microsoft Office 2010 and Microsoft Office 2013 courses.
Browse our course list to see the full list of courses on offer at Pitman Training in London and Croydon.