Microsoft Access 2000 - 2003 Level 1 - Database Design (D1N1B)
Classroom Learning
Classroom Learning
Also available via
Who Needs to Attend
Those who are new to Microsoft Access 2002000/2002/2003
Prerequisites
Working knowledge of Windows 95, Windows 98, Windows NT 4.0, or Windows 2000
Follow-On Courses
There are no follow-ons for this course.
In this two-day instructor-led course, you will be introduced to the basics of Microsoft Access 2000-2003. You will learn to identify and work with the components of a database, including table design and customization, and entering data. You will also create several types of queries, edit and run queries, and use action and calculation queries. Finally, you will create several types of reports, enhance them in a variety of ways, and print reports.
What You'll Learn
- Identify the components of a database, and work with those components
- Open a table, find information stored there, and enter data
- Create and customize a table design
- Enter data into tables, and ensure its accuracy by using input masks and input validation formulas
- Create relationships between tables to ensure data accuracy and to deploy referential integrity
- Create forms for entering data into tables, and change the design elements that have been placed on those forms
- Create several query types, edit and run queries, and use action and calculation queries
- Create several report type, enhance reports and print preview reports
- Import and export data to and from various sources, including text files and Excel
- Preview and print database objects, and change the page setup options
Course Outline
1. The Basics
- Getting Started
- Creating a Database
- Converting Access Files
- Working with Objects
2. Table Data
- Table Concepts
- Viewing Data in a Table
- Changing the Datasheet Appearance
- Entering and Editing Data
- Applying Filters
3. Table Design
- The Table Wizard
- Changing the Table Design
- Creating a Table in Design View
4. Data Entry
- Data Entry Concepts
- Data Formats
- Input Masks
- Input Validation
- Adding Records
5. Relationships
- Relationships between Tables
- Creating a Relationship
- Referential Integrity
- Removing a Relationship
- Printing Relationships
6. Creating and Using Forms
- Creating a Form Using AutoForm
- Creating a Form Using the Form Wizard
- Creating a Form in Design View
- Opening a Form
- Changing a Form Design
- Adding Controls
- Placing Controls
- Multiple-Choice Controls
- Error Checking
7. Queries
- Using the Query Wizard
- Creating a Query in Design View
- Selecting and Sorting in a Query
- Calculations
- Action Queries
- Parameter Queries
8. Reports
- Creating Reports
- Using the Report Wizard
9. Previewing Reports
- Creating Reports in Design View
- Changing Report Design
- Control Operations
- Control Attributes
10. Importing and Exporting Data
- Importing and Exporting
- Importing a Text File
- Importing Data from an Access Database
- Exporting Data
- Exporting Data Using Office Links
- Troubleshooting Importing and Exporting Problems
11. Printing
- Printing Objects
- Page Setup Options
Classroom Dates and Locations
Don’t see the location or date you need? No problem – just use our By Request service.
Course Code: 8658
Registration Information
$590 CAD
2 Day Course
Microsoft Course: D1N1B
Practice Files
RSS