Microsoft Access Relational Database Management

Handling Database Professionally

What you'll learn

The fundamentals of database design

Creating and managing tables, queries, and forms

Building robust relationships between data

Generating reports and visualizing data

Practical tips and real-world examples

Requirements

Basic data handling knowledge is required; basic knowledge of Microsoft Excel would be an advantage.

Description

Unlock the full potential of your data with our Mastering Microsoft Access course. This comprehensive program is designed to equip participants with the skills and knowledge needed to effectively manage, analyze, and visualize data using Microsoft Access, a powerful and versatile database management system. It is time to Dive into the world of data management excellence with this course. This intensive program is meticulously crafted to empower participants with the essential skills and knowledge required to proficiently navigate and harness the capabilities of Microsoft Access, a dynamic and versatile database management system.  Throughout the course, participants will explore the intricacies of database design and optimization, learning to construct tables with precision and establish relationships that enhance data organization. The querying and data retrieval modules delve into the art of SQL and Query Design, enabling participants to extract specific data and derive meaningful insights through calculations and aggregations.  Forms and user interface design take center stage as participants master the creation of user-friendly interfaces, implementing controls and validation to ensure data accuracy. The course also covers the art of report generation and data visualization, allowing participants to communicate insights effectively through customized layouts and visual elements.  By the conclusion of this course, participants will emerge equipped with the expertise to efficiently create, manage, and analyze databases using Microsoft Access. Whether you are a novice or an intermediate user, this course is tailored to provide a comprehensive understanding and mastery of Microsoft Access, unlocking the full potential of your data management endeavors.

Overview

Section 1: MODULE ONE - OVERVIEW OF MICROSOFT ACCESS

Lecture 1 INTRODUCING THE MICROSOFT ACCESS COURSE

Lecture 2 INTRODUCTION TO MICROSOFT ACCESS APPLICATION

Lecture 3 OVERVIEW OF MICROSOFT ACCESS (PART 1)

Lecture 4 OVERVIEW OF MICROSOFT ACCESS (PART 2)

Lecture 5 WORKING WITH TABLES IN MICROSOFT ACCESS

Lecture 6 CREATING A TABLE (PRACTICAL SESSION)

Lecture 7 TABLE FIELD PROPERTIES

Lecture 8 TABLE PROPERTIES AND CREATING TABLES

Lecture 9 WORKING WITH QUERIES IN ACCESS

Lecture 10 WORKING WITH FORMS IN ACCESS

Lecture 11 WORKING WITH REPORTS IN ACCESS

Lecture 12 WORKING WITH DATA TYPES

Lecture 13 WORKING WITH DATA TYPES (PRACTICAL)

Lecture 14 WORKING WITH TABLE RELATIONSHIP

Lecture 15 WORKING WITH PRIMARY AND FOREIGN KEYS

Section 2: MODULE TWO - CREATING MICROSOFT ACCESS TABLES

Lecture 16 CREATING A TABLE FROM TEMPLATE

Lecture 17 CREATING TABLES (CUSTOMERS, ORDERS & PRODUCTS)

Lecture 18 CREATING AND DESIGNING THE CUSTOMERS TABLE

Lecture 19 CREATING AND DESIGNING THE ORDERS TABLE

Lecture 20 CREATING AND DESIGNING THE PRODUCTS TABLE

Lecture 21 ENTERING DATA INTO TABLES

Lecture 22 IMPORTING EXCEL FILES INTO ACCESS

Lecture 23 SETTING FIELD PROPERTIES ON IMPORTED TABLES

Lecture 24 SETTING VALIDATION RULES IN ACCESS

Lecture 25 SETTING UP VALIDATION RULES (CONTD..)

Lecture 26 CREATING INPUT MASK IN ACCESS

Lecture 27 CREATING LOOKUP VALUES IN ACCESS

Lecture 28 WORKING WITH GENERAL TOOLS IN TABLES

Section 3: MODULE THREE - CREATING QUERIES IN MICROSOFT ACCESS

Lecture 29 WORKING WITH QUERIES (PRESENTATION)

Lecture 30 WORKING WITH QUERIES (CUSTOMERS TABLE)

Lecture 31 WORKING WITH QUERIES (PRODUCTS TABLE)

Lecture 32 WORKING WITH QUERIES (BETWEEN, IN, OR) COMMANDS

Lecture 33 WORKING WITH QUERIES (LIKE AND NULL) COMMANDS

Lecture 34 QUERYING A CALCULATED FIELD

Lecture 35 QUERYING MULTIPLE TABLES (RELATIONSHIP)

Lecture 36 GROUPING DATA IN QUERIES

Lecture 37 WORKING WITH SEPARATE QUERIES

Lecture 38 WORKING WITH CALCULATED FIELD FROM QUERIES

Lecture 39 WORKING WITH CROSSTAB IN ACCESS QUERIES

Lecture 40 GROUPING DATA IN QUERIES

Lecture 41 GROUPING BY DATES IN ACCESS QUERIES (Part 1)

Lecture 42 GROUPING BY DATES IN ACCESS QUERIES (PART 2)

Lecture 43 RUNNING QUERIES USING SQL COMMANDS

Lecture 44 CREATING UNION QUERIES USING SQL COMMANDS IN ACCESS

Lecture 45 WORKING WITH MATHS AND TEXT FUNCTIONS IN ACCESS

Lecture 46 WORKING WITH DATES FUNCTIONS

Lecture 47 WORKING WITH AGGREGATE FUNCTIONS USING SQL COMMANDS

Lecture 48 WORKING WITH AGGREGATE FUNCTIONS (ACCESS ENVIRON)

Section 4: MODULE FOUR - WORKING WITH FORMS IN ACCESS

Lecture 49 WORKING WITH FORMS IN ACCESS

Lecture 50 WORKING WITH FORMS DESIGN VIEW (PART 1)

Lecture 51 WORKING WITH FORMS DESIGN VIEW (PART 2)

Lecture 52 FORMS DESIGN IN ACCESS (PART 3)

Lecture 53 WORKING WITH UNBOUND FORMS FIELD

Lecture 54 BOUNDING AN UNBOUND FIELD IN FORMS

Lecture 55 ADDING CONTROLS TO FORM OBJECT

Lecture 56 ADDING PASSPORT PHOTOS TO RECORDS

Lecture 57 TYPES OF FORM LAYOUTS IN MICROSOFT ACCESS

Lecture 58 INSERTING CHARTS INTO MICROSOFT ACCESS FORMS

Section 5: MODULE FIVE - WORKING WITH ACCESS REPORTS

Lecture 59 WORKING WITH REPORTS IN MICROSOFT ACCESS

Lecture 60 EXPORTING ACCESS REPORTS IN VARIOUS FORMATS

Lecture 61 MANAGING THE MICROSOFT ACCESS REPORTS

Lecture 62 CONCLUDING THE MICROSOFT ACCESS REPORT

Data Analyst, Spreadsheet analyst, financial analyst, data entry personnel, database management specialist, and all those who are interested in learning how to handle and manage large dataset.