Description
The “Access Basics” course is a fundamental course designed to empower participants of all levels to use Microsoft Access, the leading database management system. This interactive and hands-on course provides a thorough introduction to Access's basic concepts and functionalities, including setting up databases, creating tables and queries, and analyzing large data sets. Through practical examples and exercises, participants will learn how to use Access effectively for their business needs. The course lays a strong foundation for working professionally with databases, allowing students to work independently with Access upon completion. With this training, you are taking an important step in mastering database management and analysis, essential skills in today's data-driven world.
Audience
This course is for both novice and somewhat experienced users who need to be able to create tables and queries for both existing and new database applications, or who have to deal with analyzing large amounts of data.
A good knowledge of Microsoft Excel features is certainly an advantage. For participants who really need to design and manage a database, it is advisable to first take the Designing a Relational Database course.
Methods
In this interactive course, where theory and practical applications alternate, you will acquire the knowledge to develop an Access database and learn how to create tables and queries. Through cases and exercises, you'll discover the versatility of this program for your business needs.
Contents
Getting to know Access
- Database templates
The database
- Flat and relational database
- ERD chart and normalizing
Tables
- Data sheet and design view
- Field types
Data sheet
- Add and remove records
- Navigate
Relationships between tables
- Diverse relationships
- Primary and foreign keys
Field properties
- Field length and new values
- Notation and input mask
Selection query
- Selection criteria: general, field references, parameter query
Joins
- Cross Join, Auto Join
- Inner Join, Outer Join, Is Null
Math and group
- Calculation fields
- Groups and arithmetic operations
Functions
- Calculation fields and functions
- Criteria and functions
- AutoForm and AutoReport
- Importing and exporting data
Certification
Participation certificate: participants receive a certificate that they have completed this training at the end of the training.