Microsoft Access

Course Overview

Title:
Microsoft Access
Type:
NewsU Tech Course
Time Estimate:
You can work through this self-directed course at your own pace. It takes about 48 hours to work through all the sections. Each section is divided into several modules, giving you quick access to your specific training needs. And you can come back anytime once you enroll. The course remembers your progress, so you can pick up where you left off. You have unlimited access to all the tutorials in this module for the length of your subscription.

About NewsU Tech Courses

Our new training library is a powerful resource to help you develop your software and technical skills. Your subscription to any NewsU Tech course gives you unlimited access to each self-directed tutorial. We have partnered with a leading technology training organization, Element K, to make sure this content is up-to-date.

One of the most efficient and powerful information management, computer-based applications is the relational database. Information can be stored, linked and managed using a single relational database application and its associated tools. Microsoft Access will help you organize and make sense of the data you need to make informed decisions. Learn to track information, create meaningful reports, share data with others and manage and audit sensitive information, even if you don't have deep database knowledge.

This course has nine sections:

  • Microsoft Office Access 2007: New Features (3 hours, 15 minutes) Get an overview of the redesigned user interface and interactive features of Microsoft Office Access 2007.
  • Microsoft Office Access 2007: Level 1 (Second Edition) (7 hours, 30 minutes) Create and modify new databases and their various objects.
  • Microsoft Office Access 2007: Level 2 (Second Edition) (6 hours, 15 minutes) Learn to maintain data consistency and integrity; improve queries, forms and reports; and integrate Access 2007 with other applications.
  • Microsoft Office Access 2007: Level 3 (Second Edition) (5 hours, 30 minutes) Learn to create complex Access databases by structuring existing data, writing advanced queries, working with macros, making effective use of forms and reports, and performing database maintenance.
  • Microsoft Office Access 2007: Level 4 (Second Edition) (5 hours, 15 minutes) Exchange data with other applications, automate business processes using VBA code, and secure and share databases.
  • Microsoft Office Access 2003: Level 1 (4 hours, 40 minutes) An introduction to the concept of the relational database, then the Microsoft Access relational database application and its information management tools.
  • Microsoft Office Access 2003: Level 2 (5 hours, 15 minutes) Design and create a new Access database; improve queries, forms and reports; and integrate Access with other applications.
  • Microsoft Office Access 2003: Level 3 (5 hours, 30 minutes) Ready to extend your knowledge into some of the more specialized and advanced capabilities? In this course you will create Access databases using forms, reports and macros.
  • Microsoft Office Access 2003: Level 4 (4 hours, 45 minutes) An introduction to the advanced features of Access and the VBA programming language. You will learn remote database management, how to exchange data with XML and other type applications, and how to automate your business processes by using VBA code.
Who should take this course:

People who design and create databases, use tables to create and maintain records, locate records and produce reports. Microsoft Access will help you organize and make sense of the data. Learn to track information, create meaningful reports, share data with others and manage and audit sensitive information.

Training Partner:

Element K

NewsU Tech courses are available through a partnership with Element K, which offers a wide range of training products, technology and services. In addition to the courses offered through NewsU, Element K offers more than 2,300 e-learning courses, 1,300 print courseware titles, a learning platform, hands-on labs, professional certifications, managed services and integration services.

Technical Requirements:
  • This course requires Flash Player 8 or higher. After signing in, you may be prompted to install the latest version of Flash or Shockwave the first time you launch a course.
  • For Mac users, we recommend accessing this course with Firefox or Safari 2.x or higher.
  • You will also need to allow pop-ups from NewsU. You can usually update your pop-up settings from your browser's "Privacy" or "Content" sections.
  • Because these courses use audio, you’ll need a computer with a soundcard and either speakers or headphones. Please adjust your setting accordingly. The courses also have closed captioning, if you are unable to access audio.