Homework Assignments for Day One (March 22, 2021) - Please complete all Assignments,
Quiz and review the videos.
Read the following files listed below in class:
Access 2016 Quick Reference, MS Office Access 2016 Introduction
Course Booking Exercise (Chapter One - Chapter Two)
Read the following files for homework:
Access and other Apps 2007 version, Access 2010 parts, field properties
Lab exercise:
Create Address Book Database
Create Employee (Table, Query, Form, Report and Two Macros)
Create Department (Table, Query, Form, Report and Two Macros)
Instructor's class project videos:
Create Address Book Database Tables (Employee, Department, Import Inventory) ,
Create Address Book Database Queries (Employee, Department, Inventory) ,
Watch video for PowerPoint presentation:
Review videos:
Create tables , Forms , import information
Assignments for Day Two (March 23, 2021) - Please complete all Assignments, and Quiz in the
Microsoft Access 2016 Intermediate book chapters (1 and 2 only).
Read the following files listed below in class:
MS Office Access 2016 Intermediate Course Booking Exercises
(Chapter One - Chapter Two)
Read the following files for homework:
Querys Part I, Querys Part II
Lab exercise:
Import Inventory Worksheet in the Address Book Database
Modify Inventory Table after Importing into Database
Create Inventory (Query, Form, Report and Two Macros)
Instructor's class project videos:
Create Address Book Database Forms (Employee, Department, Inventory) ,
Create Address Book Database Reports (Department, Employee, Inventory)
Create Address Book Database Macros (Department, Employee, Inventory)
Review videos:
Assignments for Day Three (March 24, 2021) - Please complete all Assignments, and Quiz in the Microsoft Access 2016 Introduction book chapters (1 and 2) only.
Read the following files listed below in class:
What's New, Syllabus, Excel Environment, Explorer Ribbon, New Features,
Keyboard shortcuts, Excel reference
Read the following files for homework:
Excel 2010 Solid Enhancement, 10 Ways to show off your data,
Spark lines work sheet, Protecting cells step-by-step
Lab exercise:
Create Address book, Create Home Budget, Create Inventory,
MS Office Excel 2016 Introduction Course Booking,
Exercise (Chapters One - Chapter Two)
Instructor's class project videos:
Create Address Book , Create Home Budget , Create Inventory
Watch the videos:
Excel 2016 Introduction Tutorial
Homework Assignments for Day Four (March 25, 2021) - Please complete all Assignments,
Quiz and review the videos.
Read the following files listed below in class:
Subtotal Evaluation Values, and Auto format
Read the following files for homework:
Conditional Formatting Rows, and Customize Conditional formatting Exercise
Lab exercise:
Create Text to Column, Create Equipment Lists, Create Company Balanced
Budget worksheets, Exercise Form Code Parts, MS Office Excel 2016 Intermediate Course Booking Exercise (Chapter One - Chapter Two)
Instructor's class project videos:
Create Text to Column , Create Equipment List , Company Balanced Budget Part One ,
Company Balanced Budget Part Two , Company Balanced Budget Part Three ,
Company Balanced Budget Part Four , Company Balanced Budget Part Five
Watch the videos:
Data Validation , VLOOKUP Tutorial, HLookup Examples , Goal Seek and Scenario Manager
Assignments for Day Five (March 26, 2021) - Please complete all Assignments, and Quiz in the
Microsoft Access 2016 Intermediate book chapters (3 - 4).
Read the following files listed below in class:
MS Office Access 2016 Intermediate Course Booking Exercises
(Chapter Three - Chapter Four)
Read the following files for homework:
None
Lab exercise:
Group A Create PowerPoint slides for a Motor Transport company
Group B Create PowerPoint slides for a Supply company
Instructor's project example:
Instructor's Company PowerPoint Presentation
Review videos:
PowerPoint , Reports , Macros