Description

This training program of Advanced Access 2019 is for professionals who intend to design databases at an advanced level and/or want to improve existing Access 2019 or Access 365 databases.

 

Radiant Teachlearning offers Advanced Microsoft Access 2019 Training Program in Classroom and Virtual instructor Led/Online mode.

 

Duration: 2 days

 

Learning Objectives

After accomplishing this course, professionals will be able to:

  • Acknowledge 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.

Pre-requisite

  • Introductory-level knowledge and skills working with Microsoft Access.

 

Audience Profile

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

Course Content

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: Installing and Configuring Windows 7

After accomplishing this module, professionals will be able to:

  • Acknowledge 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: Queries Exercises

  • Creating Select and Action Queries
  • Creating a Parameter Query

After accomplishing this module, professionals 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: Table Functions Exercises

  • Importing Data from Excel
  • Exporting Data to Excel

After accomplishing this module, professionals 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: Creating Forms

After accomplishing this module, professionals will be able to:

  • Acknowledge the parts of a form.
  • Add objects to a form.
  • Add, move, format, and order fields on a form.
  • Acknowledge 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: Creating Reports

After accomplishing this module, professionals 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: Creating Simple Macros

After accomplishing this module, professionals will be able to:

  • Create several simple macros.
  • Run macros.

 

Module 7: Accomplishing 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: Creating a Navigation Form

After accomplishing this module, professionals 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.

 

Additional Reading

To help professionals prepare for this class, review the following resources:

  • N/A

 

FAQs

Q: How useful is Microsoft Access?

 

A: In general, Microsoft Access is an information management tool which mainly helps users to store information for reference, reporting, and analysis. Microsoft Access basically helps user to analyze big amounts of information, and manage related data more efficiently as compared to Microsoft Excel or other spreadsheet applications.

 

Q: How is Microsoft Access used in real life?

 

A: Database is needed in your daily life such as in workplace, business, etc. With database, there will not be errors again so that you can control the database well. Anyway, it is considered as one of the uses of Microsoft Access in real life that you have to know and need to practice.

 

Q: What can access do that excel Cannot?

 

A: Access can store X number of records, Excel can only store up to 65536 records on the same sheet without having to use a different set of columns or continue on with other worksheet(s).

 

Q: What is main object in Microsoft Access?

 

A: Databases in Access are composed of four objects: tables, queries, forms, and reports. Together, these objects mainly allow user to enter, store, analyze, as well as compile their  data however they want.

 

Q: What if I/we have doubts after attending your training program?

 

A: Radiant team of experts would be available on the email Support@radianttechlearning.com to answer your technical queries, even after the training program.

We also conduct a 3 – 4 hours online session after 2 weeks of the training program, to respond on your queries & project assigned to you.  

 

Q: If I face technical difficulty during the class what should I do?

 

A: Technical issues are unpredictable and might occur with you as well. Participants have to ensure that they have the system with required configuration with good internet speed to access online labs.  

If the problem still persists or you face any challenge during the class then you can report to us or your trainer. In that case Radiant would provide you the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption and NOT for distribution or any commercial use. 

 

Q: Does this training program include any project?

 

A: Yes, Radiant will provide you the most updated, high valued and relevant real time projects and case studies in each training program. 

We included projects in each training program from fundamental level to advance level so that you don’t have to face any difficulty in future. You will work on highly exciting projects and that will upgrade your skill, knowledge and industry experience.

 

Q: How the training will be delivered or conducted?

 

A: Radiant Techlearning offers customized training delivery solutions for individuals, teams and businesses depending upon what they require. Here is how we help each one through our diverse formats.

Dedicated Classroom Training program

Onsite: To meet the needs & expectations of our corporate clients all over the world, our expert will travel all the way to your location to deliver the training program at a premise of your choice & convenience. 

Offsite: Our client and Individual professionals across the world travel all the way to India to attend our classroom training sessions. We assist them in services like accommodation, Airport pick & drop, daily cab & Visa assistance. 

Public Batches: Corporates & Individual professionals across the world can nominate their employees or themselves in our classroom or online public batches. Our public batches would have limited number of participants to ensure individual attention. As the participants are from different background and companies, you learn from everyone’s experience. 

On-the-Job Learning: Our team of consultant would help you to execute end-to-end project and simultaneously learn the technology.  

 

Unble To Find a Batch..?

Request a Batch