Length
1 Day
Course Content
Introduction to Databases
- Database Concepts
- Database Layout
- Launching Access.
- The Access Menu System
- Dialog Boxes
- Getting Help
- Creating a New Database
- Creating an Access Web App
- Closing a Database (vs Exit Access)
- Opening a Database
Tables
- Database Design.
- Creating Tables Using the Table Wizard
- Creating Tables in the Datasheet View
- Creating Tables in the Design View
- Data Types
- Field Properties
- Data Display Format Vs Input Mask
- The Input Mask
- Data Entry Problems
- Moving and Copying Records
Introduction to E-Mailing Database Information
- E-Mailing Database Information
Queries
- The Simple Query Wizard
- The Design View
- Modifying the Query
- Using Basic Criteria
- Additional Criteria
- Parameters
- Multiple Object Queries
- Custom Calculations in A Query
- Calculating Fields Continued
- Grouping Fields
Introduction to Reports
- Reports
- The Report Wizard
Working with Tables
- Pasting Records
- Sorting the Table
- Deleting a Table
- Table Layout Changes
- Find
- Replace
- Wizards
August 3, 2021 8:00 am - 10:00 am
Register Now
September 14, 2021 8:00 am
Register Now
October 12, 2021 8:00 am
Register Now
October 27, 2021 8:00 am
Register Now
