Skip to main content

Microsoft Access Core Productivity Online

ID : 76940   
« back to classes page
Our Microsoft Office Core Productivity online classes teach users the skills to be more productive when using these applications in their daily personal and business lives.  These classes are fully-interactive and self-paced.  Students will learn skills and new tips/tricks by actively engaging in the lessons and "learning by doing" rather than passively just watching videos.

Outline For Basic
1.1   Understand the Screen
1.2   Open and Save a Database
1.3   Work with Database Objects
1.4   Tour of Tables
1.5   Tour of Queries
1.6   Tour of Forms
1.7   Tour of Reports
1.8   Help
1.9   Close and Exit Access
2.1   Plan a Database
2.2   Create a Database
2.3   Add, Edit, and Delete Records
2.4   Select Data
2.5   Cut, Copy, and Paste Data
2.6   Use Undo and Redo
2.7   Check Spelling
2.8   Use the Zoom Box
2.9   Preview and Print
3.1   Find and Replace Data
3.2   Sort Records
3.3   Use Common Filters
3.4   Filter by Selection
3.5   Filter by Form
3.6   Create an Advanced Filter
3.7   Adjust Rows and Columns
3.8   Change Gridlines and Cell Effects
3.9   Freeze a Column
3.1  Hide a Column
4.1   Create a Table
4.2   Understand Field Types and Properties
4.3   Index a Field
4.4   Add a Primary Key and Auto-Increment Fields
4.5   Insert, Reorder, and Delete Fields
4.6   Add Field Descriptions and Captions
4.7   Change the Field Size
4.8   Format Number, Currency, and Date/Time Fields
4.9   Format Text Fields
4.1  Set a Default Value
4.11  Require Data Entry
4.12  Validate Data
4.13  Create an Input Mask
4.14  Create a Lookup Field
4.15  Create a Value List
4.16  Modify a Lookup List
4.17  Add Total Rows

Outline for Intermediate
1.1  Table Relationships and Relationship Types
1.2  Create Relationships Between Tables
1.3  Enforce Referential Integrity
1.4  Print and Delete Relationships
2.1  Create a Query
2.2  Hide, Remove, and Sort Fields
2.3  Use AND and OR Operators in a Query
2.4  Create a Multiple Table Query
2.5   Create a Calculated Field
2.6   Work with Expressions and the Expression Builder
2.7   Format Fields within Queries
2.8   Use an IIF Function
2.9   Summarize Groups of Records
2.10 Display Top or Bottom Values
2.11 Parameter Queries
2.12 Find Duplicate Records
2.13 Find Unmatched Records
2.14 Crosstab Queries
2.15 Delete Queries
2.16 Append Queries
2.17 Make-Table Queries
2.18 Update Queries
3.1   Create a Form with the Form Wizard
3.2   Create and Use a Form
3.3   Modify a Form in Layout View
3.4   Form Design View Basics
3.5   Change the Tab Order
3.6   Work with Control Properties
3.7   Work with Form Properties
3.8   Change a Controls Data Source
3.9   Create a Calculated Control
3.10 Change a Controls Default Value
3.11 Create a Subform
3.12 Work with and Modify Subforms
3.13 Create and Modify a Navigation Form
4.1  Create a Report
4.2  Use the Report Wizard
4.3  Use the Label Wizard
4.4  Work in Layout View
4.5  Format Fonts
4.6  Copy Formatting
4.7  Change Text Alignment
4.8  Insert a Logo and Background Image
4.9  Adjust Page Margin and Orientation
4.10 Add Page Numbers and Dates
4.11 Group and Sort
4.12 Summarize Data using Totals
4.13 Understand Report Sections
5.1   Use Conditional Formatting
5.2   Work with Number Formatting
5.3   Use Themes
5.4   Import Information
5.5   Export Information
5.6   Link External Information
5.7   Mail Merge Records to Word
5.8   Use Hyperlink Fields
5.9    Database Object Dependencies
5.10  Compact and Repair a Database
5.11  Convert an Access Database
5.12  Back Up and Restore a Database
5.13  Password Protect a Database
5.14 Split a Database



 

Class Details

77 Sessions
Online 24/7

Location
SPC D2L

Instructor
Dan Fumano 

Class Price: 

$99.00


Registration Closes On
Friday, July 26, 2019 @ 11:59 PM

Schedule Information

Date(s) Class Days Times Location Instructor(s)
5/11/2019 - 7/26/2019 Online 24/7 12:00 AM - 12:00 AM N/A - Online Dan Fumano