Microsoft Access Relational Database Management

Course Curriculum

Chapter 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

Chapter 2: MODULE TWO – CREATING MICROSOFT ACCESS TABLES

Lecture 1: CREATING A TABLE FROM TEMPLATE

Lecture 2: CREATING TABLES (CUSTOMERS, ORDERS & PRODUCTS)

Lecture 3: CREATING AND DESIGNING THE CUSTOMERS TABLE

Lecture 4: CREATING AND DESIGNING THE ORDERS TABLE

Lecture 5: CREATING AND DESIGNING THE PRODUCTS TABLE

Lecture 6: ENTERING DATA INTO TABLES

Lecture 7: IMPORTING EXCEL FILES INTO ACCESS

Lecture 8: SETTING FIELD PROPERTIES ON IMPORTED TABLES

Lecture 9: SETTING VALIDATION RULES IN ACCESS

Lecture 10: SETTING UP VALIDATION RULES (CONTD..)

Lecture 11: CREATING INPUT MASK IN ACCESS

Lecture 12: CREATING LOOKUP VALUES IN ACCESS

Lecture 13: WORKING WITH GENERAL TOOLS IN TABLES

Chapter 3: MODULE THREE – CREATING QUERIES IN MICROSOFT ACCESS

Lecture 1: WORKING WITH QUERIES (PRESENTATION)

Lecture 2: WORKING WITH QUERIES (CUSTOMERS TABLE)

Lecture 3: WORKING WITH QUERIES (PRODUCTS TABLE)

Lecture 4: WORKING WITH QUERIES (BETWEEN, IN, OR) COMMANDS

Lecture 5: WORKING WITH QUERIES (LIKE AND NULL) COMMANDS

Lecture 6: QUERYING A CALCULATED FIELD

Lecture 7: QUERYING MULTIPLE TABLES (RELATIONSHIP)

Lecture 8: GROUPING DATA IN QUERIES

Lecture 9: WORKING WITH SEPARATE QUERIES

Lecture 10: WORKING WITH CALCULATED FIELD FROM QUERIES

Lecture 11: WORKING WITH CROSSTAB IN ACCESS QUERIES

Lecture 12: GROUPING DATA IN QUERIES

Lecture 13: GROUPING BY DATES IN ACCESS QUERIES (Part 1)

Lecture 14: GROUPING BY DATES IN ACCESS QUERIES (PART 2)

Lecture 15: RUNNING QUERIES USING SQL COMMANDS

Lecture 16: CREATING UNION QUERIES USING SQL COMMANDS IN ACCESS

Lecture 17: WORKING WITH MATHS AND TEXT FUNCTIONS IN ACCESS

Lecture 18: WORKING WITH DATES FUNCTIONS

Lecture 19: WORKING WITH AGGREGATE FUNCTIONS USING SQL COMMANDS

Lecture 20: WORKING WITH AGGREGATE FUNCTIONS (ACCESS ENVIRON)

Chapter 4: MODULE FOUR – WORKING WITH FORMS IN ACCESS

Lecture 1: WORKING WITH FORMS IN ACCESS

Lecture 2: WORKING WITH FORMS DESIGN VIEW (PART 1)

Lecture 3: WORKING WITH FORMS DESIGN VIEW (PART 2)

Lecture 4: FORMS DESIGN IN ACCESS (PART 3)

Lecture 5: WORKING WITH UNBOUND FORMS FIELD

Lecture 6: BOUNDING AN UNBOUND FIELD IN FORMS

Lecture 7: ADDING CONTROLS TO FORM OBJECT

Lecture 8: ADDING PASSPORT PHOTOS TO RECORDS

Lecture 9: TYPES OF FORM LAYOUTS IN MICROSOFT ACCESS

Lecture 10: INSERTING CHARTS INTO MICROSOFT ACCESS FORMS

Chapter 5: MODULE FIVE – WORKING WITH ACCESS REPORTS

Lecture 1: WORKING WITH REPORTS IN MICROSOFT ACCESS

Lecture 2: EXPORTING ACCESS REPORTS IN VARIOUS FORMATS

Lecture 3: MANAGING THE MICROSOFT ACCESS REPORTS

Lecture 4: CONCLUDING THE MICROSOFT ACCESS REPORT