Embedded Files
Assignments for Day One (December 14, 2020) - Please complete all Assignments, and Quiz in
the Microsoft Access 2016 Intermediate to Advance books.
Classroom:
Syllabus, Access 2016 Reference, Build a Database using exported Excel data (External Data Tab,
Import and Link, Import source Data into a new table, Add a primary key, Append a copy of the
records into a table, Link Access Database to Excel). Complex Relationships between Databases
(Referential Integrity, Design techniques for advanced links and table joins, Options for Auto join,
Time-dependent data). Microsoft Office 2016 Access Intermediate Guide Book (Chapter One
through Two Exercises only).
Lab:
Create a MS Access 2016 Database from the scratch.
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
Instructor's PowerPoint Example:
Please refer to Company PowerPoint show, at the bottom of the page
SharePoint Video:
Watch Instructional Video:
How to Create Tables Using Access
Review videos:
Make , Append , Update , Delete
Assignments for Day Two (December 15, 2020) - Please complete all Assignments, and Quiz in
the Microsoft Access 2016 Intermediate to Advanced books.
Classroom:
Syllabus Recall, Advanced Table Design (Create multiple tables, Change table-designs without compromising data integrity, Refining tables with hyperlink controls, indexes, and properties, Edit the properties of linked tables). Advanced Data Manipulation with Queries and Filters (Queries in multiple tables, Replace existing query data, 3 ways to create efficient table joins, Specify record criteria by group, aggregate, and non-aggregate total fields). Microsoft Office 2016 Access Intermediate Guide Book (Chapter Four Exercises only).
Lab:
Import Excel data information the Access database.
Homework:
Microsoft Office 2016 Access Advanced Guide Book (Chapter One Exercises only)
SharePoint Video:
Review videos:
Create Table Relationships , Crosstab , Parameter ,
Assignments for Day Three (December 16, 2020) - Please complete all Assignments, and Quiz in
the Microsoft Access 2016 Intermediate to Advanced books.
Classroom:
Syllabus Recap, Advanced Queries (Parameter, data definition, and union queries, Advanced
techniques for using forms, sub-forms, and reports, Create sub-forms with and without the wizard,
Tips for moving and resizing controls, Filter records within a form using complex criteria expressions, Actions that create a form for a sub-form, Export reports to dynamic or static HTML format). Expert macro techniques (Define macros as a group, troubleshooting procedures for macro errors, Add
actions and arguments to macros, Attaching a macro to controls forms, Set conditional expressions
to a macro). Microsoft Office 2016 Access Advance Guide Book (Chapter One through Two Exercises only).
Lab:
Utilize formulas, pivot tables and graphic charts to analyze data.
Homework:
Microsoft Office 2016 Access Advanced Guide Book (Chapter Three Exercises only)
SharePoint Video:
Review videos:
Duplicate , Sub Query , Create reports
Assignments for Day Four (December 17, 2020) - Please complete all Assignments, and Quiz in
the Microsoft Access 2016 Intermediate to Advanced books.
Classroom:
Syllabus Recap, Use of sub-forms (What are sub-forms? Creating the main form and sub-form using
the sub-form wizard, Using an existing form as a sub-form, nested sub-forms, Linking forms, Main form-sub form data relationships, The hyperlink control, Adding a hyperlink to a form, The Web browser control, The attachments in a form, The chart control, Specialized form types, About navigation form, Creating a navigation form, Modal dialog forms, Creating a database start-up form). Microsoft Office 2016 Access Advance Guide Book (Chapter Four Exercises only).
Lab:
Create a standard Naval letter format in Microsoft Word.
Homework:
None
SharePoint Video:
Review videos:
Assignments for Day Five (December 18, 2020) - Please complete all Assignments, and Quiz in
the Microsoft Access 2016 Intermediate to Advanced books.
Classroom:
Syllabus Recap, Multi-User Systems (Deploy page locking when multiple users access your
information, Setting defaults for multi-user systems, Refresh data access objects (DAO)
collections in a multi-user environment, Protect your database from outside tampering
and unauthorized alterations to information). Microsoft Office 2016 Access Advance Guide Book (Chapter Five Exercises only).
Lab:
Create PowerPoint slides for your respective business.
Homework:
None
SharePoint Video:
Project:
Team A - Create a Transportation business
Team B - Create a Supply business
Review videos:
Page updated
Google Sites
Report abuse