Microsoft Access Level 1

This Level 1 course is designed for people who wish to establish a basic understanding of Microsoft Access, including the skills necessary to create a new database, construct data tables, design forms and reports and create queries.

Microsoft Access is a tool to manage information. It can help you to overcome restrictions you may find when you try to manage large amounts of information in Excel or other spreadsheets.

Microsoft Access Level 1 training from Insight IT, allows you to take control of your data. Our course will teach you the basic features of Access. By the end of the Level 1 course, you will understand working with table data, queries, generating reports and more besides!

No matter what version of Microsoft Access you use, from Access 2003, MS Access 2007 through to later versions including Access 2010 - we can help you.

Before attending this Microsoft Access Level 1 course, you should be familiar with using personal computers, and should have experience using a keyboard and mouse.

You should be comfortable in the Windows environment, and be able to use Windows to manage information on your computer. Specific tasks you should be able to perform include: launching and closing applications, navigating basic file structures, and managing files and folders.

Course Content

• Getting Started with Access

  • Orientation to Microsoft Access

  • Create a Simple Access Database

  • Get Help in Microsoft Access

• Working with Table Data

  • Modify Table Data

  • Sort and Filter Records

  • Create Lookups

• Querying a Database

  • Join Data from Different Tables in a Query

  • Sort and Filter Data in a Query

  • Perform Calculations in a Query

• Creating Advanced Queries

  • Create Parameter Queries

  • Create Action Queries

  • Create Unmatched and Duplicate Queries

  • Summarize Data

• Generating Reports

  • Create a Report

  • Add Controls to a Report

  • Enhance the Appearance of a Report

  • Prepare a Report for Print

• Customizing the Access Environment

  • The Access Options Dialog Box

Prerequisites

You should be familiar with using personal computers, and should have experience using a keyboard and mouse. You should be comfortable in the Windows environment, and be able to use Windows to manage information on their computers.

Specific tasks you should be able to perform include: launching and closing applications, navigating basic file structures, and managing files and folders.