Microsoft Access is a database management system that can be used to create relational database to suit your needs and requirements
Learning Outcomes
By the end of this course participants will be able to:
Understand how Access is used and how to navigate around it
Design a database with lookup tables
Create a database structure using Access 2016
Modify the structure of an existing table
Add records to a new table
Add transactional records to a lookup database
Work with the records in a database table
Sort and filter records in a table
Create simple and effective queries
Create meaningful reports from tables
Create and use a variety of forms
Prerequisites
It is recommended that participants have basic experience with the underlying operating system, i.e. an ability to navigate the environment using a mouse and keyboard plus an understanding of computer file storage.
Customisation
In addition to our standard courseware, we can adapt course content and flow to your specifications.
At G-CATS (Geelong Computer and Training Services) we have been assisting a wide range of businesses and individuals to gain maximum functionality from their computer systems over the last 20 years.
We can offer assistance with all aspects of any skills development project, including analysing skill requirements, assessing existing skills, course planning and preparation and scheduling.
To help you practise these new skills, a series of exercises will be done in class alongside your instructor. As your confidence grows, you will be able to download files from the Internet and save information to a removable storage device or USB.
This is an introductory course designed to take participants through the basics of Microsoft (MS) Excel and includes use and creation of simple spreadsheets and charts; how to create formulas, as well as working with functions and formatting techniques
A solid Intro / Intermediate for those new to spreadsheets, and for self-taught users wanting to enhance their knowledge. These courses focus on workspace familiarisation, creating and managing data, formatting worksheets, charting and creating formulas and functions.
Those who want to be able to effectively manage their emails, calendar, contacts, tasks and notes.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy