Access Level 1 Introduction to Databases

Course Number: AC071	Price: $450.00
Category: Database Management	Length: 2 days

Description:

Not quite sure if it’s time to move your data from Excel to Access? Interested in learning how databases can help save you time? In this class, we will discuss the differences between Excel and Access, how to navigate and create items in Access, and how databases can save you time. We will focus on planning a database, creating tables, and building relationships. Even if you don’t need to design and build your own database, this class will demystify the underlying architecture of a database so that even someone tasked with data entry and running reports will feel more comfortable with MS Access.

· Lesson 1: Become familiar with the Access window
- Use the database window
- Examine database objects
- Understanding MDBs

· Lesson 2: Review an existing database
- Discuss the importance of tables
- Understand how tables work with other objects
- View and discuss queries
- Add data through a form
- Preview a report

· Lesson 3: Become familiar with database terminology
- Define records, fields, and values
- Understand the differences between Excel and Access

· Lesson 4: Plan a database
- Design a database
- Group items for separate tables
- Plan table relationships
- Separate items into appropriate tables and fields

· Lesson 5: Create and modify tables
- Change field sizes and format

· Lesson 6: Normalize data
- Discuss good database design
- Understand primary and foreign keys

· Lesson 7: Create relationships between tables
- Understand the different kinds of relationships
- Enforce Referential Integrity
- Cascade Update and Cascade Delete

· Lesson 8: Restrict data entry with Field Properties
- Create an Input Mask
- Create and use Lookup Fields
- Use Validation Rule and Validation Text

Prerequisites:

Excel Level 2 or equivalent experience

Class Dates:

Course Name	Start Date	Time:	Price
Access Level 1 Introduction to Databases	9/13/2010	9:00am - 4:00pm	$450.00
Access Level 1 Introduction to Databases	10/20/2010	9:00am - 4:00pm	$450.00
Access Level 1 Introduction to Databases	11/29/2010	9:00am - 4:00pm	$450.00

Return to previous page

•	Operating Systems
•	Word Processing
•	Spreadsheets
•	Database Management
•	Adobe
•	Project Management
•	Other Applications
•	Internet
•	Presentation
•	Business Skills