Course Description

MS Access 2010 Advanced

1 Training

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.

College Name 1 Training
Course Category Computers & IT (Information Technology), Microsoft Access
Course Location Dublin, Ireland
Course Fee 18
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)
Career Path • Software Engineer • Technical Support • Technical Sales • Business Analyst • Web Developer • Software Tester
For 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

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 Privacy Policy, Terms and Conditions & Cookie Information and agree to join the community.


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

Comments, Questions & Reviews

Submit A Comment, Question or Review About
MS Access 2010 Advanced
at 1 Training

Your email address will not be published. Required fields are marked *

Click to Rate

We'd love to send you the latest news and articles about evening classes, further learning and adult education by email. We'll always treat your personal details with the utmost care and will never sell them to other companies for marketing purposes.

Comments and Reviews Policy