Microsoft Access 2013 or 2016 - Level 2 - Intermediate

Office Applications/Productivity
  • Retail Price: $395.00
  • Sale Price: $195.00 (Vendor Credits or Vouchers Accepted)
  • 1 Day
  • http://www.certiport.com
  • Office Applications/Productivity
Schedules
  09/06/17 - 9-5pm PST Glendale - CA
  09/19/17 - 9-5pm PST Glendale - CA
  10/03/17 - 9-5pm PST Glendale - CA
  10/17/17 - 9-5pm PST Glendale - CA
  10/31/17 - 9-5pm PST Glendale - CA
  11/14/17 - 9-5pm PST Glendale - CA
  11/29/17 - 9-5pm PST Glendale - CA
  12/12/17 - 9-5pm PST Glendale - CA
  12/27/17 - 9-5pm PST Glendale - CA
Delivery Type (Must Select One)
  Instructor-Led
  Online Live Instructor-Led
Version (Must Select One)
  2013
  2016
Optional
  Certiport Test with Proctor Fee ($126.00)
  Certiport Test with 1 Retake / Proctor Fee ($145.00)
  LearnITAnytime Online Subscription (1 Year Subscription - $195.00)
  IT Online Library (1 Year Subscription - $1595.00)
  Private Mentoring 3 Hours ($125)
Quantity
If quantity is more than 1, Please add all Attendees' Names /Voucher #/ Learning Credit below separated with a comma. If not specified, we will contact you prior to the class start date. Special Instructions
This hands-on intermediate course is suitable for Access 2010/2013/2016 users.
Live face-to-face instructor-led training. No minimum class size - all classes guaranteed to run.
On this course you will extend your knowledge of Access by building a more complex database, working with external data, running more advanced queries, building more complex forms and generating detailed reports.

Advanced Record Tasks
  • Showing Totals
  • Adding from Outlook
  • Saving a Record as an Outlook Contact
  • Adjust Row Height
  • Hiding and Un-hiding Fields
  • Freezing and Unfreezing Fields
  • Formatting Text

Adding Data Fields
  • Adding Rich Text and Long Text Fields
  • Adding Attachment Fields
  • Adding Hyperlink Fields
  • Adding Lookup & Relationship Fields
  • Adding Calculated Fields

Advanced Field Tasks
  • Adjusting the Field Size/Width
  • Setting Field Default Value
  • Working with More Fields
  • Working with Field Validation Options
  • Using the Field List

Working in Table Design View
  • Opening Design View
  • Working with Field Properties
  • Setting the Primary Key
  • Using the Properties Sheet
  • Working with Table Properties
  • Viewing Table Relationships
  • Using Relationship Tools
  • Viewing Object Dependencies

Working with External Data
  • Linking Data
  • Importing Data
  • Using the Table Analyzer
  • Refreshing Data
  • Exporting Data

Creating Queries
  • Creating a Select Query
  • Creating a Make Table Query
  • Creating an Append Query
  • Creating a Cross Tab Query
  • Showing and Removing Tables

Creating Forms and Reports
  • Creating a Form with the Form Wizard
  • Creating a Report with the Report Wizard
  • Modifying Form Layout
  • Navigating the Field List
  • Key Features on the Form Tools Tabs
  • Key Features on the Report Tools Tabs




Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.


Certificate of Course Completion


This hands-on intermediate course is suitable for Access 2010/2013/2016 users.


You should have completed our Introduction class or have a basic knowledge of Microsoft Access prior to attending.


You may cancel this class 10 or more business days prior to the start date of the class for a full refund. No shows or cancellations made within 10 days will forfeit all fees paid.