Access Basics for Excel Users (2019)
27mBeginner2019-11-08
Authors

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
0. Introduction
- 01 - Make the jump to using Access
1. Understanding Access
- 02 - A tour of Access
- 03 - Source your data
2. Building a Database
- 04 - Data properties
- 05 - Source additional data
- 06 - Create relationships
- 07 - Create a query
3. Managing Your Database
- 08 - Extend your query
- 09 - Create calculated fields
4. Analyzing Your Data
- 10 - Report Wizard
- 11 - Prepare charts
- 12 - Share your data
Conclusion
- 13 - Next steps