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
Share This Post
Have your say!
0 0

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

SUBSCRIBE To Our Emailing List And Receive 3 FREE Gifts...Now

Receive 3 Instant Free Gifts  When Subscribing to our newsletter here below
Two Books( Excel Pivot Tables - Dynamic Charts) and The Magical Shortcuts Quick Reference Card Showing 78  easy to remember Shortcuts.
SUBSCRIBE NOW
close-link