Breadcrumb

ActivitatsDetall

Microsoft Access Intensive Course: Preparation for Official Microsoft MO-500 Certifications

Description
Learn how to manage databases with Microsoft Access, from basic concepts to advanced techniques. Covers creating tables, relationships, queries, forms, reports, macros, and security. Includes preparation for the official MO-500 exam. Ideal for obtaining the Microsoft Office Specialist: Access Expert certificate.
Duration:
14 hours. Multi-session programme de 4 sessions.
Content

OBJECTIVES

  • Master Basic and Advanced Microsoft Access Features
  • Automate Tasks and Improve Efficiency
  • Apply Microsoft Access in Real Projects

COURSE CONTENT

  1. Introduction to Microsoft Access
  2. Differences between Access and Excel
    • Basic database concepts
    • Types of objects
  3. Table structure
    • Creating tables
    • Data types
    • Primary key
    • Relationships between tables
    • Types of relationships (one-to-many, many-to-many)
    • Referential integrity
  4. Types of relationships (one-to-many, many-to-many)
    • Referential integrity
    • Introduction to queries
  5. Queries
  6. Select queries
    • Creating queries
    • Types of criteria
    • Subtotals
    • Crosstab queries
  7. Action queries
    • Update, append, delete, and make-table queries
  8. Forms
    • Creating and designing forms
    • Grouping and sorting data
  9. Reports
    • Creating and designing reports
    • Grouping and sorting data
  10. Macros and Automation
    • Introduction to macros
    • Automating common tasks
  11. Preparation for the MO-500 Exam
Teachers
FERRER MARTÍNEZ, ENRIC
Driving
Slash Mobility

Calendar

Days and times
Venue
Language of instruction
Places
Registration
Virtual classroom
15 Sep, 2025
15:30 - 19:00
Virtual classroom
16 Sep, 2025
15:30 - 19:00
Virtual classroom
17 Sep, 2025
15:30 - 19:00
Virtual classroom
18 Sep, 2025
15:30 - 19:00
Catalan
-
Opening of registration 31/08/2025 to 08:30 h.

Find out more

>> In case the format is virtual via streaming, it will be carried out through the free platform Microsoft Teams. Registered individuals will receive the invitation link and access instructions by email before the session starts.

>> Entry to the classroom will not be allowed after 15 minutes once the activity has started.

>> The language in which each session is conducted is informed in the description of each activity.

>> Any of the training actions of Cibernàrium may be recorded through an image capture system that aims to subsequently disseminate them through a medium or support within the scope of the mission of Barcelona Activa to contribute to economic promotion and employment. In the recording process, images of attendees may eventually be recorded. Registration for Cibernàrium activities implies authorization for Barcelona Activa to use these images for the aforementioned purpose.

ActivitatsRelacionades

Next edition

Virtual classroom
dl. 15/09/25 15:30-19:00

Virtual classroom
dt. 16/09/25 15:30-19:00

Virtual classroom
dc. 17/09/25 15:30-19:00

Virtual classroom
dj. 18/09/25 15:30-19:00

Free activity
Opening of registration 31/08/2025 to 08:30 h.

ActivitatsAnnexos