Access 2013: Intermediate

Ready to move on to more difficult Access 2013 topics, like filters, queries, forms, and reports? This Access 2013 Intermediate course is for you.

Learn by Doing! Michael Jordan didn't become an NBA star by watching basketball on TV; this course is completely interactive - it recreates the experience of actually using Microsoft Access 2013! Each bite-size lesson also includes a step-by-step illustrated courseware reference.

CustomGuide is used by thousands of the world’s most demanding organizations, including Harvard University, Facebook, and the U.S. Senate.

Software Skills Training

DigitalChalk Perform

$40.00

 
COURSE OUTLINE

DURATION
  Creating Relational Databases
 
  Table Relationships and Relationship Types 3:09
  Create Relationships Between Tables 3:03
  Enforce Referential Integrity 4:27
  Print and Delete Relationships 2:20
  Working with Queries
 
  Create a Query 2:34
  Sort a Query 2:59
  Use AND and OR operators in a Query 2:09
  Create a Multiple Table Query 3:29
  Create a Calculated Field 2:07
  Work with Expressions and the Expression Builder 3:35
  Use an IIF Function 3:45
  Summarize Groups of Records 3:20
  Display Top or Bottom Values 2:33
  Parameter Queries 2:54
  Find Duplicate Records 2:00
  Find Unmatched Records 2:16
  Crosstab Queries 2:33
  Delete Queries 3:41
  Append Queries 3:57
  Make-Table Queries 3:35
  Update Queries 2:41
  Working with Forms
 
  Create a Form with the Form Wizard 1:54
  Create and Use a Form 1:47
  Modify a Form in Layout View 2:18
  Form Design View Basics 3:04
  Change the Tab Order 1:33
  Work with Control Properties 1:06
  Work with Form Properties 1:42
  Change a Control's Data Source 1:48
  Create a Calculated Control 2:10
  Change a Control's Default Value 1:19
  Create a Subform 3:12
  Work with and Modify Subforms 2:00
  Working with Reports
 
  Create a Report 1:18
  Use the Report Wizard 2:25
  Use the Label Wizard 2:23
  Work in Layout View 2:36
  Format Fonts 1:47
  Copy Formatting 1:07
  Change Text Alignment 0:38
  Insert a Logo 0:42
  Adjust Page Margin and Orientation 1:47
  Add Page Numbers and Dates 2:07
  Group and Sort 1:48
  Summarize Data using Totals 0:49
  Understand Report Sections 2:27
  Advanced Topics
 
  Use Conditional Formatting 2:18
  Work with Number Formatting 1:44
  Use Themes 1:27
  Import Information 2:59
  Export Information 1:49
  Link External Information 1:23
  Mail Merge Records to Word 1:27
  Use Hyperlink Fields 2:57
  Database Object Dependencies 1:49
  Compact and Repair a Database 2:53
  Convert an Access Database 1:23

 

REQUIREMENTS:

Desktop:

A browser that supports either HTML5 or Adobe Flash. Third party cookies must be enabled. For an optimal experience the screen resolution should be at least 1024x640 pixels.

Mobile:

Works on tablet devices.

Instructor
CustomGuide