Course Description

MS Access 2010 Advanced

MS Access 2010 Advanced is a course run by 1 Training, Dublin. For more information about MS Access 2010 Advanced at 1 Training, please review the details below.

MS Access 2010 Advanced


This excellent Access 2010 – Advanced level course will turn you into a master of Access 2010, so you can get the most out of it. Improve your working knowledge of tables, queries, reports and forms. In addition, the course covers how to use PivotTables, create relationships, charts, switchboards and macros. You’ll even learn to export and import data, use smart tags, link tables from other Access databases, and much more! This course focuses on Access 2010 (so you’ll need to have this software on your computer) and it is advanced level, so if you have used Access before, this is the course for you.

Course Curriculum Total Units : 74
1: Relationships & Referential Integrity
1. Understanding relationships
2. Creating a one-to-many relationship Part – 1
3. Creating a one-to-many relationship Part – 2
4. Creating a many-to-many relationship
5. Enforcing Referential Integrity
6. Editing & deleting relationships
7. Modifying the relationship window
8. Printing table relationships

2: Tables & Fields
1. Indexing a field
2. Indexing multiple fields
3. Using validation rules & text in a table
4. Creating a lookup field
5. Creating a value list
6. Using the attachment data type

3: Queries
1. Creating a Union query
2. Creating a Crosstab query
3. Concatenating two or more fields
4. Using the Between And operator
5. Using wild card characters
6. Using the IIF function

4: Forms
1. Creating a subform
2. Displaying a subform calculation
3. Opening a subform in a new window
4. Setting control defaults
5. Using a tab control
6. Managing attachments in a form
7. Adding a totals row to Datasheet View

5: Reports
1. Creating a subreport
2. Creating a numbered list
3. Creating a multi-column report
4. Creating a report template
5. Coloring alternate rows in a table, form or report

6: Charts, PivotTables, and PivotCharts
1. Creating a chart in a form or report Part – 1
2. Creating a chart in a form or report Part – 2
3. Editing an existing chart Part – 1
4. Editing an existing chart Part – 2
5. Creating a PivotTable
6. Working in a PivotTable Part – 1
7. Working in a PivotTable Part – 2
8. Working in a PivotTable Part – 3
9. Creating a PivotChart from a PivotTable
10. Creating a PivotChart
11. Working in a PivotChart Part – 1
12. Working in a PivotChart Part – 2
13. Working in a PivotChart Part – 3

7: Switchboards
1. Understanding a switchboard
2. Creating a switchboard using the Switchboard Manager Part – 1
3. Creating a switchboard using the Switchboard Manager Part – 2
4. Creating a switchboard from scratch

8: Macros
1. Creating a simple macro
2. Creating a macro using the Macro Builder
3. Assigning a macro to a form/report control event
4. Adding a condition to a macro
5. Creating a Group macro
6. Creating an AutoExec macro
7. Using Single Step mode to test a macro

9: Exporting Data
1. Exporting an object to another Access database
2. Exporting to a spreadsheet
3. Exporting to a text file
4. Exporting to Microsoft® Wordc
5. Using a table or query as a mail merge data source

10: Importing Data
1. Importing from another Access database
2. Importing spreadsheet data
3. Importing text files Part – 1
4. Importing text files Part – 2
5. Linking tables from other Access databases

11: Database Tools & Maintenance
1. Compacting and repairing a database
2. Backing up a database
3. Using the Database Documenter
4. Converting an Access database
5. Checking object dependencies

12: Smart Tags, Startup, & Help
1. Using smart tags
2. Setting Startup options
3. Using help

Our learning material is available to students 24/7 anywhere in the world, so it’s extremely convenient. These intensive online courses are open to everyone, as long as you have an interest in the topic! We provide world-class learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date.

What skills will I gain?

  • Navigate Access like a pro
  • Work with PivotTables
  • Learn to use Macros
  • Learn to create a switchboard
  • Learn to create a report template
  • And much more!

How will I be assessed?

  • You will have one assignment. Pass mark is 65%.
  • You will only need to pay £19 for assessment.
  • You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days.
The MS Access 2010 Advanced course at 1 Training is listed in's national courses finder.
Training Provider1 Training
Course LocationDublin
Course Fee18
Entry Requirements• You must be 16 or over • You should have a basic understanding of English, Maths and ICT • You will need a computer or tablet with internet connection (or access to one)
Carear Path• Software Engineer • Technical Support • Technical Sales • Business Analyst • Web Developer • Software Tester
Phone+44 208 610 9650
For more information about 1 Training, please visit our College page on by clicking here.

Course Provider

1 Training

63/66 Hatton Garden, 5th Floor, Suite 23, London. EC1N 8LE, Dublin, United Kingdom. Eircode: EC1N 8LE

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to 1 Training

Captcha code        I confirm I have read the Cookie Information, Terms and Conditions and Privacy Policy and I agree to join the community.


1 Training
63/66 Hatton Garden, 5th Floor, Suite 23, London. EC1N 8LE
United Kingdom
Visit Website