Microsoft Access Fundamentals

This class takes participants through the basics of Microsoft Access – from understanding database terminology all the way through to creating a basic database.  Topics include: working with existing databases; creating new databases and working with objects (tables, forms, queries and reports).

Participants are shown how to plan, create, edit and print objects. Participants will also learn how to create, manage, and modify basic table relationships.  In addition, the course will cover how to import and export data in Access.

Upon completing this course, you will have learned how to:

• Key concepts and Terminology
• Designing a database and documentation
• Working with existing databases (navigating, adding and editing data)
• Creating a flat-file & relational database
• Working with and creating Tables
• Creating basic forms and subforms
• Creating and editing Queries (including calculated queries)
• Creating and editing Reports
• Creating mailing labels
• Importing data from Excel
• Using Access data to create a mail merge in Word