Access Fundamentals
Duration: 2 day | Book this course
Cost: $810.00 + GST
Course Description
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.
Prerequisites
Participants should have completed the Basic Computer Skills course or, preferably have a working knowledge of Microsoft Excel.
Who Should Take This Course
This course is designed for new users of Microsoft Access. If you are unsure, please complete a Training Needs Assessment form by clicking here or email admin@ardito.co.nz.
Course Objectives
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
Course Outline
Key concepts and Terminology
Overview of databases
- Flat file and relational databases
Designing a basic database
- Defining your needs
- Basic Design Rules
- Documentation
Objects
- Tables
- Forms
- Queries
- Reports
Working with existing database
- Navigation
- Adding data & editing
Creating a database
- Creating a flat-file database
- Creating a relational database
Working with Tables
- Setting table properties
- Define primary key
- Adding & deleting records
- Sorting and searching for data
Creating Forms
- Creating Forms and subforms
- Editing forms
- Navigating through forms
Queries
- Creating queries
- Calculated queries
Reports
- Creating, editing and printing reports
- Creating mailing labels
Data collaboration
- Importing data from Excel
- Using Access data to create a mail merge in Word