Access Essentials

  • $597.00
    Unit price per 


Access Essentials

Learners will gain a fundamental understanding of this database application's environment and basic database principles. They will be able to demonstrate the correct use of key features and the ability to create and maintain tables, relationships, forms, reports, and queries.


Just Some of our satisfied customers. View All Clients
“These materials are a life saver...”   Read more testimonials

Everything you need to teach a one-day workshop for Access Essentials:

  • Training Manuals
  • PowerPoint Slides
  • Instructor's Guide
  • Quick Reference Job Aids
  • Icebreakers, Activities,
     & Exercise Files
  • Pre-Assignments,
    Pre-/Post-Assessments
  • Promotional Advertorials
  • Lesson Plans with Flip Chart Notes


Also available: e-learning, and cloud-based LMS.



Download
Free Sample

Access Essentials

Module One: Create and Manage a Database
  • Create and Modify Databases
    • Create a blank desktop database
    • Create a database from a template
    • Create a database by using Import objects or data from other sources
    • Delete database objects
  • Manage Relationships and Keys
    • Create and modify relationships
    • Set the primary key
    • Enforce referential integrity
    • Set foreign keys, view relationships
  • Navigate through a Database
    • Navigate specific records
    • Create and modify a navigation form
    • Set a form as the startup option
    • Display objects in the Navigation Pane
    • Change views of objects
  • Protect and Maintain Databases
    • Compact a database
    • Repair a database, back up a database
    • Split a database
    • Encrypt a database with a password
    • Recover data from backup
  • Print and Export Data
    • Print reports
    • Print records
    • Save a database as a template
    • Export objects to alternative formats


Module Two: Build tables
  • Create Tables
    • Create a table
    • Import data into tables
    • Create linked tables from external sources
    • Import tables from other databases
    • Create a table from a template with application parts
  • Manage Tables
    • Hide fields in tables
    • Add total rows
    • Add table descriptions
    • Rename tables
  • Manage Records in Tables
    • Update records
    • Add records
    • Delete records
    • Append records from external data
    • Find and replace data
    • Sort records, filter records
  • Create and Modify Fields
    • Add fields to tables
    • Add validation rules to fields
    • Change field captions
    • Change field sizes
    • Change field data types
    • Configure fields to auto-increment
    • Set default values
    • Using input masks
    • Delete fields


Module Three: Create Queries
  • Create a Query
    • Run a query
    • Create a crosstab query
    • Create a parameter query
    • Create an action query
    • Create a multi-table query
    • Save a query
  • Modify a Query
    • Rename a query
    • Add fields, remove fields
    • Hide fields
    • Sort data within queries
    • Format fields within queries
  • Create Calculated Fields and Grouping within Queries
    • Add calculated fields
    • Set filtering criteria
    • Group and summarize data
    • Group data by using comparison operators
    • Group data by using arithmetic and logical operators


Module Four: Create Forms
  • Create a Form
    • Create a form
    • Create a form from a template with application parts
    • Save a form
  • Configure Form Controls
    • Move form controls
    • Add form controls
    • Modify data sources
    • Remove form controls
    • Set form control properties
    • Manage labels
    • Add sub-forms
  • Format a Form
    • Modify tab order
    • Configure Print settings
    • Sort records by form field
    • Apply a theme
    • Control form positioning
    • Insert backgrounds, insert headers and footers, insert images


Module Five: Create Reports
  • Create a Report
    • Create a report based on the query or table
    • Create a report in Design view
    • Create a report by using a wizard
  • Configure Report Controls
    • Group and sort fields
    • Modify data sources
    • Add report controls
    • Add and modify labels
  • Format a Report
    • Format a report into multiple columns
    • Add calculated fields
    • Control report positioning
    • Format report elements
    • Change report orientation
    • Insert header and footer information
    • Insert images
    • Apply a theme

Other Course Kits Available:

  1. Accountability in the Workplace
  2. Administrative Office Procedures
  3. Administrative Support
  4. Adult Learning - Mental Skills
  5. Adult Learning - Physical Skills
  6. Anger Management
  7. Appreciative Inquiry
  8. Archiving and Records Management
  9. Attention Management
  10. Basic Bookkeeping
  11. Being a Likeable Boss
  12. Body Language Basics
  13. Budgets and Financial Reports
  14. Building Confidence and Assertiveness
  15. Business Acumen
  16. Business Ethics
  17. Business Etiquette
  18. Business Succession Planning
  19. Business Writing
  20. Call Center Training
  21. Change Management
  22. Civility in the Workplace
  23. Coaching and Mentoring
  24. Coaching Salespeople
  25. Collaborative Business Writing
  26. Communication Strategies
  27. Conducting Annual Employee Reviews
  28. Conflict Resolution
  29. Contact Center Training
  30. Contract Management
  31. Creating a Great Webinar
  32. Creative Problem Solving
  33. Creativity: Thinking Outside the Box
  34. Crisis Management
  35. Critical Thinking
  36. Customer Service
  37. Customer Support
  38. Cyber Security
  39. Delivering Constructive Criticism
  40. Developing a Lunch and Learn
  41. Developing Corporate Behavior
  42. Developing Creativity
  43. Developing Emotional Intelligence
  44. Developing New Managers
  45. Digital Citizenship
  46. Diversity, Equity and Inclusion
  47. Employee Motivation
  48. Employee Onboarding
  49. Employee Recruitment
  50. Employee Termination Processes
  51. Entrepreneurship
  52. Event Planning
  53. Executive and Personal Assistants
  54. Facilitation Skills
  55. Generation Gaps
  56. Goal Setting and Getting Things Done
  57. Handling a Difficult Customer
  58. Health and Wellness at Work
  59. High Performance Teams Inside the Company
  60. High Performance Teams Remote Workforce
  61. Hiring Strategies
  62. Human Resource Management
  63. Improving Mindfulness
  64. Improving Self-Awareness
  65. In Person Sales
  66. Increasing Your Happiness
  67. Internet Marketing Fundamentals
  68. Interpersonal Skills
  69. Job Search Skills
  70. Knowledge Management
  71. Leadership and Influence
  72. Leadership Development for Women
  73. Lean Six Sigma
  74. Life Coaching Essentials
  75. Manager Management
  76. Managing Personal Finances
  77. Managing Workplace Anxiety
  78. Managing Workplace Harassment
  79. Marketing Basics
  80. Measuring Results From Training
  81. Media and Public Relations
  82. Meeting Management
  83. Middle Manager
  84. Millennial Onboarding
  85. mLearning Essentials
  86. Motivating Your Sales Team
  87. Multi-Level Marketing
  88. Negotiation Skills
  89. Networking Outside the Company
  90. Networking Within the Company
  91. Office Health and Safety
  92. Office Politics For Managers
  93. Organizational Skills
  94. Overcoming Sales Objections
  95. Performance Management
  96. Personal Branding
  97. Personal Productivity
  98. Presentation Skills
  99. Project Management
  100. Proposal Writing
  101. Prospecting and Lead Generation
  102. Public Speaking
  103. Recognizing Employee Excellence
  104. Respect in the Workplace
  105. Responsibility in the Workplace
  106. Risk Assessment and Management
  107. Safety in the Workplace
  108. Sales Fundamentals
  109. Self-Leadership
  110. Sensitivity Training
  111. Servant Leadership
  112. Social Intelligence
  113. Social Learning
  114. Social Media In The Workplace
  115. Social Media Marketing
  116. Stress Management
  117. Supervising Others
  118. Supply Chain Management
  119. Taking Initiative
  120. Talent Management
  121. Team Building For Managers
  122. Team Building Through Chemistry
  123. Teamwork and Team Building
  124. Telephone Etiquette
  125. Telework And Telecommuting
  126. Ten Soft Skills You Need
  127. The Cloud and Business
  128. Time Management
  129. Top 10 Sales Secrets
  130. Trade Show Staff Training
  131. Train-The-Trainer
  132. Trust Building and Resilience Development
  133. Unconscious Bias
  134. Universal Safety Practices
  135. Virtual Team Building and Management
  136. Work-Life Balance
  137. Workplace Bullying
  138. Workplace Harassment
  139. Workplace Violence