Cisco Training Courses

Insoft has been serving IT community with official Cisco training offering since 2010. Find all the relevant information on Cisco training on this page.

View More

Cisco Certifications

Experience a blended learning approach that combines the best of instructor-led training and self-paced e-learning to help you prepare for your certification exam.

View More

Cisco Learning Credits

Cisco Learning Credits (CLCs) are prepaid training vouchers redeemed directly with Cisco that make planning for your success easier when purchasing Cisco products and services.

Have CLCs and want to redeem them?

Cisco Continuing Education

The Cisco Continuing Education Program offers all active certification holders flexible options to recertify by completing a variety of eligible training items.

View More

Cisco Digital Learning

Certified employees are VALUED assets. Explore Cisco official Digital Learning Library to educate yourself through recorded sessions.

Browse CDLL Catalogue

Cisco Business Enablement

The Cisco Business Enablement Partner Program focuses on sharpening the business skills of Cisco Channel Partners and customers.

View More

Fortinet Technical Certifications

The Fortinet Network Security Expert (NSE) program is an eight-level training and certification program to teach engineers of their network security for Fortinet FW skills and experience.

View More

Fortinet Technical Courses

Insoft is recognised as Fortinet Authorized Training Center in selected locations across EMEA.

View More

Official ATC Status

Check our ATC Status across selected countries in Europe.

View More

Fortinet Services Packages

Insoft Services has developed a specific solution to streamline and simplify the process of installing or migrating to Fortinet Products.

Browse Packages

Prepforce Bootcamp

The only comprehensive source available today to prepare for Fortinet NSE 8 certification globally.

View More

Microsoft Training

Insoft Services provides Microsoft training in EMEAR. We offer Microsoft technical training and certification courses that are led by world-class instructors.

View More

Technical Training

The evolution of Extreme Networks Technical Training provides a comprehensive progressive pathway from Associate to Professional accreditation.

View More

ATP Accreditation

As an authorised training partner (ATP), Insoft Services ensures that you receive the highest standards of education available.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

Our Mission: Provide an expert set of modern & leading edge Network Automation skills to the market through professional services.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

We help organisations to deploy Software-Defined Networking (SDN) solutions, such as Cisco DNA. Besides, our team has extensive experience in integrating Cisco DNA Center with third-party systems.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

About Us

Our training portfolio includes a wide range of IT training from IP providers, including Cisco, Extreme Networks, Fortinet, Microsoft, to name a few, in EMEA.

View More

Advanced Microsoft Access 2019

X

Contact Us

We would love to hear from you. Please complete this form to pre-book or request further information about our delivery options.

Subscribe

I'd like to receive emails with the latest updates and promotions from Insoft.

Data Protection & Privacy

I hereby allow Insoft Ltd. to contact me on this topic. Further, I authorise Insoft Ltd. processing, using collecting and storing my personal data for the purpose of these activities. All your data will be protected and secured as outlined in our privacy policy.


Advanced Microsoft Access 2019

Enroll Now
Advanced Microsoft Access 2019
Duration
2 Days
Delivery
(Online and onsite)
Price
Price Upon Request
This Advanced Access 2019 training class is for students who intend to design databases at an advanced level and/or want to improve existing Access 2019 or Access 365 databases.

Understand database relationships.

Work with table relationships.

Work with queries at an advanced level.

Work with forms at an advanced level..

Work with reports at an advanced level.

Work with macros.

Complete the desktop application with the navigation form.

Module 1: Relationships

This module explains how to work with relationships in Microsoft Access.

Lessons

  • Review
  • Referential Integrity
  • Relationships
  • A Few Words about Naming Conventions

Lab 1: Installing and Configuring Windows 7

  • Click here to enter text.

After completing this module, students will be able to:

Understand referential integrity.

Establish relationships between tables.

 

Module 2: Queries

This module explains how to work with queries in Microsoft Access.

Lessons

  • Query Design View
  • Review of Select Queries
  • Review of Select Queries with Criteria
  • Logical Operators
  • Parameter Queries
  • Action Queries

Lab 1: Queries Exercises

  • Cerating Select and Action Queries
  • Creating a Parameter Query

After completing this module, students will be able to:

Work with select and action queries.

Work with logical operators.

Create and run select, parameter, make table, append, update, and delete queries.

 

Module 3: Table Functions

This module explains how to work with table functions.

Lessons

  • Importing Data
  • Linking Tables from External Sources
  • Import Tables from Other Databases
  • Tables from Templates and Application Parts

Lab 1: Table Functions Exercises

  • Importing Data from Excel
  • Exporting Data to Excel

After completing this module, students will be able to:

Import data from Excel.

Export data to Excel.

 

Module 4: Forms

This module explains how to work with forms in Microsoft Access.

Lessons

  • Design View
  • Formatting
  • Tab Order
  • Create Forms with Application Parts
  • Creating a Subform
  • Alter a Form

Lab 1: Creating Forms

  • Click here to enter text.

After completing this module, students will be able to:

Understand the parts of a form.

Add objects to a form.

Add, move, format, and order fields on a form.

Understand controls available for forms.

Work with form properties, section properties

 

Module 5: Reports

This module explains how to work with reports in Microsoft Access.

Lessons

  • Design View
  • Report Sections
  • Arranging Fields on a Report
  • Resizing the Detail Section
  • Grouping and Sorting
  • Setting Properties on a Report
  • Special Report Fields
  • Controls
  • Subreports
  • Application Parts
  • Deleting a Report
  • Formatting a Report

Lab 1: Creating Reports

  • Click here to enter text.

After completing this module, students will be able to:

Create and format Access reports.

Work with the various sections of a report.

Group, sort, and add totals for records on a report.

Work with the Expression Builder.

Work with property sheets.

 

Module 6: Macros

This module explains how to work with macros in Microosft Access.

Lessons

  • Macro Basics
  • Running a Macro

Lab 1: Creating Simple Macros

  • Click here to enter text.

After completing this module, students will be able to:

Create several simple macros.

Run macros.

 

Module 7: Completing the Desktop Application

This module explains how to complete the desktop application in Microsoft Access.

Lessons

  • The Navigation Form
  • Running Macros from a Navigation Form
  • Setting the Navigation Form as the Default Form
  • Splitting the Database
  • Distributing the Front-end Database
  • Database Maintenance

Lab 1: Creating a Navigation Form

  • Click here to enter text.

After completing this module, students will be able to:

Create navigation forms.

Split an Access database into front-end and back-end databases.

Distribute an Access database front end to your users.

This course is intended for students who have basic skills with Microsoft Access 2019 who want to learn advanced-level skills or students who want to learn the topics covered in this course in the 2019 interface.

  • Introductory-level knowledge and skills working with Microsoft Access.
This Advanced Access 2019 training class is for students who intend to design databases at an advanced level and/or want to improve existing Access 2019 or Access 365 databases.

Understand database relationships.

Work with table relationships.

Work with queries at an advanced level.

Work with forms at an advanced level..

Work with reports at an advanced level.

Work with macros.

Complete the desktop application with the navigation form.

Module 1: Relationships

This module explains how to work with relationships in Microsoft Access.

Lessons

  • Review
  • Referential Integrity
  • Relationships
  • A Few Words about Naming Conventions

Lab 1: Installing and Configuring Windows 7

  • Click here to enter text.

After completing this module, students will be able to:

Understand referential integrity.

Establish relationships between tables.

 

Module 2: Queries

This module explains how to work with queries in Microsoft Access.

Lessons

  • Query Design View
  • Review of Select Queries
  • Review of Select Queries with Criteria
  • Logical Operators
  • Parameter Queries
  • Action Queries

Lab 1: Queries Exercises

  • Cerating Select and Action Queries
  • Creating a Parameter Query

After completing this module, students will be able to:

Work with select and action queries.

Work with logical operators.

Create and run select, parameter, make table, append, update, and delete queries.

 

Module 3: Table Functions

This module explains how to work with table functions.

Lessons

  • Importing Data
  • Linking Tables from External Sources
  • Import Tables from Other Databases
  • Tables from Templates and Application Parts

Lab 1: Table Functions Exercises

  • Importing Data from Excel
  • Exporting Data to Excel

After completing this module, students will be able to:

Import data from Excel.

Export data to Excel.

 

Module 4: Forms

This module explains how to work with forms in Microsoft Access.

Lessons

  • Design View
  • Formatting
  • Tab Order
  • Create Forms with Application Parts
  • Creating a Subform
  • Alter a Form

Lab 1: Creating Forms

  • Click here to enter text.

After completing this module, students will be able to:

Understand the parts of a form.

Add objects to a form.

Add, move, format, and order fields on a form.

Understand controls available for forms.

Work with form properties, section properties

 

Module 5: Reports

This module explains how to work with reports in Microsoft Access.

Lessons

  • Design View
  • Report Sections
  • Arranging Fields on a Report
  • Resizing the Detail Section
  • Grouping and Sorting
  • Setting Properties on a Report
  • Special Report Fields
  • Controls
  • Subreports
  • Application Parts
  • Deleting a Report
  • Formatting a Report

Lab 1: Creating Reports

  • Click here to enter text.

After completing this module, students will be able to:

Create and format Access reports.

Work with the various sections of a report.

Group, sort, and add totals for records on a report.

Work with the Expression Builder.

Work with property sheets.

 

Module 6: Macros

This module explains how to work with macros in Microosft Access.

Lessons

  • Macro Basics
  • Running a Macro

Lab 1: Creating Simple Macros

  • Click here to enter text.

After completing this module, students will be able to:

Create several simple macros.

Run macros.

 

Module 7: Completing the Desktop Application

This module explains how to complete the desktop application in Microsoft Access.

Lessons

  • The Navigation Form
  • Running Macros from a Navigation Form
  • Setting the Navigation Form as the Default Form
  • Splitting the Database
  • Distributing the Front-end Database
  • Database Maintenance

Lab 1: Creating a Navigation Form

  • Click here to enter text.

After completing this module, students will be able to:

Create navigation forms.

Split an Access database into front-end and back-end databases.

Distribute an Access database front end to your users.

This course is intended for students who have basic skills with Microsoft Access 2019 who want to learn advanced-level skills or students who want to learn the topics covered in this course in the 2019 interface.

  • Introductory-level knowledge and skills working with Microsoft Access.
    Upcoming Dates
  • ` Feb 13 - Feb 14, 2023
  • ` Mar 13 - Mar 14, 2023
  • ` Apr 10 - Apr 11, 2023
  • ` May 8 - May 9, 2023
  • ` Jun 5 - Jun 6, 2023
  • ` Jul 3 - Jul 4, 2023