Course Calendar     Log in


Register Online.

Designing and Creating Databases with Microsoft® Access 2003

Duration: 
2 days
Price: 
$745.00
Audience: 

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.
Overview: 

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 2003 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.

Topics: 

Day 1: Database Design & Creation
PART 1 – Exploring the Microsoft Office Access 2003 Environment

  • Examining Database Concepts
  • Exploring the Access 2003 User Interface
  • Using an Existing Access Database
  • Customizing the Access Environment
  • Obtaining Help

PART 2 – Designing Access Databases

  • The Relational Database Design Process
  • Defining the Database's Purpose
  • Reviewing Existing Data
  • Determining Database Table Fields
  • Grouping Fields into Tables
  • Normalizing Table Data
  • Designating Primary and Foreign Keys
  • Determining Table Relationships

PART 3 – Building Databases

  • Creating a New Database
  • Creating Tables
  • Managing Tables
  • Creating Table Relationships
  • Saving a Database as a Previous Version

PART 4 – Managing Table Data

  • Modifying Table Data
  • Sorting Records
  • Working with Subdatasheets

PART 5 – Querying Database Tables

  • Filtering Records
  • Creating Queries
  • Adding Criteria to Queries
  • Adding Calculated Fields to Queries
  • Performing Calculations on Record Groupings

PART 6 – Creating Data Entry Forms

  • Viewing Data Using Access Forms
  • Creating Forms
  • Modifying the Design of Forms

PART 7 – Creating & Printing Reports

  • Viewing Access Reports
  • Creating Reports
  • Adding Custom Calculated Fields to Reports
  • Formatting Report Controls
  • Applying an AutoFormat Style to Reports
  • Preparing Reports for Printing

Day 2: Database Customization
PART 8 – Controlling Data Entry

  • Restricting Data Entry Using Field Properties
  • Establishing Patterns for Entering Field Values
  • Creating Lists of Values for Fields
  • Creating/Populating Fields using List Tables

PART 9 – Creating Joined-Table Queries

  • Creating Query Joins
  • Joining Unrelated Tables
  • Relating Data within Tables
  • Multi-Table Query Limitations

PART 10 – Creating Flexible Queries

  • Setting Select Query Properties
  • Creating Parameter Queries
  • Creating and Using Action Queries
  • Using Make-Table and Append Queries

PART 11 – Enhancing Forms

  • Designing a Form Layout
  • Enhancing the Appearance of a Form
  • Restricting Data Entry in Forms
  • Adding Command Buttons to Forms
  • Creating Sub-Forms

PART 12 – Customizing Reports

  • Organizing Report Information
  • Formatting Reports
  • Setting Report Control Properties
  • Controlling Report Pagination
  • Summarizing Report Information
  • Adding Sub-Reports to Existing Reports
  • Creating Mailing Label Reports

PART 13 – Sharing/Analyzing Data

  • Importing Data into Access
  • Exporting Data
  • Analyzing Access Data in Excel
  • Exporting Data to a Text File
  • Merging Access Data to Word Documents
Instruction Methodology: 

You will receive a comprehensive overview of 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.

Skills Taught: 
  • Understand the basic principles and fundamental concepts of Microsoft Office Access databases.
  • Design and create tables in a new Microsoft Access 2003 Database.
  • Enter data into Microsoft Access 2003 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.