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.

‍

‍

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.

‍

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.

‍

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

‍