Description

In this training program professionals get Introduction to Microsoft Access 2019 starts by covering fundamental database concepts. Professionals will then learn to design and create databases and tables, query those tables, and create forms and reports.

 

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

 

Duration: 2 days

 

Learning Objectives

After accomplishing this training program, professionals will be able to learn:

  • Gain an acknowledging of database concepts and terminology.
  • About the Access interface.
  • Work with table views, queries, forms, reports, and macros and lessons.
  • To plan a database.
  • Database design fundamentals.
  • To work with forms and the Form Wizard.
  • To work with reports and the Report Wizard.

Pre-requisite

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

 

Audience Profile

This training program is designed for professionals who have little or no knowledge of Microsoft Access 2019 or more experienced Access users who want to learn the topics covered in this training program in the 2019 interface.

Course Content

Lesson 1: Quick outline of the Access User Interface

This lesson describes 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: Getting Around the Access Environment

After accomplishing this lesson, professionals will be able to acknowledge:

  • The organization of the Access ribbon.
  • Context tabs in the ribbon.
  • The Quick Access Toolbar and how to customize.
  • The Navigation Pane.
  • The objects and creation process.
  • The Access work surface.

Acknowledge how to create databases using a wizard.

 

Lesson 2: Fundamentals

This lesson describes how to think about some database fundamentals before diving into database creation.

Lessons

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

Lab: Fundamentals Exercises

  • Asking Questions
  • Normalizing Data

After accomplishing this lesson, professionals will be able to:

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

 

Lesson 3: Tables and Their Views

This lesson describes how to work with tables and their views in Microsoft Access.

Lessons

  • Definition and Purpose
  • Datasheet View
  • Design View

Lab: Working with Tables in Datasheet View

After accomplishing this lesson, professionals will be able to:

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

 

Lesson 4: Tables

This lesson describes how to work with tables in Microsoft Access.

Lessons

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

Lab: Tables Exercises

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

After accomplishing this lesson, professionals will be able to:

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

 

Lesson 5: Queries

This lesson describes how to work with queries in Microsoft Access.

Lessons

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

Lab: Creating Select Queries

After accomplishing this lesson, professionals will be able to:

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

 

Lesson 6: Forms

This lesson describes 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: Forms Exercises

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

After accomplishing this lesson, professionals will be able to:

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

 

Lesson 7: Reports

This lesson describes how to work with reports in Microsoft Access.

Lessons

  • Reports
  • Report Wizard

Lab: Creating a Report with the Report Wizard

After accomplishing this lesson, professionals will be able to:

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

 

Additional Reading

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

  • N/A

 

FAQs

Q: Why is Microsoft Access so popular?

 

A: Largely Access databases are so popular because a skilled MS Access developer can make a wide range of software functionality in a far shorter timeframe as compare to any other development platform. Even a novice Access developer can easily make simple databases quickly.

 

Q: What are the limitations of Microsoft Access?

 

A: Limitations of MS Access are:-

  • Not Ideal for Web Solutions. Not for Non-Windows Platforms. 
  • Deployment Issues
  • Security and Data Integrity
  • Limited Scalability with its own Database Format 
  • Limited User Interface

 

Q: What’s new in MS Access 2019?


A: Improved logic for retrying connections to external data sources using ODBC connections. Microsoft have create the clickable areas around the borders of table objects in Query design windows so it is much easier to resize.

 

Q: What is the difference between an Access MDB and accdb?

 

A: MDB databases support user-level security while ACCDB doesn’t. The encryption in ACCDB database is stronger as compare to MDB. ACCDB allows various field types like as multi value fields, calculated fields, and attachment fields but MDB databases don’t have any facility like this.

 

Q: Is there any EMI option?

 

A: Yes, you can easily choose an EMI option through your credit card or Debit card.

 

Q: What is the mode of payment?

 

A: You can submit payment to Radiant by:

  • Debit or credit card
  • Bank transfer 
  • Google pay

 

Q: What is your refund policy? 

 

A: In case of Radiant Techlearning solutions cancel an event, 100% of course fee will be refunded to the participant. 

We provide best-in-class training programs to our clients with large number of services. Radiant also believe in taking feedback from its clients time to time. If you face any kind of difficulty you can freely discuss with us. However due to some reason if your expectations are not met. We do have refund policy in which Radiant will refund your payment within 7 days. To get the refund you have to inform us about your concern before 20% completion of the training program.

 

Q: What will be the fees of the course?

 

A: To know about the fees details you can email us on training@radianttechlearning.com with your requirement in details containing the below information 

In case of Self / Individual 

  • Training Program
    Training Mode (Online/ Classroom)
  • Location (in case of classroom):
  • Background (Education/ Technology/ Year of experience, etc. )
  • Training Timeline 

In case of Corporate Training

  • Training Program
  • No. of Participants
    Training Mode (Online/ Classroom)
  • Location (in case of classroom):
  • Participant’s Background (Education/ Technology/ Year of experience, etc. )
  • Training Timeline 
  • Expectations form the training program

 

Unble To Find a Batch..?

Request a Batch