Access Basics for Excel Users

30mBeginner2025-01-03

Authors

Joshua Rischin

Company Director of Axium Solutions

Course details

Businesses 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.

Learning objectives
Transition from Excel to Access by applying existing spreadsheet skills to database development.
Create and structure a basic relational database using tables and relationships in Microsoft Access.
Develop effective queries to extract and analyze data for actionable business insights.
Generate informative reports and charts to visualize data and support decision-making processes.
Connect to and import various data sources into Microsoft Access for comprehensive data management.

Skills covered

Microsoft AccessDesktop DatabasesIntroduction toSpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoft

Concepts

0. Introduction

01 - Make the jump to using Access

1. Understanding Access

02 - Where does Access fit
03 - A tour of Access
04 - Source your data

2. Building a Database

05 - Data properties
06 - Source additional data
07 - Create relationships
08 - Create a query

3. Managing Your Database

09 - Extend your query
10 - Create calculated fields

4. Analyzing Your Data

11 - Report Wizard
12 - Prepare charts
13 - Share your data

Conclusion

14 - Next steps