This is a one-day non-credit course offered through the Workforce Solutions department of JSCC. Non-credit courses are not eligible for financial aid, and college admission is not required.
This one-day course is designed to introduce beginners to the fundamentals of Microsoft Access. Participants will learn essential database concepts, including tables, fields, records, and relationships. They will gain hands-on experience in creating and managing databases, designing and running queries, building user-friendly forms, and generating informative reports. By the end of the course, participants will be able to effectively use MS Access to organize, analyze, and present data.
Course Outline:
Introduction to Database Concepts
- What is a database?
- Key database terms
- Basic database design principles
Creating a Simple Database
- Launching MS Access
- Creating a new database
- Designing a table
- Entering data into a table
- Saving and closing a database
Working with Queries
- Understanding queries
- Creating a simple select query
- Running and saving a query
Creating Forms
- Understanding forms
- Creating a simple form
- Using a form to enter and edit data
Creating Reports
- Understanding reports
- Creating a simple report
- Printing and exporting reports
Additional Tips and Best Practices
- Backup and recovery strategies
- Security and permissions
- Troubleshooting common issues
The cost of the course is $160 (lunch included)
McWherter Center - 37 Alumni Drive