Access level 1
Course
In Coventry
Description
-
Type
Course
-
Location
Coventry
-
Class hours
7h
-
Start date
Different dates available
Students will learn the basic skills necessary to begin using Access, including designing and creating databases, tables, queries, forms, and reports.
Facilities
Location
Start date
Start date
About this course
Computers for Beginners or equivalent knowledge.
Reviews
Subjects
- Access
- Database
- Database performance
- Creating Tables
- Organizing Records
- Queries
- SQL
- SQL Database
- Monitoring
- Report Writing
Course programme
- Database concepts
- Exploring the Access environment
Unit 2: Databases and tables
- Planning and designing databases
- Exploring tables
- Creating tables
Unit 3: Fields and records
- Changing the design of a table
- Finding and editing records
- Organizing records
Unit 4: Data entry rules
- Setting field properties
- Working with input masks
- Setting validation rules
Unit 5: Basic queries
- Creating and using queries
- Modifying query results and queries
- Performing operations in queries
Unit 6: Using forms
- Creating forms
- Using Design view
- Sorting and filtering records
Unit 7:Working with reports
- Creating reports
- Modifying and printing reports
Access level 1