Microsoft Access Level 1
This course is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database.
Lesson 1: Exploring the Microsoft® Office Access Environment
- Examine Database Concepts
- Explore the User Interface
- Use an Existing Access Database
- Customize the Access Environment
- Obtain Help
Lesson 2: Designing a Database
- Describe the Relational Database Design Process
- Define Database Purpose
- Review Existing Data
- Determine Fields
- Group Fields into Tables
- Normalize Data
- Designate Primary and Foreign Keys
- Determine Table Relationships
Lesson 3: Building a Database
- Create a New Database
- Create a Table
- Manage Tables
- Create a Table Relationship
- Save a Database as a Previous Version
Lesson 4: Managing Data in a Table
- Modify Table Data
- Sort Records
- Work with Subdatasheets
Lesson 5: Querying a Database
- Filter Records
- Create a Query
- Add Criteria to a Query
- Add a Calculated Field to a Query
- Perform Calculations on a Record Grouping
Lesson 6: Designing Forms
- View Data Using an Access Form
- Create a Form
- Modify the Design of a Form
Lesson 7: Generating Reports
- View an Access Report
- Create a Report
- Add a Custom Calculated Field to a Report
- Format the Controls in a Report
- Apply an AutoFormat Style to a Report
- Prepare a Report for Print
Microsoft Access
We are offering a 2 day course that covers concepts on how databases work, how to build a relational database and how to query and filter your data for $399.
Includes essential topics from levels 1, 2, 3 & 4.
