Access Basics for Excel Users (2019)

Access Basics for Excel Users (2019)

27mBeginner2019-11-08

Authors

Joshua Rischin

Joshua Rischin

Company Director of Axium Solutions

Course details

Business don’t need more data—they need actionable insights. Microsoft Access makes it easy to organize, analyze, and visualize data for better decision-making and results. This course is designed to help Excel users make the jump to Access and create their own simple databases. Instructor Joshua Rischin, an Access expert, reviews the essentials, including the core functions and uses of the program. Learn how to source and connect to data, build a brand-new database with tables and relationships, add calculated fields, create powerful queries, and generate reports and charts to share your insights. This course proves you don’t need to be a developer to create databases; you just need Access on your side.

Skills covered

Microsoft AccessDesktop DatabasesBusiness Software and ToolsMicrosoftOne-Off

Concepts

Introduction

  • Make the jump to using Access

Understanding Access

  • A tour of Access
  • Source your data

Building a Database

  • Data properties
  • Source additional data
  • Create relationships
  • Create a query

Managing Your Database

  • Extend your query
  • Create calculated fields

Analyzing Your Data

  • Report Wizard
  • Prepare charts
  • Share your data

Conclusion

  • Next steps