| Overview: This two day course teaches participants the skills necessary to plan and develop a database and work with data to sort and filter content, create tables and develop simple forms.
Duration: 2 days
Fee: $590 per person
Upcoming Dates:
Mar. 4-5, May 4-5
Prerequisite: Microsoft Windows: Introductory or similar experience.
Delivery: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities and assignments.
Materials: Participants receive reference materials related to course topics. Sample files used in class are available by email, or on disk. Follow up support by email or phone, on topics covered, is available to participants for 90 days.
Further Learning:
Microsoft Access: Advanced Database Design
|
|
Course Content:
The Basics
- Database Concepts
- Creating a Database
- Converting Access Files
- Working with Objects
Table Data
- Table Concepts
- Viewing Data in a Table
- Changing the Datasheet Appearance
- Entering and Editing Data
- Applying a Filter
Table Design
- The Table Wizard
- Changing the Table Design
- Creating a Table in Design View
Data Entry
- Data Entry Concepts
- Data Formats
- Input Masks
- Input Validation
- Adding Records
Relationships
- Relationships Between Tables
- Creating a Relationship
- Referential Integrity
- Removing a Relationship
- Printing Relationships
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
Queries
- Using the Query Wizard
- Creating a Query in Design View
- Selecting and Sorting in a Query
- Calculations
- Action Queries
- Parameter Queries
Reports
- Creating Reports
- Using the Report Wizard
- Previewing Reports
- Creating Reports in Design View
- Changing Report Design
- Control Operations
- Control Attributes
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
Printing
- Printing Objects
- Page Setup Options
|
|
Objectives: Upon successful completion attendees will be able to:
- Identifying the components of a database, and working with those components.
- Opening a table, finding information stored there, and entering data.
- Creating a table design from a template, and customizing it.
- Entering data into tables, and ensuring its accuracy by using input masks and input validation formulas.
- Creating relationships between tables to ensure data accuracy and to deploy referential integrity.
- Creating forms for entering data into tables, and changing the design elements that have been placed on those forms.
- Creating several query types, editing and running queries, and using action and calculation queries.
- Creating several report types, enhancing reports, and printing and previewing. reports.
- Importing and exporting data to and from various sources, including Word and Excel.
- Previewing and printing database objects, and changing the page setup options.
|
