COURSE SEARCH
 
   HOME > COURSE > MICROSOFT ACCESS 2007 INTERMEDIATE 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 Intermediate



Course Aims
his course is designed to help you to obtain the skills required to create a relational database. You will learn relational database concepts and practice and understand the importance of documenting and maintaining database files. You will learn to customise forms, reports, and Data Access Pages in design view. Finally, you will be able to calculate and summarise data and import and export data in different formats for different purposes, like mail merge, analysis, or reporting.
Assumed Knowledge
Ideally, you will have completed the course "Microsoft Access 2003 Introduction". You should be able to use Microsoft Access to create a database, tables, queries, forms, and reports.
Course Audience
Those wanting to design relational database structures using Access and master the design and customisation tools available for queries, forms, and reports.

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

Table of Contents
Advanced File Tasks
  • Using My Computer With Access
  • Database Management
  • Saving Your Files
  • Exporting Your Files
  • Linking Files
  • Case Study
  • Review Questions
     
    Working With Tables
  • Customizing Tables
  • Formatting Tables
  • Controlling Table Data Entry
  • Managing Table Data Entry
  • Case Study
  • Review Questions
     
    Working With Forms
  • Basic Form Controls
  • Advanced Form Controls
  • Formatting Your Form
  • Formatting Controls
  • Formatting Records
  • Case Study
  • Review Questions
    Working With Reports
  • Organizing Report Data
  • Formatting Report Data
  • Common Report Tasks
  • Case Study
  • Review Questions
     
    Working With Queries
  • Basic Queries
  • Multiple Table Queries
  • Advanced Queries
  • Management (Action) Queries
  • Case Study
  • Review Questions
    TRY BEFORE YOU BUY BECOME A RESELLER
    Saturday 11th February 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft