COURSE SEARCH
 
   HOME > COURSE > MICROSOFT ACCESS 2007 ADVANCED MEMBERS LOGIN 
UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW
  HOME     COURSE LIBRARY     QUESTIONS & ANSWERS     CONTACT US
There are many excellent online courses. This has been hugely beneficial in my day to day work.
- Louise Nolan


Microsoft Access 2007 Advanced



Course Aims
This course will help you to customise and manage a database application using Microsoft Access. You will learn to use macros and command bars, link to external data sources and update data using action queries. You will also learn the basics of managing a shared database. You will learn how to use the User Level Security Wizard to secure the application and create a split-end database for use on a network.
Assumed Knowledge
Ideally, you will have completed the course "Microsoft Access 2007 Intermediate". You should be able to use Microsoft Access to create a relational database and be confident using the query, form, and report design tools.
Course Audience
Those wanting to customise basic database applications or to manage a database in a multi-user network environment.

This course can be found in the following categories:
Course Library > Microsoft > Access
Course Library > Microsoft > Office 2007

Table of Contents
Advanced Data Management
  • Referential Integrity
  • Table Relationships
  • Switchboards
  • Modal Dialogue Boxes
  • Case Study
  • Review Questions
     
    Advanced Form Tasks
  • Using Subforms
  • Advanced Form Tasks
  • Exporting Your Form
  • Using Outlook and SharePoint with Access
  • Case Study
  • Review Questions
    Pivoting Data
  • Creating a PivotTable
  • Creating a PivotChart
  • Using PivotTables and PivotCharts
  • Case Study
  • Review Questions
     
    Access and Windows
  • Access and Windows
  • Using the Access Viewer
  • An Introduction to SQL
  • Case Study
  • Review Questions
    TRY BEFORE YOU BUY BECOME A RESELLER
    Tuesday 18th June 2013  © COPYRIGHT 2013 - website design by Website Design by Visualsoft