Course Calendar     Log in

Register Online.

Designing and Creating Databases with Microsoft® Access 2007-2010

2 days

Beginning to Intermediate-Level Database and Microsoft Excel Users, General Managers, Database Managers, and Presentation Speakers.
This course requires the following prerequisites:

  • User Knowledge of Microsoft Windows XP or Vista.
  • Knowledge of Microsoft Word and/or Microsoft Excel helpful, but not necessary.

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational database tools. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their associated objects using the Microsoft Office Access relational database application. In addition, you will also consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.


Section 1: Getting Started

  • Starting Out
  • Interface Basics
  • Database Security
  • Getting Help

Section 2: The New Interface

  • The Quick Access Toolbar
  • Basics of Tabs
  • The Home Tab
  • The Create Tab
  • The External Data Tab
  • The Database Tools Tab

Section 3: Creating a Database

  • First Steps
  • About Records
  • Creating a Table
  • Formatting Text

Section 4: Doing More with your Database

  • Creating and Using Forms
  • Creating and Using Queries
  • Creating and Using Reports
  • Sorting and Filtering Data
  • Viewing Data
  • Printing a Database Object
Instruction Methodology: 

You will receive a comprehensive overview of the new features of Microsoft Access and the fundamental design changes affecting using the product via the new Ribbon interface, along with detailed best practices on how to quickly configure and implement databases and database tables using the Microsoft Access environment.
You will also receive detailed strategies and practices for table field property use and validation, examples of effective advanced query creation and usage, along with additional hints and direction for further future customization of forms and reports using Visual Basic for Applications. The training in this course includes techniques and features of versions 2007 and 2010.

Skills Taught: 
  • Understand the basic principles and fundamental concepts of Microsoft Office Access databases.
  • Design and create tables in a new Microsoft Access 2010 Database.
  • Enter data into Microsoft Access 2010 database tables.
  • Filter table data and create criteria for basic queries to access, display, and sort the table data.
  • Create basic entry forms for easier table input.
  • Create basic paper-based reports for table/query output.
  • Maintain database consistency and integrity through use of table properties, such as field settings, input masks, and validation methods.
  • Design and utilize advanced multi-table queries, cross-tabulation queries and parameter queries and criteria.
  • Customize Access data forms to provide for more flexible options for data input.
  • Customize Access reports to better control and summarize data on table/query print-outs.