Microsoft Access – Level 4
Course Outline

DURATION	1 Day
PREREQUISITES	Must be a confident Access user. You’ve created databases a few times and know about relating tables. You are familiar with the concepts of Levels 1-3 and would like to start automating your databases.
DESCRIPTION	This course introduces macros, VBA, Sharepoint connectivity, and goes into SQL in detail.
COURSE DATES	Special: Four Days of MS Office training for the price of Three! Click here to request an alternate date Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday. Weekday Mon, 6-Feb-12 09:30 - 16:30 £200.00 +VAT Weekend Wed, 7-Mar-12 10:00 - 16:30 £200.00 +VAT Weekday Fri, 9-Mar-12 09:30 - 16:30 £180.00 +VAT Weekday Thu, 5-Apr-12 09:30 - 16:30 £200.00 +VAT Evening Thu, 12-Apr-12 and Tue, 3-Apr-12 18:30 - 21:30 £200.00 +VAT Evening Wed, 2-May-12 and Thu, 3-May-12 18:30 - 21:30 £200.00 +VAT Weekday Fri, 4-May-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 2-Jun-12 10:00 - 16:30 £200.00 +VAT Weekday Wed, 6-Jun-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 2-Jul-12 and Tue, 3-Jul-12 18:30 - 21:30 £200.00 +VAT Weekday Thu, 5-Jul-12 09:30 - 16:30 £200.00 +VAT Evening Wed, 1-Aug-12 and Thu, 2-Aug-12 18:30 - 21:30 £200.00 +VAT Weekday Mon, 6-Aug-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 1-Sep-12 10:00 - 16:30 £200.00 +VAT Weekday Fri, 14-Sep-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 1-Oct-12 and Tue, 2-Oct-12 18:30 - 21:30 £200.00 +VAT Weekday Thu, 4-Oct-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 5-Nov-12 and Tue, 6-Nov-12 18:30 - 21:30 £200.00 +VAT Weekday Tue, 6-Nov-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 1-Dec-12 10:00 - 16:30 £200.00 +VAT Weekday Thu, 6-Dec-12 09:30 - 16:30 £200.00 +VAT Any One-to-One Tuition Any Date - Fully Customisable 09:30 - 16:30 £375.00 +VAT Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses. Fri, 21/11/2008

ADD-ONS TO ACCESS

• COM Add-Ins

• Digital Signatures

• Smart Tags

• Managing Your Database

• Customizing Access
  

USING SCRIPTS IN ACCESS

• Macro Basics

• Other Macro Tasks

• Visual Basic and Macros

• Macro Groups
  

USING ACCESS TO COLLABORATE

• SharePoint Basics

  • What is SharePoint?

  • System Requirements

  • Creating a Workspace

  • Accessing a Workspace

  • Publishing to a Workspace

   

• SharePoint Data

  • Using Offline Lists

  • Exporting a List

  • Restricting Permission for Data Objects

   

• Your Personal SharePoint Space

  • Public and Private Views

  • Shared and Private Documents

  • Creating a List

  • Creating a Page

  • Personalizing your Space

SQL AND MICROSOFT ACCESS

• Understanding SQL

  • What is an SQL Database?

  • What is an SQL Statement?

  • What is an SQL Convention?

  • What is SQL Syntax?

  • Linking a Database to an SQL Server

   

• Using the SELECT Statement

  • Selecting All Data

  • Selecting Specific Data

  • Selecting Conditional Data

  • Using the ORDER BY Statement

   

• Using Subqueries
  

  • What is a Subquery?

  • Creating a Subquery

  • Subqueries with Equality

  • Subqueries with Aggregate Functions

  • Nested Subqueries and Uses of the IN Keyword

   

• Using SQL Joins
  

  • Creating Simple Joins

  • Using an Alias

  • Sorting Joins

  • Creating Outer Joins