Microsoft Office & 365 Apps
Microsoft Access: Access Part 1 (Introduction)
Build and use Access databases.
2 daysFoundation8 modules
About this course
Build and use Access databases. Over two days you will create tables, queries, forms and reports, promote quality data entry and improve usability.
What you'll learn
- Navigate within the Access environment, create a simple database, and customize options.
- Organize and manage data stored within Access tables.
- Use queries to join, sort, and filter data across multiple tables.
- Design forms to simplify data entry and review.
- Create and format custom reports for professional output.
- Apply validation techniques to ensure data accuracy and integrity.
Curriculum
8 modules
- Launch Access and open a database
- Use tables to store data
- Use queries to combine, find, filter, and sort data
- Use forms to view, add, and update data
- Use reports to present data
- Plan an Access database
- Start a new Access database
- Create a new table
- Establish table relationships
- Create basic queries
- Perform calculations in a query
- Sort and filter data in a query
- Start a new form
- Enhance a form
- Start a new report
- Enhance report layout
- Restrict data input through field validation
- Restrict data input through forms and record validation
- Data normalization
- Associate unrelated tables
- Enforce referential integrity
- What Is Microsoft Copilot Chat?
- The Magic Prompt Formula
- Work Smarter with AI
Who it's for
Office staff who manage structured data.
Before you start
- Basic computer literacy
- Basic PC operating system navigation skills
- Basic Internet usage skills
- Basic IP address knowledge
Related courses
More in Microsoft Office & 365 Apps →Intermediate
Data Analysis and Visualization with Microsoft Excel
Microsoft Office & 365 Apps
View course →Advanced
Microsoft Access: Access - Part 2 (Advanced)
Microsoft Office & 365 Apps
View course →Foundation
SQL Fundamentals - Part 1: Essential Querying Skills
Microsoft Data & Power BI
View course →Advanced
55205 Mastering Microsoft Project 2016
Microsoft Office & 365 Apps
View course →Intermediate
55234 SharePoint 2016 Site Collections and Site Owner Administration
Microsoft Office & 365 Apps
View course →Intermediate
55238 SharePoint Online for Administrators
Microsoft Office & 365 Apps
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.