Microsoft Access 2010: Advanced

Pre-Requisites: Microsoft Access® 2010 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.

Unit 1: Querying with SQL

  • Topic A: SQL and Access
  • Topic B: Writing SQL statements
  • Topic C: Attaching SQL queries to controls

Unit 2: Advanced queries

  • Topic A: Creating crosstab queries
  • Topic B: Creating parameter queries
  • Topic C: Using action queries

Unit 3: Macros

  • Topic A: Creating, running, and modifying macros
  • Topic B: Attaching macros to the events of database objects

Unit 4: Advanced macros

  • Topic A: Creating macros to provide user interaction
  • Topic B: Creating macros that require user input
  • Topic C: Creating the AutoKeys and AutoExec macros
  • Topic D: Creating macros for data transfer

Unit 5: Importing, exporting, and linking

  • Topic A: Importing objects
  • Topic B: Exporting objects
  • Topic C: Interacting with XML documents
  • Topic D: Linking Access objects
  • Topic E: Working with Windows SharePoint Services

Unit 6: Database management

  • Topic A: Optimizing resources
  • Topic B: Protecting databases
  • Topic C: Setting options and properties

Unit 7: Internet integration

  • Topic A: Hyperlink fields
  • Topic B: Working with Outlook 2010

 

Course Number : MOUS-7-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