Managing information efficiently is a key aspect of many business processes. Databases are the ideal solution for this. Thanks to the Microsoft Access 2021 Course You will be able to manage information using databases. Organising the information into tables and establishing relationships between them will make subsequent queries more quick y efficient. You’ll also be able to create forms to enter data and produce professional reports using the features available in Access. Furthermore, by using macros and forms, you’ll be able to automate routine tasks. You’ll have a team of professionals specialising in this field at your disposal.
Cross-cutting
Digital Skills
25 hours
Microsoft Access 2021
Digital Skills
25 hours
Introduction
Objectives
-
To know the functions basic functions and the database management interface provided by Microsoft Access.
-
Design, create and modify diagrams databases.
-
Manage information by using tables creating relationships and indexes.
-
Using forms for the collection and data management.
-
To prepare professional reports presenting the information in an engaging way.
-
Automate tasks y processes thanks to the use of macros, modules and procedures.
Table of Contents
TEACHING UNIT 1. Basic functions for managing files
1. Create a new Access database
2. Components of an Access database
3. Access user interface
4. Use the Access Help function
TEACHING UNIT 2. The Access interface
1. View data sheet
2. Design View
3. Table properties
TEACHING UNIT 3. Databases
1. Design a database
2. Create a database
3. Create tables
4. Create a chart
TEACHING UNIT 4. Tables
1. Enter data into the tables
2. Modify the database structure
3. Main key and indices
4. Default settings
5. Relationships and referential integrity
6. Copying tables
7. Delete tables
TEACHING UNIT 5. Consultations
1. Introduction to consultations
2. The Query Data Sheet view
3. The Design View of a query
4. Basic structure of consultations
5. Create enquiries
TEACHING UNIT 6. Forms
1. What are forms?
2. Create a form
3. Types of forms
4. Form controls
5. Edit forms
TEACHING UNIT 7. Reports
1. Introduction to reports
2. Using the reports
3. Report views
4. Sections and properties
5. Draft the report
6. Create reports using wizards
7. Create a report in one click
TEACHING UNIT 8. Macros
1. What are macros?
2. The Macro Design View
3. Create standalone macros
4. Create macros embedded in forms and reports
5. Create a data macro
6. Modify actions and logic blocks
7. Conditional macros
8. Run macros
9. Types of events
10. Debugging macros
TEACHING UNIT 9. Modules
1. What are modules?
2. Types of modules and procedures
3. Create a module
4. Module debugging
5. Streamlining of procedures
More related courses
Cross-cutting
Cross-cutting
Cross-cutting
Your questions answered
Why choose Educa.Pro?
Educa.Pro enables organisations to centralise training management, personalise learning and gain clear insights into the impact of training programmes. Thanks to its AI-powered technology, organisations can optimise their learning strategies, enhance talent development and make data-driven decisions.
Can the courses be taken at your own pace?
Yes. Most of the courses on Educa.Pro are self-paced and on-demand, allowing users to progress at their own pace without missing out on progress tracking or assessments, which makes it easier to fit them around work or study commitments.
What levels of security and compliance does the platform offer?
Educa.Pro complies with security standards designed to protect user and organisational data. Furthermore, it supports the traceability of certifications, digital signatures and the management of assessments, thereby ensuring regulatory and legal compliance in both educational and corporate environments.
What support and guidance does Educa.Pro offer?
The Educa.Pro team offers comprehensive support throughout implementation, roll-out and adoption, ensuring that organisations get the most out of the platform and achieve measurable results from day one.