Overview
After an introduction to database concepts, Access environment and help systems, students will learn how to design and create databases. They will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules.
Who Should Attend?
This course is intended for individuals who would like to become proficient in creating database tables,queries, forms, and reports, and in sorting and filtering data in Access.
Course Outcome
On completion of this course, students will be able to:
- Organize data efficiently by using a database management system
- Plan and create a database
- Modify a table's design
- Set field properties
- Create queries and sort and filter the results,
_ Create, modify and work with forms, as well as create, modify and print reports.
Course Content:
Lesson 1:Getting started
- Database concepts
- Exploring the Access environment
- Getting help
Lesson 2: Databases and tables
- Planning and designing databases
- Exploring tables
- Creating tables
Lesson 3: Fields and records
- Changing the design of a table
- Finding and editing records
- Organizing records
Lesson 4: Data entry rules
- Setting field properties
- Working with input masks
- Setting validation rules
Lesson 5: Basic queries
- Creating and using queries
- Modifying query results and queries
- Performing operations in queries
Lesson 6: Using forms
- Creating forms
- Using Design view
- Sorting and filtering records
Lesson 7: Working with reports
- Creating reports
- Modifying and printing reports