Training Series Overview
This training series builds on the skills and concepts taught in Access 2010: Basic. Students will learn about relational databases, related tables, complex queries, advanced form design, reports and printing, charts, and PivotTables and PivotCharts.
Series Taught By:
Drew Fierst
Available CEUs for Course Series Completion: 6
Students can earn up to 6 CEUs for fully completing this course series. This information will
be displayed on the certificate of completion.
Learn More
Access Training Courses Below
Click any of the titles below to launch your videos:
Course 01 - Relational DatabasesAccess Now - No Membership Required
39m
Topic A: Database Normalization
Demo 01 - Using the Table Analyzer
Demo 02 - Identifying Object Dependencies
Topic B: Table Relationships
Demo 01 - Establishing a One-to-One Table Relationship
Demo 02 - Establishing a One-to-Many Table Relationship
Demo 03 - Establishing a Many-to-Many Table Relationship
Demo 04 - Printing Table Relationships
Topic C: Referential Integrity
Demo 01 - Planning Table Relationships
Demo 02 - Working with Orphan Records
Demo 03 - Setting Cascading Deletes
Demo 04 - Testing Cascading Deletes
Demo 05 - Using Cascading Updates
Course 02 - Related Tables
23m
Topic A: Creating Lookup Fields
Demo 01 - Creating a Lookup Field
Demo 02 - Creating a Multivalued Lookup Field
Topic B: Modifying Lookup Fields
Demo 01 - Modifying Lookup Field Properties
Demo 02 - Changing a Text Box to a Combo Box
Topic C: Using Subdatasheets
Demo 01 - Using a Subdatasheet
Course 03 - Complex Queries
44m
Topic A: Joining Tables in Queries
Demo 01 - Creating a Query with the Simple Query Wizard
Demo 02 - Creating a Join in Design View
Demo 03 - Creating an Outer Join
Demo 04 - Creating a Join with an Intermediate Table
Demo 05 - Creating a Self-Join Query
Demo 06 - Finding Records that Do Not Match Between Tables
Demo 07 - Finding Duplicate Records
Demo 08 - Deleting Tables from a Query
Topic B: Using Calculated Fields
Demo 01 - Creating a Calculated Field
Demo 02 - Changing the Format of a Displayed Value
Demo 03 - Using the Expression Builder
Topic C: Summarizing and Grouping Values
Demo 01 - Creating a Query to Display Summary Values
Demo 02 - Using Queries to Concatenate Values
Course 04 - Advanced Form Design
36m
Topic A: Adding Unbound Controls
Demo 01 - Drawing a Rectangle Around a Control
Demo 02 - Changing the Tab Order
Demo 03 - Grouping Controls
Topic B: Adding Graphics
Demo 01 - Adding a Graphic to a Form
Demo 02 - Embedding a Graphic in an Unbound Object Frame
Topic C: Adding Calculated Values
Demo 01 - Binding a Control to a Calculated Field
Demo 02 - Creating a Calculated Control
Topic D: Adding Combo Boxes
Demo 01 - Adding a Combo Box to a Form
Demo 02 - Modifying the Properties of a Combo Box
Topic E: Advanced Form Types
Demo 01 - Creating a Multiple-Item Form
Demo 02 - Creating a Split Form
Demo 03 - Creating a Datasheet Form
Demo 04 - Creating a Subform
Course 05 - Reports and Printing
35m
Topic A: Customized Headers and Footers
Demo 01 - Adding a Report Header
Demo 02 - Adding a Report Footer
Demo 03 - Applying Conditional Formatting
Demo 04 - Keeping Parts of a Report on the Same Page
Demo 05 - Adding Controls to Group Footers
Demo 06 - Forcing a New Page
Topic B: Calculated Values
Demo 01 - Working with the DateDiff Function
Demo 02 - Using the IIf Function
Topic C: Printing
Demo 01 - Printing a Table
Demo 02 - Printing a Database Document
Topic D: Labels
Demo 01 - Creating Labels
Course 06 - Charts
15m
Topic A: Charts in Forms
Demo 01 - Creating a Chart in a Form
Demo 02 - Modifying a Chart in a Form
Topic B: Charts in Reports
Demo 01 - Adding a Chart to a Report
Demo 02 - Modifying Charts in Reports
Course 07 - PivotTables and PivotCharts
21m
Topic A: PivotTables
Demo 01 - Examining PivotTable View
Demo 02 - Adding Fields to a PivotTable
Topic B: Modifying PivotTables
Demo 01 - Creating Totals
Demo 02 - Moving Fields in a PivotTable
Demo 03 - Showing and Hiding Details in a PivotTable
Demo 04 - Formatting Fields
Topic C: PivotCharts
Demo 01 - Creating a PivotChart
Topic D: PivotTable Forms
Demo 01 - Creating a PivotTable Form
Training Final Exam
Are you ready to earn your certificate of completion? If so, Launch the Final Exam below to do so now!
|