Microsoft IT Academy: Course 10382: Beginner Skills in Microsoft Access 2010

Online

This two-hour online course explains how to create and work with a database and its objects by using the new and improved features in Microsoft Access 2010.

• All current Cambridge University members (departments and colleges)
• Further details regarding eligibility criteria are available

Learners taking this course may have limited experience working with any database application, especially Access 2010. They may have used either Microsoft Office Access 2003 or Microsoft Office Access 2007. Learners who are familiar with Access 2003 and unfamiliar with the ribbon must complete Course 4697: Introduction to the New Microsoft® Office Fluent™ User Interface before taking this course.

• Database Basics
• Creating a Database
• Importing and Exporting Data
• Creating and Managing Indexes
• Creating a Query by Using Query Wizard
• Creating an Expression by Using Expression Builder
• Creating a Report
• Grouping and Sorting Data in a Report
• Creating a Form by Using Form Wizard

• Create and edit a database.
• Create and use a query.
• Create and edit a report.
• Create and edit a form.

Self-taught online

To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Macromedia Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled

How to Enrol

• Email us: training@ucs.cam.ac.uk
• Telephone courses: (01223 3)34662

Important Information:

• To view this course you will need a Microsoft Live ID or Hotmail email account and to view the materials you will need to login and access the courses with Microsoft’s Explorer web browser (other browser systems may experience problems).