Assignments for Day One (July 19, 2021) - Please complete all Assignments, and Quiz in
the Microsoft Access 2016 Intermediate book.
Classroom:
Syllabus, Access 2016 Reference, Microsoft Office 2016 Access Intermediate Guide Book (Chapter One through Two Exercises only)
Lab:
Create a Employee database (equipment, personnel and department table; need to show a relationship,
create several queries), Create a Customer database (orders table).
Homework:
Microsoft Office 2016 Access Intermediate Guide Book (Chapter Three Exercises only)
10_db_design_mistakes, 10_reasons_access, 10_reasons_access_web, 10_things_access_before_building_db, 10_things_access_query_design
Planning for Final Project:
As a reminder each group is required to do advanced research on their respective project. Information on your project should include at least fifteen (15) PowerPoint slides (equipment
inventory, organization charts, company graphs, employee work schedule, company budgeting worksheets, business history, feedback letters, company map and location, company business
plan, employee duties and responsibilities, sound recording, video, pictures, etc.)
Instructor's PowerPoint Example:
Please refer to Company PowerPoint show, at the bottom of the page
Watch Instructional Video:
How to Create Tables Using Access
Review videos:
Assignments for Day Two (July 20, 2021) - Please complete all Assignments, and Quiz in
the Microsoft Access 2016 Intermediate and Advance book.
Classroom:
Microsoft Office 2016 Access Intermediate Guide Book (Chapter Four Exercises only)
Microsoft Office 2016 Access Advance Guide Book (Chapter One Exercises only)
Lab:
Create a Achieve database (Equipment Achieve table)
Homework:
Microsoft Office 2016 Access Advanced Guide Book (Chapter Two Exercises only)
Watch Instructional Video:
Review videos:
Assignments for Day Three (July 21, 2021) - Please complete all Assignments, and Quiz in
the Microsoft Access 2016 Advance book.
Classroom:
Microsoft Office 2016 Access Advance Guide Book (Chapter Three only)
Lab:
Create a Achieve database (Equipment Achieve table)
Homework:
None
Review videos:
Assignments for Day Four (July 22, 2021) - Please complete all Assignments, and Quiz in
the Microsoft Access 2016 Advance book.
Classroom:
Microsoft Office 2016 Access Advance Guide Book (Chapter Four Exercises only)
Lab:
None
Homework:
None
Review videos:
Assignments for Day Five (July 23, 2021) - Please complete all Assignments, and Quiz in
the Microsoft Access 2016 Advance book.
Classroom:
Microsoft Office 2016 Access Advance Guide Book (Chapter Five Exercises only)
Lab:
None
Homework:
None
Project:
As a reminder each group is required to do advanced research on their respective project. Information on your project should include at least fifteen (15) PowerPoint slides (equipment
inventory, organization charts, company graphs, employee work schedule, company budgeting worksheets, business history, feedback letters, company map and location, company business
plan, employee duties and responsibilities, sound recording, video, pictures, etc.)
Group A - create a Supply Business
Group B - create a Transportation Business
Review videos: