English French German Italian Portuguese Russian Spanish

logo_old

  • Microsoft Training

    microsoftInterSource offers courses on all practically all Microsoft products and technologies:

    Operating Systems: XP, Vista, Server Server2003, Server 2008 IIS, SQL Server

    Development Tools & Environments: ASP, ASP.NET, C#, .NET, VBA, Visual Basic

    Applications: Dynamics, Expression, Access, Excel, Word PowerPoint, Exchange, InfoPath, Outlook, SharePoint , Project, Publisher, Business Intelligence

    Please refer to our detailed course outlines below.

  • About Microsoft

    Microsoft has had an impact on, and indeed defined the computing world like no other company. The development tools, operating systems and applications produced by Microsoft have achieved near-ubiquity in the desktop computer market. The original mission set by Microsoft's founder was to have "a computer on every desk and in every home, running Microsoft software". About 90% of computer users worldwide run Microsoft products, hence this objective has largely been met. For operating systems, Web client statistics suggest that Microsoft Windows has about a 92% share, Apple Mac OS 6% and Linux, 1%.

    Read More

  • Course Details Microsoft

    Classes are offered at client sites, at our Geneva training center, and via a live web conference. For detailed course outlines and scheduled classes, please see below.

    To book training, navigate to the course you need, then:

    • For scheduled online classes, register from the choices indicated.
    • If you need an alternative date, time or location, or if you want a live classroom course, click on “request an offer for this course,” to complete the form.

Introduction to Microsoft Access 2003

 PDF PrintEmail

Course duration

  • 3 Days

Course Outline

This Microsoft Access training course is designed for students who wish to learn the basic operations of the Access 2003 database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The introductory Access course is for the individual whose job responsibilities include working with tables to create and maintain records, locate records, and produce reports based on the information in the database.

The course also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications. It is also for students whose job responsibilities include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the student to integrating Access data with other applications such as Microsoft Word or Excel. This course is also designed for students pursuing the Microsoft Office Specialist Certification for Access 2003, and it is a prerequisite to taking more advanced courses in Access 2003.

  • Understand how Microsoft Access and relational databases work.
  • Examine the Microsoft Access database application.
  • Learn to manage the data in a Microsoft Access database.
  • Examine existing table relationships in Microsoft Access.
  • Learn to query a Microsoft Access database.
  • Learn to design simple forms in Microsoft Access.
  • Learn to create and modify Microsoft Access reports.
  • Learn to design a simple database in Microsoft Access.
  • Learn to create a new database with related tables.
  • Learn to control data entry by modifying the design of a table to streamline data entry and maintain data integrity.
  • Find and retrieve desired data by using filters and joins between tables and within a single table.
  • Learn to create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries.
  • Learn to improve the appearance, data entry, and data access capabilities of your forms.
  • Learn to customize reports to better organize the displayed information and produce specific print layouts such as mailing labels.
  • Learn to use Access data in other applications, including Microsoft Word and Excel.
  1. An Overview of Microsoft Access
    1. Understand Relational Databases
    2. Examine the Access Environment
    3. Open the Database Environment
    4. Examine an Access Table
  2. Managing Data in Microsoft Access
    1. Examine an Access Form
    2. Add and Delete Records
    3. Sort Records
    4. Display Recordsets
    5. Update Records
    6. Run a Report
  3. Establishing Table Relationships in Microsoft Access
    1. Identify Table Relationships
    2. Identify Primary and Foreign Keys in the Relationships Window
    3. Work with Subdatasheets
  4. Querying the Database in Microsoft Access
    1. Create a Select Query
    2. Add Criteria to a Query
    3. Add a Calculated Field to a Query
    4. Perform a Calculation on a Record Grouping
  5. Designing Forms in Microsoft Access
    1. Examine Form Design Guidelines
    2. Create a Form Using AutoForm
    3. Create a Form Using the Form Wizard
    4. Modify the Design of a Form
  6. Producing Reports in Microsoft Access
    1. Create an AutoReport
    2. Create a Report by Using the Wizard
    3. Examine a Report in Design View
    4. Add a Calculated Field to a Report
    5. Modify the Format Properties of a Control
    6. AutoFormat a Report
    7. Adjust the Width of a Report
  7. Planning a Database in Microsoft Access
    1. Design a Relational Database
    2. Identify Database Purpose
    3. Review Existing Data
    4. Determine Fields
    5. Group Fields into Tables
    6. Normalize the Data
    7. Designate Primary and Foreign Keys
  8. Building the Structure of a Database in Microsoft Access
    1. Create a New Database
    2. Create a Table Using a Wizard
    3. Create Tables in Design View
    4. Create Relationships between Tables
  9. Controlling Data Entry in Microsoft Access
    1. Restrict Data Entry with Field Properties
    2. Create an Input Mask
    3. Create a Lookup Field
  10. Finding and Joining Data in Microsoft Access
    1. Find Data with Filters
    2. Create Query Joins
    3. Join Unrelated Tables
    4. Relate Data Within a Table
  11. Creating Flexible Queries in Microsoft Access
    1. Set Select Query Properties
    2. Create Parameter Queries
    3. Create Action Queries
    4. Improving Your Forms
    5. Enhance the Appearance of a Form
    6. Restrict Data Entry in Forms
    7. Add Command Buttons
    8. Create a Subform
  12. Customizing Your Reports in Microsoft Access
    1. Organize Report Information
    2. Set Report Control Properties
    3. Control Report Pagination
    4. Summarize Information
    5. Add a Subreport to an Existing Report
    6. Create Mailing Labels
  13. Expanding the Reach of Your Data in Microsoft Access
    1. Publish Access Data as a Word Document
    2. Analyze Access Data in Excel
    3. Export Data to a Text File
    4. Merge Access Data with a Word Document

InterSource Geneva, a premier Information Technology training firm, offers over 400 different courses on server, database and programming technologies, as well as end-user classes for the most popular office, graphics and design applications. We serve clients in Switzerland (Geneva, Lausanne, Bern, Basel, Zurich) and throughout Europe (France, Germany, Austria, Finland, Sweden, England, Netherlands, Spain, etc.).


InterSource offers custom, private courses at client sites, standard public courses in our Geneva classroom, and online training via live Web conference. Training is offered in English and many other languages (Francais, Deutsch, Espanol, Italiano.)


For an overall view of our offerings, please visit us at www.intersource.ch.