The skills and knowledge covered in this course are sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.
Overview:
The skills and knowledge covered in this course are sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.
The course covers the following:
Getting to know Microsoft Access
Designing a lookup database
Creating a lookup database
Modifying table structure
Adding records to a table
Adding transactional records
Working with records
Sorting and filtering
Creating queries
Creating and using reports
Creating and using forms
Learning Outcomes:
At the completion of this courseparticipants shouldbe 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
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
Corporate Training Options provides Customer Service Excellence training and Leadership Development Programs for over 7,000 clients around Australia.
Each CTO instructor has specific areas of expertise, enabling them to provide you with invaluable help when you are seeking to maximise your investment in yourself and your team. We guarantee the highest possible standard of tuition, personalised to suit your exact requirements.
Leadership Development Programs produce leaders who are capable of building and developing effective teams, which gives them a critical advantage over others in their field.
Customer Service Excellence training provides a cost-effective way of ensuring your Customer Service team are up to speed with the skills and techniques that will delight and satisfy your customers.
We also provide training in the technology you need to support your team, whether they work from a central office, or remotely.
All training can be provided onsite at your workplace, or online for distributed teams who work remotely from all around the world rather than being centralised at a single physical location.
So if you're ready to make the most of your upcoming leaders and customer service teams within your organisation, contact Corporate Training Options today for friendly, professional advice.
We'll discuss your specific needs, and tailor your training programs to develop the unfulfilled potential of both your individual leaders and your customer service teams.
For experienced Access 2010 users who are ready to use the more advanced features of Access 2010.
Excel Data Analysis Training focuses on the advance features of working with spreadsheets, using advance tabular functions, pivot analysis and dealing with Macros.
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.
Access Introductory will teach you how to create a simple database, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy