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.

Advanced Microsoft Access 2003 Training

 PDF PrintEmail

Course duration

  • 3 Days

Course Outline

This Microsoft Access training course is designed for students whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft Office Specialist Certification for Microsoft Office Access 2003.

Students will learn introductory level administrator skills. This advanced Access course is also for the student who may be working in a web-based environment and may need to adapt Access applications to the environment. It is also designed for students pursuing the Microsoft MOS Expert Level Certification for Access 2003.

  • Learn to restructure an existing set of data to improve the design of a database.
  • Learn to use a variety of techniques to summarize and present data with queries.
  • Learn to create and revise basic Access macros.
  • Learn to create macros that improve data entry efficiency and integrity.
  • Learn to improve the effectiveness of data entry in forms.
  • Learn to improve the effectiveness of data displayed in reports.
  • Learn to maintain an Access database by using various utility tools.
  • Learn to develop a data access page, a PivotTable, and a PivotChart.
  • Learn to import XML data and export Access data.
  • Learn to use VBA to automate a business process.
  • Learn to create and modify a database switchboard, and set and modify your startup options.
  • Learn to distribute a database and add security features to it.
  • Basic Microsoft Access
  1. Structuring Existing Data in Microsoft Access
    1. Import Data
    2. Analyze Tables
    3. Create a Junction Table
    4. Improve Table Structure
  2. Writing Advanced Queries in Microsoft Access
    1. Create Unmatched and Duplicates Queries
    2. Group and Summarize Records Using the Criteria Field
    3. Summarize Data with a Crosstab Query
    4. Create a PivotTable and a PivotChart
    5. Display a Graphical Summary on a Form
  3. Simplifying Tasks with Macros in Microsoft Access
    1. Create a Macro
    2. Attach a Macro to a Command Button
    3. Restrict Records Using a Where Condition
  4. Adding Interaction and Automation with Macros in Microsoft Access
    1. Require Data Entry with a Macro
    2. Display a Message Box with a Macro
    3. Automate Data Entry
  5. Making Forms More Effective in Microsoft Access
    1. Change the Display of Data Conditionally
    2. Display a Calendar on a Form
    3. Organize Information with Tab Pages
  6. Making Reports More Effective in Microsoft Access
    1. Cancel Printing of a Blank Report
    2. Include a Chart in a Report
    3. Arrange Data in Columns
    4. Create a Report Snapshot
    5. Maintaining an Access Database
    6. Link Tables to External Data Sources
    7. Back Up a Database
    8. Compact and Repair a Database
    9. Protect a Database with a Password
    10. Determine Object Dependency
    11. Document a Database
    12. Analyze the Performance of a Database
  7. Making Your Data Available on the Web
    1. Create a Data Access Page by Using the Wizard
    2. Improve the Presentation of the Data Access Page
    3. Viewing Data Access Pages with the Browser
    4. Edit Data Using the Data Access Page
    5. Group Records in the Data Access Page
  8. Developing a Data Access Page in Design View
    1. Create a Data Access Page in Design View
    2. Incorporate a ComboBox in the Data Access Page
    3. Test the New Record Function of the Data Access Page
    4. Develop a PivotTable with the Office PivotTable Tool
    5. Develop a PivotChart
  9. Integrating Access into Your Business
    1. Import XML Data into an Access Database
    2. Export Access Data to XML Format
    3. Share Data with Other Office Applications
  10. Automating a Business Process with VBA
    1. Create a Standard Module
    2. Develop Code
    3. Call a Procedure from a Form
    4. Run the Procedure
  11. Creating a Switchboard and Setting the Startup Options
    1. Create a Database Switchboard
    2. Modify a Database Switchboard
    3. Set the Startup Options
    4. Modify the Startup Options
  12. Distributing and Securing the Database
    1. Split a Database
    2. Implement Security
    3. Set Passwords
    4. Encode and Decode a Database
    5. Convert an Access Database to an MDE File

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.