Microsoft Access 2007 - Level 4

Progressive Training & Development

Short course

In Southwark

Price on request

The best Access courses

See all

See all

Description

  • Type

    Short course

  • Location

    Southwark

  • Duration

    1 Day

This course introduces macros, VBA, Sharepoint connectivity, and goes into SQL in detail.

Facilities

Location

Start date

Southwark (London)
See map
202 Blackfriars Road, SE1 8NJ

Start date

On request

About this course

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Microsoft Access

Course programme

DESCRIPTION
This course introduces macros, VBA, Sharepoint connectivity, and goes into SQL in detail.

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.


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

See related categories

Microsoft Access 2007 - Level 4

Price on request

The best Access courses

See all

See all