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 Kit's 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 Recognition
  50. Employee Recruitment
  51. Employee Termination Processes
  52. Entrepreneurship
  53. Event Planning
  54. Executive and Personal Assistants
  55. Facilitation Skills
  56. Generation Gaps
  57. Goal Setting and Getting Things Done
  58. Handling a Difficult Customer
  59. Health and Wellness at Work
  60. High Performance Teams Inside the Company
  61. High Performance Teams Remote Workforce
  62. Hiring Strategies
  63. Human Resource Management
  64. Improving Mindfulness
  65. Improving Self-Awareness
  66. In Person Sales
  67. Increasing Your Happiness
  68. Internet Marketing Fundamentals
  69. Interpersonal Skills
  70. Job Search Skills
  71. Knowledge Management
  72. Leadership and Influence
  73. Leadership Development for Women
  74. Lean Process and Six Sigma
  75. Life Coaching Essentials
  76. Manager Management
  77. Managing Personal Finances
  78. Managing Workplace Anxiety
  79. Managing Workplace Harassment
  80. Marketing Basics
  81. Measuring Results From Training
  82. Media and Public Relations
  83. Meeting Management
  84. Middle Manager
  85. Millennial Onboarding
  86. mLearning Essentials
  87. Motivating Your Sales Team
  88. Multi-Level Marketing
  89. Negotiation Skills
  90. Networking Outside the Company
  91. Networking Within the Company
  92. Office Health and Safety
  93. Office Politics For Managers
  94. Organizational Skills
  95. Overcoming Sales Objections
  96. Performance Management
  97. Personal Branding
  98. Personal Productivity
  99. Presentation Skills
  100. Project Management
  101. Proposal Writing
  102. Prospecting and Lead Generation
  103. Public Speaking
  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