Microsoft Access
Price
₹ 3000
Duration
12 Weeks
About the Course
Microsoft Access 2019
01
Introduction:
Introduction
Steps to Open Microsoft Access 2019
Course Overview & Layout
02
TABLE Objects - The Basics
Creating Our First Table and Data Type PDF
Adding, Editing and Deleting Records
Using Primary Keys
Adding Auto numbers, Primary Keys and Restructuring Tables
Basic Table Sorting and Filtering
03
Report Objects
What do reports do?
Modifying the Report
Working with Controls, Report
Layout Views
04
QUERY Objects
Basic Queries
Query Criteria
Date Criteria and Between
Using OR in Criteria
Parameter Queries
05
PROPERTIES
Viewing Table Properties
Custom Formatting PDF
Field Validation and
Field Properties
Query Properties
Report Properties
06
FORM Objects
Creating a Form with the Wizard
Cleaning Up the Form
Working with Controls
More Form Clean-up - Moving Labels, Adding Rectangles
Font Color
Resize Header and Detail and Finish Form
07
Advanced TABLES
Using the Lookup Wizard
Setup Lookups Without the Wizard
Advanced Sorting and Filtering
Working with Related TABLES
08
Advanced QUERIES
Using TOP queries
Using TOTAL Queries
ACTION queries - UPDATE
ACTION queries - APPEND
Multi Table and MAKE TABLE ACTION Queries
ACTION queries - DELETE
Calculations in Queries and Formatting Results
A Parameter Query Trick
09
Advanced REPORTS
Reports based on the Parameter Query Trick
Calculations in Reports
Sorting with Reports
Adding an Order Month to Our Query
Subtotals in Reports
Label the Subtotals and Report Total
Conditional Formatting
Your Instructor
Yatendra Kumar Awana
7 year of Experience as Computer Instructor