Assignments for Day One (June 21, 2021) - Please complete all Assignments,
Quiz and review the videos.
Read the following files listed below in class:
Syllabus, Access reference, Microsoft Office Access 2016 (Introduction)
Guidebook (chapters one).
Class Introduction, Getting Started with Microsoft Access: (Orientation to Microsoft Access, Get Help in Microsoft Access, What is a Form?, What is a Query?, What is a Report?).
Creating and Working with a Database: (Planning a Database, Create a new Database, Create a Table, Modify a Table, Create a Query, Sorting a Query).
Read the following files for homework:
Design Mistakes, 10 Reason Access, 10 Reason Access Web, 10 Reason
Access Before Building, Field Properties.
Lab exercise:
Create Tables, Modify Tables, Create Queries, Sort Queries.
Review videos:
Assignments for Day Two (June 22, 2021) - Please complete all Assignments,
Quiz and review the videos.
Read the following files listed below in class:
Syllabus recap, Microsoft Office Access 2016 (Introduction) Guidebook
(chapters two - three)
Creating and Working with a Database (cont'd): (Using the AND and OR
Operators in a Query, Create a Form with the Form Wizard, Create a Report
with the Report Wizard, Create Mailing Labels with the Label Wizard,
Converting an Access Database).
Finding, Filtering and Formatting Data: (Find and Replace Data, Sorting Records,
Using Common Filters, Filter by Selection, Filter by Form, Create an Advanced
Filter, Adjust and Rearrange Rows and Columns, Change Gridline and Cell Effects, Freeze and Hide Columns).
Read the following files for homework:
10 Things Access Query Design, 10 Things Broken Access, 10 Things
Database Keep in Shape
Lab exercise:
Create Table Relationship, Create Crosstab Queries, Create Forms, Create Labels.
Review videos:
Assignments for Day Three (June 23, 2021) - Please complete all Assignments,
Quiz and review the videos.
Read the following files listed below in class:
Syllabus recap, Microsoft Office Access 2016 (Intermediate) Guidebook
(chapters one - two).
Working with Tables and Fields: (Field properties, Index a Field, Adding
a primary key to a Table, Formatting Number, Currency and Data / Time
Fields, Setting a default Value, Modify Table Data, Sort and Filter Records,
Requiring Data Entry, Validating Data, Input Mask, Create a Value List,
Create a Lookup List, Create a Value List, Modify a Lookup List).
Create a Relationship Database: (Table Relationships, Create Relationship
between Tables, Enforcing Referential Integrity, Understanding Relationship
Types).
Read the following files for homework:
10 Tips List Control, Adding your First Chart, Multiple Value Fields
Lab exercise:
Create Relationships to another table, Create Append Queries, Create Calculated Query, Create Delete Queries
Review videos:
Assignments for Day Four (June 24, 2021) - Please complete all Assignments,
Quiz and review the videos.
Read the following files listed below in class:
Syllabus recap, Microsoft Office Access 2016 (Intermediate) Guidebook (chapters three).
Querying a Database: (Understanding the different type of Queries, Create a
Multiple Table Query, Create a Calculated Field, Working with Expressions and
the Expression builders, Using the IIF Function, Summarizing Groups of Records, Display Top or Bottom Values, Parameter Queries, Finding Duplicate Records,
Finding Unmatched Records, Crosstab Queries, Append Queries, Make-Table
Queries, Update Queries).
Creating Forms: (Create a Form, Modify the Design of a Form, Changing Tab
Order, Working with Control Properties, Control Properties Reference, Working
with Form Properties, Changing a Control's Data Source, Creating a Calculated Control, Changing the Control's Default Value, Create a Sub-form, Modify
Sub-forms).
Read the following files for homework:
Query Part I, Query Part II
Lab exercise:
Create Queries: (Update, Parameters, Create Forms and Sub forms).
Review videos:
Assignments for Day Five (June 25, 2021) - Please complete all Assignments,
Quiz and review the videos.
Read the following files listed below in class:
Syllabus recap, Microsoft Office Access 2016 (Intermediate) Guidebook
(chapters four).
Generating Reports: (Create a Report, Add Controls to a Report, Enhance the Appearance of a Report, Using Conditional Formatting, Adding Pictures, Lines
and Gridlines, Number Formatting, Prepare a Report to Print).
Importing Information: (Exporting information, Linking information from a External Source, Using Hyperlink Fields, Display Database Object Dependencies, Setting a Password in Access, Compacting and Repairing a Database).
Designing a Relational Database: (Relational Database Design, Create a Table,
Create Table Relationships).
Read the following files for homework:
None
Lab exercise:
Create Reports, Create Macros, Create Table Relationships. and Create PowerPoint slides
Review videos: