A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer

View Recent History

Visual Studio 2005 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8521) Microsoft CRM 3.0 Sales Management - Microsoft Training Courses in London and South West
Course:(8524) Microsoft CRM 3.0 Service Scheduling - Microsoft Training Courses in London and South West
Course:(4005) Beyond the Spreadsheet: Managing Financial Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(8879) Using the Microsoft Dynamics Sure Step Methodology for Microsoft Dynamics CRM - Microsoft Training Courses in London and South West
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2381) Planning Collaborative Solutions With Microsoft Office XP Technologies - Microsoft Training Courses in London and South West
Course:(4006) Time and Task Management Using Microsoft Office Outlook 2003 - Microsoft Training Courses in London and South West
Course:(8912) Customisation and Configuration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(F1033) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Developer in 5 Days Flat! - Microsoft Training Courses in London and South West
Course:(4002) Forecasting and Trend Analysis Using Microsoft Office Excel 2003 - Microsoft Training Courses in London and South West
Exchange Server 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(80054) Project Managing Microsoft Dynamics CRM Implementations with Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1034) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Expert in 7 Days Flat! - Microsoft Training Courses in London and South West
Course:(F1023) What's New in Microsoft CRM 3.0 - Technical - Microsoft Training Courses in London and South West
Course:(80141) Integrating Microsoft Dynamics CRM 4.0 and Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(8911) Installation and Deployment in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(4003) Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions - Microsoft Training Courses in London and South West
Course:(80003) Workflow in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(8913) Applications in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(8529) Microsoft CRM 3.0 Administration - Microsoft Training Courses in London and South West
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(4008) Building Better Microsoft Office Word 2003 Documents in Less Time - Microsoft Training Courses in London and South West
Course:(F1024) What's New in Microsoft CRM 3.0 - Applications - Microsoft Training Courses in London and South West
Application Centre Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8530) Microsoft CRM 3.0 Data Migration - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8531) Extending Microsoft CRM 3.0 - Microsoft Training Courses in London and South West
Course:(F1029) Intermediate Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(4004) Managing Critical Business Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(8526) Microsoft CRM 3.0 Installation and Configuration - Microsoft Training Courses in London and South West
Visual Studio 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8910) What's New in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Visual Basic 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1032) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Power User in 3 Days Flat! - Microsoft Training Courses in London and South West
Visual Studio 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8969) Extending Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(8522) Microsoft CRM 3.0 Marketing Automation - Microsoft Training Courses in London and South West
Course:(F1028) Introduction to Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(F1037) Customisation of xRM/CRM for Microsoft Partners and Customers - Microsoft Training Courses in London and South West
Course:(8525) Microsoft CRM 3.0 Customization - Microsoft Training Courses in London and South West
Course:(4009) Setting Up Projects for Success Using Microsoft Office Project 2003 - Microsoft Training Courses in London and South West
Course:(F1030) Advanced Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(80047) Using Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Visual Studio .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(80002) Administration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
indexes/Certification_courses_index.aspx Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(3373) First Look: Getting Started with Windows SharePoint Services 3.0 Hands-On Lab - Microsoft Training Courses in London and South West
Visual Studio 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1035) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Guru in 10 Days Flat! - Microsoft Training Courses in London and South West

Compare Recently Viewed Course Dates



Exclusive
Office

Managing Critical Business Information Using Microsoft Office Access 2003
(Microsoft Training Course: 4004) - 0.5 day - £600 exc VAT

We currently do not have any dates scheduled for this course.
Please contact us to arrange a closed course for your company or add your details to courses in waiting.
(Remember F1 has smaller classes)
Ask a Question ?Print 2 Page PDF


> Target Audience
This scenario-based class provides experienced Microsoft Access users with a stronger relational database foundation. It brings home relational database concepts and teaches how to employ powerful techniques using Access in gathering, organizing, and reporting of information vital to your business. This course is designed for experienced Access users.
> Course outline
  1. Creating a Strong Foundation for Your Database
  2. Creating an Effective User Interface
  3. Organizing Data Though Queries
  4. Reporting Strategic Information with Access
  5. Integrating Access with other Office Applications


Module 1: Creating a Strong Foundation for Your Database
  • What Is a Relational Database?
  • Demonstration: Creating Tables and Using the Relationships Window
  • Expert Video: Importance of Using Relationships and Referential Integrity
  • Types of Files Commonly Imported or Linked to Access
  • Exercise: Importing a Text File and Excel Data
  • Best Practices for Creating Tables and Utilizing Outside Data
Skills
  • Describe relational database concepts.
  • Create tables and relationships.
  • Import data into tables from different types of file sources.
  • Incorporate best practices for creating tables and utilizing outside data.
top
Module 2: Creating an Effective User Interface
  • Good Form Design
  • Mapping Out the Forms to Use in the Fourth Coffee Database
  • Exercise 1: Creating the Necessary Input Forms
  • Exercise 2: Creating the Main Switchboard and Setting Startup Properties
  • Best Practices for Creating User Interfaces
Skills
  • Make intelligent decisions regarding the use of form standards.
  • Create switchboards for launching tasks in their databases.
  • Use a Form Wizard as a base for creating forms.
  • Enhance forms so that users can work with them more effectively.
top
Module 3: Organizing Data Though Queries
  • Choosing the Right Type of Query for the Task at Hand
  • Exercise 1: Creating Select and Totals Queries
  • Retrieving Only the Information That You Want
  • Exercise 2: Adding Criteria to Queries
  • Exercise 3: Using Forms and Controls for Criteria
  • Exercise 4: Adding Data by Using an Append Query
  • Best Practices for Using Queries to Their Fullest Potential
Skills
  • Use Query Design view.
  • Specify and create various types of queries.
  • Add parameters and criteria to query requests.
  • Create forms that call queries.
top
Module 4: Reporting Strategic Information with Access
  • Generating Reports That Display Strategic Information
  • Exercise 1: Generating the Base Report
  • Demonstration: Touring Report Design View
  • Exercise 2: Creating a Macro to Companies Only on the Report
Skills
  • Generate a report by using the Report Wizard.
  • Construct a form for calling the report and displaying the report in Print Preview mode for printing.
  • Hide and display sections of a report.
top
Module 5: Integrating Access with other Office Applications
  • Integration with Other Office Applications
  • Exercise 1: Publishing Information Using Word and Excel
  • Exercise 2: Creating a Custom Toolbar for Office Links and Mail Recipient
  • Exercise 3: Performing Mail Merge Between Access and Word
  • Best Practices for Avoiding the Pitfalls of Integration
Skills
  • Recognize how easily Access and other Office products integrate.
  • Publish an Access report to Word.
  • Export a table to Excel.
  • Employ a custom toolbar that sends a report in e-mail.
  • Perform a mail merge between Access and Word.
top
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • A basic understanding of relational databases.
  • An understanding of Access tables, queries, forms and reports and a base knowledge of how they are used within an Access database.
  • Experience creating Access macros and using them in forms.
  • A working familiarity with standard Microsoft Office applications (such as Microsoft Outlook, Word, and Excel).
> Purpose
After completing the course, students will be able to create solid relational database structures using Access for data integrity that is easier to maintain; import data of various formats from outside sources; utilize appropriate techniques for querying information in the Access database as various business needs arise; create consistent standard user interfaces for inputting data; generate powerful and flexible reports for management; describe the benefits that can be realized from the integration of Access with other Office 2003 applications.
> EXAMS
There are no exams directly associated with this course