Contact
Demo
Contact
Demo
Cross-cutting

Access. Advanced Level

Digital Skills 8 pm

Introduction

This Access Course: Advanced Level enables users to create bespoke database solutions, automate business processes and carry out complex data analysis. This skill is particularly valuable in environments business-related where efficient data management is essential for success. It enables users to create bespoke database solutions and automate business processes and carry out complex data analysis. This skill is particularly valuable in business environments where the efficient data management is essential for success. Thanks to this training, you will be able to identify and resolve problems and errors in the database, including the ability to diagnose performance issues

Objectives

  1. Understanding how the data in such a way that structured y organised.

  2. Purchase knowledge on the advanced features of Microsoft Access and work with fields, relationships, importing, linking and mail merge.

  3. Learning how to share databases between users y contributors.

Table of Contents

TEACHING UNIT 1. OPTIMISING INFORMATION IN ACCESS

  1. Field data types.
  2. Field sizes.
  3. Field format.
  4. Field input mask.
  5. Search fields.
  6. Relationships between tables.
  7. Types of relationships.
  8. Referential integrity.
  9. Related records.
  10. Edit relationships.
  11. View and print reports.
  12. Importing data between tables.
  13. Import data from Microsoft Excel.
  14. Linking data between tables.
  15. Link data from a Microsoft Excel spreadsheet.
  16. Export data to Microsoft Word.
  17. Export data to Microsoft Excel.
  18. Merge correspondence.
  19. Compact and repair a database.

TEACHING UNIT 2. FORMS AND REPORTS

  1. Create forms using AutoForm.
  2. Create forms using the wizard.
  3. Add fields to a form.
  4. Customise a form.
  5. Add dependent controls.
  6. Add standalone text boxes.
  7. Add list controls to a form.
  8. Sections of a form.
  9. Adding and removing filters in a form.
  10. Create reports using the self-service reporting tool.
  11. Create reports using the wizard.
  12. Sections of a report.
  13. The header and footer of a report.
  14. Tags in a report.
  15. Add dependent controls.
  16. Add standalone text boxes.
  17. Group records in a report.
  18. Create a sub-report.
  19. Create a sub-report based on an existing one.
  20. Linking reports and sub-reports.
  21. Properties of a sub-report.

TEACHING UNIT 3. QUERIES, MACROS AND THE INTERNET

  1. Create simple selection queries.
  2. Create cross-reference table queries.
  3. Customise cross-reference table queries.
  4. Create a parameter query.
  5. Create an action query.
  6. Create a deletion query.
  7. Create an update query.
  8. Creating filters from queries.
  9. Create a data access page using AutoPage.
  10. Create a data access page using the wizard.
  11. Merge a data access page.
  12. Group records.
  13. Create a static HTML page.
  14. Publish a data access page.
  15. Forms and reports as data access pages.
  16. Edit a data access page.
  17. Create a simple macro.
  18. Open and edit an existing macro.
  19. Group macros.
  20. Run a macro.

More related courses

Cross-cutting
Cross-cutting 1 hour

Masterclass – Introduction to ChatGPT

View course →
Cross-cutting
Cross-cutting 40 hours

Basic Digital Skills in Digital Information Search and Management

View course →
Cross-cutting
Cross-cutting 30 hours

Notification and Electronic Registration

View course →

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.

Scroll to Top