Information Technology
Access 2013 – Level 1
Students will learn to organize fields and records, and to work with data entry rules. They will learn how to create basic queries, and how to work with forms and reports.
1 Day
8 Hrs
7 Lessons
Agenda
- Database Concepts
- Exploring the Access environment
- Planning and designing databases
- Exploring tables
- Creating tables
- Changing the design of a table
- Finding and editing records
- Organizing records
- Setting field properties
- Working with input masks
- Setting validation rules
- Creating and using queries
- Modifying query results and queries
- Performing operations in queries
- Creating forms
- Using Design view
- Sorting and filtering records
- Creating reports
- Modifying and printing reports
FREE
Interested in course?
Course Type: Instructor Led