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.
Those who successfully pass this course will be awarded a Access 2010 – Advanced certificate. Anyone eligible for certification will receive a free e-certificate, and printed certificate.
With this qualification, you are able to fulfil various roles, such as:
PLEASE NOTE: We do not provide any software with this course.
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 |
Well-constructed
The quizzes for the course were well constructed and test the student’s practical knowledge. Overall, very good course.
Extremely Useful
The explanation and curriculum is packed and clear, so for someone who’s full time worker, it does help them to learn new things effectively and efficiently.
WONDERFUL COURSE
It is a wonderful course covering right from the basics to a moderate level, presenting the approaches to PivotTables, charts, switchboards and macros.
Clear and concise
The course covers fundamental topics in a clear and concise manner. Video lectures are easily understandable.