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

Introduction to 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.


Introduction to Microsoft Access 2019

Enroll Now
Introduction to Microsoft Access 2019
Duration
2 Days
Delivery
(Online and onsite)
Price
Price Upon Request
This Introduction to Microsoft Access 2019 training class starts by covering basic database concepts. Students will then learn to design and create databases and tables, query those tables, and create forms and reports.
  • Gain an understanding of database concepts and terminology.
  • Learn about the Access interface.
  • Learn to work with table views, queries, forms, reports, and macros and modules.
  • Learn to plan a database.
  • Learn database design fundamentals.
  • Learn to work with forms and the Form Wizard.
  • Learn to work with reports and the Report Wizard.

Module 1: Quick Overview of the Access User Interface

This module explains how to become familiar with the Access user interface.

Lessons

  • Access Ribbon
  • Quick Access Toolbar
  • Object Navigation Pane
  • Access Work Surface
  • Object Overview
  • Process Overview
  • Create a Database Using a Wizard

Lab 1: Getting Around the Access Environment

  • Getting Around the Access Environment

After completing this module, students will be able to:

  • Understand the organization of the Access ribbon.
  • Understand context tabs in the ribbon.
  • Understand the Quick Access Toolbar and how to customize.
  • Understand the Navigation Pane.
  • Understand the objects and creation process.
  • Understand the Access work surface.
  • Understand how to create databases using a wizard.

 

Module 2: Fundamentals

This module explains how to think about some database fundamentals before diving into database creation.

Lessons

  • Questions to Ask Before You Starat
  • Approaches to Database Design
  • Gathering Information
  • A Few Words about Naming Conventions
  • Normalization
  • Table Relationships

Lab 1: Fundamentals Exercises

  • Asking Questions
  • Normalizing Data

After completing this module, students will be able to:

  • Ask questions to consider before you create a database application.
  • Understand common approaches to database design: top-down and bottom-up.
  • Go from paperwork and data samples to categorized data (data mapping).
  • Understand naming conventions for tables and other objects.
  • Understand what normalization is.
  • Understand some basic concepts of normalization and how to apply them.
  • Understandbout primary and foreign keys.
  • Understand relationships and establishing them among tables.

 

Module 3: Tables and Their Views

This module explains how to work with tables and their views in Microsoft Access.

Lessons

  • Definition and Purpose
  • Datasheet View
  • Design View

Lab 1: Working with Tables in Datasheet View

  • Working with Tables in Datasheet View

After completing this module, students will be able to:

  • Understand tables and table views in Access.
  • Work with tables in Datasheet view.
  • Add and Edit data records in Datasheet view.
  • Understand the purpose of Design view.

 

Module 4: Tables

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

Lessons

  • Creating an Access Database
  • Data Types
  • Create a Table in Design View

Lab 1: Tables Exercises

  • Creating a New Database
  • Determining Data Types
  • Creating a Table in Design View

After completing this module, students will be able to:

  • Creat an Access database.
  • Create a table in Design view.
  • Understand data types.
  • Assign a key field.
  • Understand input masks.
  • Use expressions to define validation rules.

 

Module 5: Queries

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

Lessons

  • Queries
  • Select Queries
  • Select Queries with Criteria
  • Logical Operators
  • Group and Total with Queries

Lab 1: Creating Select Queries

  • Creating Select Queries

After completing this module, students will be able to:

  • Use queries and query views.
  • Create a simple query.

 

Module 6: Forms

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

Lessons

  • Forms
  • Alter a Form
  • Form Record Navigation
  • Layout View and Design View
  • One-click Forms
  • Form Wizard

Lab 1: Forms Exercises

  • Adding Data Records in Form View
  • Creating a Form with the Form Wizard

After completing this module, students will be able to:

  • Understand types of forms.
  • Add records using a form.
  • Understand one-click forms.
  • Create a form using the Form Wizard.

 

Module 7: Reports

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

Lessons

  • Reports
  • Report Wizard

Lab 1: Creating a Report with the Report Wizard

  • Creating a Report with the Report Wizard

After completing this module, students will be able to:

  • Understand reports.
  • Use the one-click report.
  • Use the Report Wizard to create reports.

This course is intended for students who have little or no familiarity with Microsoft Access 2019 or more experienced Access users who want to learn the topics covered in this course in the 2019 interface.

  • Familiarity with using a personal computer, mouse, and keyboard.
  • Comfortable in the Windows environment.
  • Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.
This Introduction to Microsoft Access 2019 training class starts by covering basic database concepts. Students will then learn to design and create databases and tables, query those tables, and create forms and reports.
  • Gain an understanding of database concepts and terminology.
  • Learn about the Access interface.
  • Learn to work with table views, queries, forms, reports, and macros and modules.
  • Learn to plan a database.
  • Learn database design fundamentals.
  • Learn to work with forms and the Form Wizard.
  • Learn to work with reports and the Report Wizard.

Module 1: Quick Overview of the Access User Interface

This module explains how to become familiar with the Access user interface.

Lessons

  • Access Ribbon
  • Quick Access Toolbar
  • Object Navigation Pane
  • Access Work Surface
  • Object Overview
  • Process Overview
  • Create a Database Using a Wizard

Lab 1: Getting Around the Access Environment

  • Getting Around the Access Environment

After completing this module, students will be able to:

  • Understand the organization of the Access ribbon.
  • Understand context tabs in the ribbon.
  • Understand the Quick Access Toolbar and how to customize.
  • Understand the Navigation Pane.
  • Understand the objects and creation process.
  • Understand the Access work surface.
  • Understand how to create databases using a wizard.

 

Module 2: Fundamentals

This module explains how to think about some database fundamentals before diving into database creation.

Lessons

  • Questions to Ask Before You Starat
  • Approaches to Database Design
  • Gathering Information
  • A Few Words about Naming Conventions
  • Normalization
  • Table Relationships

Lab 1: Fundamentals Exercises

  • Asking Questions
  • Normalizing Data

After completing this module, students will be able to:

  • Ask questions to consider before you create a database application.
  • Understand common approaches to database design: top-down and bottom-up.
  • Go from paperwork and data samples to categorized data (data mapping).
  • Understand naming conventions for tables and other objects.
  • Understand what normalization is.
  • Understand some basic concepts of normalization and how to apply them.
  • Understandbout primary and foreign keys.
  • Understand relationships and establishing them among tables.

 

Module 3: Tables and Their Views

This module explains how to work with tables and their views in Microsoft Access.

Lessons

  • Definition and Purpose
  • Datasheet View
  • Design View

Lab 1: Working with Tables in Datasheet View

  • Working with Tables in Datasheet View

After completing this module, students will be able to:

  • Understand tables and table views in Access.
  • Work with tables in Datasheet view.
  • Add and Edit data records in Datasheet view.
  • Understand the purpose of Design view.

 

Module 4: Tables

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

Lessons

  • Creating an Access Database
  • Data Types
  • Create a Table in Design View

Lab 1: Tables Exercises

  • Creating a New Database
  • Determining Data Types
  • Creating a Table in Design View

After completing this module, students will be able to:

  • Creat an Access database.
  • Create a table in Design view.
  • Understand data types.
  • Assign a key field.
  • Understand input masks.
  • Use expressions to define validation rules.

 

Module 5: Queries

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

Lessons

  • Queries
  • Select Queries
  • Select Queries with Criteria
  • Logical Operators
  • Group and Total with Queries

Lab 1: Creating Select Queries

  • Creating Select Queries

After completing this module, students will be able to:

  • Use queries and query views.
  • Create a simple query.

 

Module 6: Forms

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

Lessons

  • Forms
  • Alter a Form
  • Form Record Navigation
  • Layout View and Design View
  • One-click Forms
  • Form Wizard

Lab 1: Forms Exercises

  • Adding Data Records in Form View
  • Creating a Form with the Form Wizard

After completing this module, students will be able to:

  • Understand types of forms.
  • Add records using a form.
  • Understand one-click forms.
  • Create a form using the Form Wizard.

 

Module 7: Reports

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

Lessons

  • Reports
  • Report Wizard

Lab 1: Creating a Report with the Report Wizard

  • Creating a Report with the Report Wizard

After completing this module, students will be able to:

  • Understand reports.
  • Use the one-click report.
  • Use the Report Wizard to create reports.

This course is intended for students who have little or no familiarity with Microsoft Access 2019 or more experienced Access users who want to learn the topics covered in this course in the 2019 interface.

  • Familiarity with using a personal computer, mouse, and keyboard.
  • Comfortable in the Windows environment.
  • Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.
    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