IT's Easy Training logo

IT's Easy Training

Course Images

Microsoft Access Master Class

Microsoft Access Master Class

Highlights

  • On-Demand course

  • 6 hours

  • All levels

Description

Unlock the full potential of data management with our comprehensive online Access course. Whether you're a beginner looking to learn the basics or a seasoned professional aiming to refine your skills, this course offers a flexible, user-friendly approach to mastering Microsoft Access. Dive into a curriculum designed to empower you with the tools to create, navigate, and manage databases with ease. With expert guidance, practical exercises, and real-world applications, you'll transform data into actionable insights. Enrol now and take the first step towards becoming an Access aficionado!

This in-depth course is meticulously crafted to endow participants with the competencies required to master Microsoft Access. It caters to both novices embarking on their database journey and seasoned professionals seeking to polish their expertise. The curriculum encompasses a thorough exploration of fundamental database concepts, progressing to the intricate intricacies of query formulation and form development. Enrolees will acquire proficiency in manoeuvring through the Access environment, architecting and administering databases, and grasping the foundational theories of database architecture critical for proficient data stewardship. Furthermore, the program investigates the intricacies of report generation, empowering learners to dissect and represent data graphically, thus yielding practical insights. Blending conceptual instruction with experiential learning, the course facilitates a hands-on approach, equipping students with applicable skills for real-life applications. On successful completion, attendees will possess a robust understanding of Microsoft Access, positioning them to optimize data handling processes and amplify efficiency in their professional pursuits.

Course Content

  1. Course Promotional video
  2. Course Overview
  3. Basic Concepts
  4. Validation Rules
  5. Calculated Fields
  6. Filtering
  7. Exercise One Instructions
  8. Lookup Lists
  9. Importing Tables
  10. Mail Merge
  11. Moving Columns
  12. Attachment Fields
  13. Exercise two Instructions
  14. Basic Queries
  15. Parameter Queries
  16. Between and AND queries
  17. Operators
  18. Exercise Three Instructions
  19. Basic Forms
  20. Form Design
  21. Add a Search Box
  22. Relationships
  23. Reports
  24. Labels
  25. Exercise Four Instructions
  26. Related Forms
  27. Related Reports
  28. Self joins
  29. Exercise Five Instructions
  30. Calculations and Totals
  31. Calculations across tables
  32. Update Query
  33. Concatenation
  34. Action Queries
  35. CrossTab Queries
  36. Exercise Six Instructions
  37. Feedback Form
  38. Sub Forms
  39. Tab Controls
  40. Create a main menu
  41. Navigation Forms
  42. Calculations on Forms
  43. Conditional Formatting
  44. Charts
  45. Parameter Forms
  46. Application Parts
  47. Exercise Seven Instructions
  48. Calculations in reports
  49. Functions in Queries
  50. Join text with fields
  51. Export Reports
  52. Conditional Formatting on Reports
  53. Exercise Eight Instructions
  54. Basic Macros
  55. Auto Keys
  56. Attach a Macro to Form Properties
  57. Grouping macros
  58. Navigation Pane Options
  59. Exercise Nine Instructions

Reviews