Microsoft Access 2013: Advanced

Pre-Requisites: Microsoft Access® 2013 Intermediate skills.

5-stars

Key Features

  • Online live classroom available
  • Quality learning materials
  • Small Class Sizes
  • State of the Art Facility
  • Free Retakes
  • Instructor Led Classroom training
  • Certified Industry Experienced Teachers
  • 100% Job Placement assistance

In this course, student will extend their knowledge into some of the more specialized and advanced capabilities like how to design Microsoft Access® 2010 applications including integrating data, improving forms, macros, switchboards, database startup properties, and security.

This course is intended for students who wish to learn the essentials of database development.

Querying with SQL

  • SQL and Access
  • Writing SQL statements
  • Attaching SQL queries to controls

Advanced queries

  • Creating crosstab queries
  • Creating parameter queries
  • Using action queries

Macros

  • Creating, running, and modifying macros
  • Attaching macros to the events of database objects

Advanced macros

  • Creating macros to provide user interaction
  • Creating macros that require user input
  • Creating AutoKeys and AutoExec macros
  • Creating macros for data transfer

Importing, exporting, and linking objects

  • Importing objects
  • Exporting objects
  • Working with XML documents
  • Linking Access objects
  • Using hyperlink fields

Course Number : MOUS-8-0402

Duration : 8 hours

1 Step 1

Request Information!

Who you are?

By submitting this form, you are giving your express written consent for Global Information Technology to contact you regarding our programs and services using email, telephone or text.  This consent is not required to purchase goods/services, and you may always call us directly at 1-866-464-4846.

reCaptcha v3
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right
FormCraft - WordPress form builder