Access

Microsoft Access Level 1: Capture and Store Data The Right Way 

Access is an information management tool that enables businesses to create their own applications. Access enables you to store large volumes of data, analyse the data and see valuable patterns of information emerge. 

Choice of Flexible Delivery Options: 

~  1 Day of Training 

~  2 Mornings  /  2 Afternoons  /   2 Evenings 

Programme Benefits 

Upon successful completion, learners will be able to store, track and spot relations between any type of data records; – from inventory, to contacts, to invoicing information.  Enjoy more productivity, increased data security and better insights when analysing data. 

Who Should Attend 

This course is for those who are looking for a data management tool to collect and store data; and turn that data into information. 

Learning Objectives 

Upon successful completion of this Microsoft Access Course learners will: 

• Know the Microsoft Access Terminology 

• Be able to competently navigate the Access User Interface 

• Know how to use the features in Access for database creation 

• Create and manage Tables 

• Use Queries to retrieve specific relational data 

• Use Forms for data entry 

• Generate Reports for Data Output 

Prerequisites 

For successful completion of this course, learners should be competent in using a Windows-based computer. 

Course Outline 

• Understand Microsoft Access Terminology 

• Exploring a Relational Database 

• The Access User Interface 

• Creating a Database 

• Adding Data into Tables 

• Sort and Filter data 

• Using the Query Wizard 

• Use forms for Data Entry 

• Creating Reports 

Microsoft Access Level 2: Access All Levels 

Take your access skills to the next level by completing this Access course designed to equip learners with advanced knowledge such as Macros, Relational Database Design, VBA, Integration with other Microsoft Office applications and Database Security. 

Choice of Flexible Delivery Options: 

~  1 Day of Training 

~  2 Mornings  /  2 Afternoons  /   2 Evenings 

Programme Benefits 

On successful completion of this programme, learners will know how to maintain data consistency, how to customise database components and how to share Access data with other applications. 

Who Should Attend 

This course is designed for individuals wishing to acquire additional skills and looking to expand their understanding of the many features and functions available to them in Access. 

Learning Objectives 

Upon successful completion of this Microsoft Access Course learners will: 

• Set parameters for controlling data entry 

• Create queries to relate data within a table or data from unrelated tables 

• Create customised queries 

• Enhance form design 

• Restrict data entry in forms 

• Create customised reports 

• Share data across applications 

Prerequisites 

You will need to be a frequent user of Microsoft Access with existing working knowledge of the application.  You will also need Microsoft Access installed on your computer to complete this course. 

Course Outline 

• Control of Data Entry 

• Advanced Tables 

• Advanced Queries 

• Advanced Forms 

• Advanced Reports 

• Sharing Data Across Applications