ACCESS ADVANCED COURSE – ONE DAY

Prerequisites

To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Access Intermediate Level.

Course Overview

Learn advanced topics in Access 2013 such as how to manage data and data entry, creating forms and dialog boxes, advanced queries, splitting databases, and much more. This course builds on basic Microsoft Access skills acquired in Level 1 to help students become power users. In this Microsoft Access course, students will delve deeper into the program by studying different topics such as how to manage data and data entry, creating forms and dialog boxes, splitting databases, and much more.

Access Advanced Topics

1. What is Querying with SQL
2. Writing SQL statement
3. AddingFieldAliases
4. Displaying Matching data from related tables
5. DisplayingUnmatchedRecords
6. Create SQL Query in SQL view
7. Context Sensitive Help
8. Attaching SQL queries to control
9. Creating Advanced queries
10. Creating Crosstab queries
11. The Crosstab query wizard
12. Create Parameter Queries
13. Wild Cards in Parameter queries
14. Using Action Queries
15. Creating an Append Queries
16. Creating a Delete Queries
17. Creating an Update query
18. Creating a Make Table queries
19. Create and run macros to automate tasks.
20. What is a Macro?
21. Modifying macros
22. Attach macros to events of database objects.
23. Creating Advanced Macros
24. Create Data Validation & Data entry Macro
25. Create Macros that run a parameter query
26. Create AutoKeys and AutoExec macros
27. Create macros to import and export database objects
28. Importing, Exporting & Linking
29. Importing Objects
30. Exporting Objects
31. Exporting & Importing XML documents
32. Save an Access Object as an XPS file
33. Linking Access Objects
34. Linking to an Access table
35. Using the Linked Table Manager
36. Creating Links to Excel
37. Using Hyperlinks Fields
38. Database Management
39. Optimizing Resources
40. Converting databases to earlier version
41. Analyzing database performance
42. Splitting databases
43. Compacting & repairing databases
44. Backing up the database
45. Protecting Databases
46. Setting Options and properties