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 40 hours

Self-service data preparation. Excel, Talend and Trifacta

View course →
Cross-cutting
Cross-cutting 55 hours

Social Media Management: Facebook, TikTok, Instagram, X and LinkedIn

View course →
Scroll to Top