Spindustry News

Azure For IT Professionals

Learn more about implementing Azure as part of your infrastructure.

Staying Sharp on Microsoft Office Can Save Time & Money

Learning the latest Microsoft Office tips and tricks can benefit you greatly.

"How do I determine if this new technology is for real?"

Michael Bird explains how to navigate new technology waters.
Training partners

Spindustry Training

spindustrytraining.com - (515) 334-9556

Bookmark and Share

Microsoft Office Access 2013: Level 2

Course Code: FC2-AC2013
Length: 1 Day
Tuition: $179.00

Schedule for this Course

There are no dates scheduled for this course.
If you would like to be added to the wait list for this class Click Here

Course Description:

Your training and experience using Microsoft® Access® 2013 has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2013 will result in a robust, functional database for your users.

You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Access 2013.

Target Student:

This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.

Prerequisites

To ensure your success in your course you should have experience working with Microsoft Access 2013, including a working knowledge of database design and creation, form design and creation, report design and creation, a working knowledge of database querying and the various table relationships. You can obtain this level of skill and knowledge by taking the following courses:

  • Microsoft® Office Access® 2013: Level 1

Course Outline:

ACCESS 2013 LESSON 1: USING REPORTS TO DISPLAY INFORMATION

  • Designing Reports
    • Report Essentials
    • Identifying Report Design Tools
  • Creating Reports Based on Multiple Tables
    • Creating a Report Using the Report Wizard
  • Modifying a Report
    • Working with Report Controls
    • Adding and Deleting Controls
    • Adding a Logo to the Report
    • Adding a Title or Subtitle to a Report
    • Using the Property Sheet
    • Formatting Controls
    • Applying Themes
  • Exploring Other Report Tools
    • Adding Report Sorting and Grouping Levels
    • Adding Date and Time Data to a Report
    • Adding Page Breaks to a Report
  • Printing Reports
    • Setting Report Print Layout
    • Controlling Page Breaks

ACCESS 2013 LESSON 2: REFINING TABLE DESIGN

  • Creating and Modifying Relationships
    • Relationship Types
    • Adding, Deleting, and Modifying Relationships
    • Editing Relationships
  • Modifying Table Structures
    • Renaming Tables and Editing, Adding, and Deleting Table Fields
  • Formatting a Table Datasheet Layout
    • Changing the Width of Columns
    • Moving and Hiding Data Columns
    • Saving a Table Layout
    • Enhancing a Datasheet
  • Setting Field Properties
    • Why Set Field Properties?
    • Set Field Sizes, Captions, and Default Values
    • Custom Text and Memo Field Formats
    • Short Text and Long Text Field Unique Properties
    • Entering Field Properties
    • Formatting Data Using Input Masks
    • Setting Validation Rules
  • Setting Lookup Fields With the Lookup Wizard
    • Examining the Benefits of Lookup Tables
    • Performing a Lookup
    • Creating Lookup Fields for Multiple Values

ACCESS 2013 LESSON 3: CUSTOMIZING INPUT FORMS

  • Identifying Complex Form Features
  • Creating a Main Form with a Subform
    • Removing the Layout
    • Connecting Related Tables in Forms
    • Creating a Form with a Subform
    • Identifying the Subform Data Source
    • Formatting the Form and Subform
  • Adding Calculations to Forms
    • Applying Totals to Forms in Datasheet View
    • Creating Calculated Controls
    • Totaling Calculated Subform Fields on a Form
    • Using the Expression Builder
    • Adding the Current Date to a Form

ACCESS 2013 LESSON 4: CREATING COMPLEX QUERIES

  • Identifying Advanced Query Features
    • Querying Tables Containing No Relationships
  • Creating Select Queries
  • Creating a Calculated Field in a Query
    • Identifying Features of a Calculated Field
    • Adding Totals to Datasheets
    • Creating a Multi-Table Report Based on a Query
  • Creating and Running Parameter Queries
    • Setting Up a Parameter Query
    • Formatting the Criteria Expression
    • Creating Complex Parameter Prompts
  • Creating and Running Action Queries
    • Identifying Action Query Types
    • Identifying Queries by Their Icons
    • Enabling Content
    • Creating a Make Table Query
    • Creating an Append Action Query
    • Creating an Update Query
    • Creating a Delete Query

back to top