Microsoft Access 2013 - Level 3

Our classes are always live and instructor led from our Exton, PA or EPIC Partner locations. Springhouse AnywhereLive options require Internet Access. Select classes are Guaranteed to Run (GTR). View our complete schedule policies.

 

 

 

 

f6996bd3-4050-e711-98e2-00155d0a14062018-01-19T10:00:00Z295.000000000000019:00 AM4:00 PMExtonf6996bd3-4050-e711-98e2-00155d0a1406
f7996bd3-4050-e711-98e2-00155d0a14062018-02-28T10:00:00Z295.000000000000019:00 AM4:00 PMExtonf7996bd3-4050-e711-98e2-00155d0a1406
f8996bd3-4050-e711-98e2-00155d0a14062018-04-25T08:00:00Z295.000000000000019:00 AM4:00 PMExtonf8996bd3-4050-e711-98e2-00155d0a1406

Overview

In Microsoft Access 2013 Level 3 students will learn advanced features of Access. Topics covered include querying with SQL, writing advanced queries, working with macros, importing, exporting and linking objects, and performing database maintenance.

Intended Audience

This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.  This course will also assist students preparing for the Microsoft Office Specialist exam for Microsoft Access 2013.

At Completion

 Upon successful completion of the course, students will be able to:

  • Write basic SQL statements
  • Write advanced queries to analyze and summarize data
  • Create and revise Microsoft Access 2013 macros
  • Import, export and link objects
  • Maintain databases using Microsoft Access 2013 tools

Prerequisites

To ensure your success, knowledge of basic and intermediate features of Access tables, relationships, and queries, forms, and reports is required.  Students should attend Microsoft Access 2013 Level 1 and Microsoft Access 2013 Level 2, or possess equivalent knowledge prior to attending this class.

Exams & Certifications

 

Materials

 

Course Outline

Lesson 1: Querying with SQL

  • SQL and Access
  • Writing SQL Statements
  • Attaching SQL Queries to Controls

Lesson 2: Advanced Queries

  • Creating Crosstab Queries
  • Creating Parameter Queries
  • Using Action Queries

Lesson 3: Macros

  • Creating, Running, and Modifying Macros
  • Attaching Macros to the Events of Database Objects

Lesson 4: Advanced Macros

  • Creating Macros to Provide User Interaction
  • Creating Macros that Require User Input
  • Creating AutoKeys and AutoExec Macros
  • Creating Macros for Data Transfer

Lesson 5: Importing, Exporting, and Linking Objects

  • Importing Objects
  • Exporting Objects
  • Working with XML documents
  • Linking Access Objects
  • Using Hyperlink Fields

Lesson 6: Database Management

  • Optimizing Resources
  • Protecting Databases
  • Setting Options and Properties

 

 

Microsoft Access 2013 - Level 3http://springhouse.com/course-catalog/MS_ACCESS2013L3Microsoft Access 2013 - Level 3

Get More Information
Name:

Phone:  

Email:  

Comments:

Help us prove you're not a robot:
 

 ‭(Hidden)‬ Catalog-Item Reuse

Microsoft Gold Partner

PMI R.E.P.

AXELOS Limited

The Microsoft Gold CPLS logo is a mark of Microsoft, Inc.

The PMI R.E.P. logo is a mark of the Project Management Institute, Inc.

ITIL® is a registered trade mark of AXELOS Limited.
IT Infrastructure Library® is a registered trade mark of AXELOS Limited
The Swirl logo™ is a registered trade mark of AXELOS Limited
Accredited course material is property of ITSM Academy.

Connect with us

Springhouse Education & Consulting Services

Corporate HQ:Eagleview Corporate Park
707 Eagleview Boulevard
Suite 207
Exton, PA 19341

610-321-3500 - info@springhouse.com