Skip to content
Microsoft Access 2013 Intermediate

Microsoft Access 2013 Intermediate

$275.00 Per Enrollment

Price Includes:

Courseware and ‘Price & Quality Guarantee’

TrainACE's Microsoft Access 2013 Intermediate training course will expand your understanding of Access 2013 and enable you to create, maintain and query small to medium sized relational databases. This Instructor-Led Training course builds on concepts learned in our Microsoft Access 2013 Basic training to give the student a well-rounded understanding of database concepts and Microsoft Access in particular.

In our Microsoft Access 2013 Intermediate training you will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms, and reports, insert background images and charts; and create specialized objects such as lookup fields, subforms and subreports, navigation forms, and calculated fields.

 

Got Questions?

For more information about your specific needs, call us at (301) 220 2802 or complete the form below:

Learn More About Microsoft Access 2013 Intermediate Training Training

 

Jump To:

    Class Schedule

    Get your Microsoft Access 2013 Intermediate training in our convenient IT training centers in Maryland or Virginia.


    Why Take Microsoft Access 2013 Intermediate Training training in Maryland?

     

    Our Microsoft Access 2013 Intermediate training will expand your understanding of the basic principles and functions of Microsoft Access 2013 and give you a firmer footing in the implementation and use of relational databases.

    In this Instructor-Led Course (ILT) you will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms, and reports, insert background images and charts; and create specialized objects such as lookup fields, subforms, and subreports, navigation forms, and calculated fields.


    Signup today for our convenient Microsoft Access 2013 Basic Bootcamp!

     

    What you need to know before taking Microsoft Access 2013 Intermediate training

     

    Although there are no strict prerequisites for this course the typical student will have a basic understanding of Microsoft Access and database concepts. The course is ideal for anyone looking to maintain, create and query office databases, or who are starting out in a database administration career.


    Exam and Certification Requirements:

     

    Microsoft Access 2013 Intermediate is one of several MS Office classes that will prepare you for the Microsoft Office Specialist (MOS) certification.


    What You Will Learn in Microsoft Access 2013 Intermediate training

    Unit 1: Relational databases

    • Topic A: Database normalization
    • Topic B: Table relationships
    • Topic C: Referential integrity

    Unit 2: Related tables

    • Topic A: Creating lookup fields
    • Topic B: Modifying lookup fields
    • Topic C: Subdatasheets

    Unit 3: Complex queries

    • Topic A: Joining tables in queries
    • Topic B: Using calculated fields
    • Topic C: Summarizing and grouping values

    Unit 4: Advanced form design

    • Topic A: Adding unbound controls
    • Topic B: Graphics
    • Topic C: Adding calculated values
    • Topic D: Adding combo boxes
    • Topic E: Advanced form types

    Unit 5: Reports and printing

    • Topic A: Report formatting
    • Topic B: Calculated values and subreports
    • Topic C: Printing
    • Topic D: Label printing

    Unit 6: Charts

    • Topic A: Charts in forms
    • Topic B: Charts in reports