Microsoft Access 2000 Basic
|
Tuesday, March 22,
9:00:00 AM - 4:30:00 PM
Location:
Cuyahoga County Public Library--Administration Building
Electronic Classroom
2111 Snow Road Parma, Ohio
Map
Cost:
$140 CAMLS Members
$170 Affiliate Members
$280 Non-members
Free for guests/speakers
Deadline: Tuesday, March 15,
Limit: 18
Registered Now: 3
Contact Hours: 6
**Notes:
Fee includes materials only. Lunch on your own.
|
|
This TWO DAY class teaches the fundamentals of a relational database. Students will create tables with an understanding of normalization rules, field properties, and record editing. This includes data validation, streamlining database size , and proper indexing to maximize performance. Participants will to create relational tables and use them in relational queries. Other query topics include sorting, filtering, manual vs automatic table linking, and calculated fields. Students will also be taught form creation for data entry and basic report creation.
This 2 day workshop is March 22 and March 23
Prerequisite: Microsoft Windows
Course Content
GETTING STARTED
- What is a database
- Integration
- How Access Works
WORKING WITH DATABASE FILES
- Screen Elements
- Navigating Between Records
- Editing & Sorting
DATABASE TABLES
- Purpose & Design of Tables
- Field Properties & size
- Input Masks & Default Values
QUERIES
- Purpose of Queries
- Query Criteria
- Criteria Operators
FORMS & REPORTS
- Form Area & Elements
- Formatting
- Designing & Previewing Reports
- Functions & Expressions
RELATIONAL DATABASE DESIGN
- Relationship Types
- Relational Join Lines & Queries
- Enforcing Referential Integrity
|
