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