• No products in the basket.

MS Access 2010 Advanced

4.5( 4 REVIEWS )
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.

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!

Course Outline:

  • Module 01: Relationships & Referential Integrity
  • Module 02: Tables & Fields
  • Module 03: Queries
  • Module 04: Forms
  • Module 05: Reports
  • Module 06: Charts, PivotTables, and PivotCharts
  • Module 07: Switchboards
  • Module 08: Macros
  • Module 09: Exporting Data
  • Module 10: Importing Data
  • Module 11: Database Tools & Maintenance
  • Module 12: Smart Tags, Startup, & Help

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.

What Certification am I going to receive?

Those who successfully pass this course will be awarded a Access 2010 – Advanced certificate. Anyone eligible for certification will receive a free e-certificate.

What are 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)

What careers can I get with this qualification?

With this qualification, you are able to fulfil various roles, such as:

  • Software Engineer
  • Technical Support
  • Technical Sales
  • Business Analyst
  • Web Developer
  • Software Tester

PLEASE NOTE: We do not provide any software with this course.

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

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
WhatsApp chat