Course not currently available
Access Training for New Users
Course
In London ()
Description
-
Type
Workshop
-
Class hours
8h
-
Duration
2 Days
This 2 day Access training enables you to create a fully workable database for your organisation.Taking you through the application step by step the course teaches you to create the database, add fields, import data in to the database and create queries and reports to use the data in your database succesfully.
Reviews
Subjects
- Access
- Database Design
- Database Management
- Database
- Database training
- Design
- Microsoft Access
- Database performance
- Access training
- Microsoft Access Training
Teachers and trainers (1)
Taylor Mason
Very Experienced Trainers
All our trainers are experts in their field, most of which have worked for us for some time. From 1-1 coaching to complex change programmes we have the skills and experinece. We cover, Human Resouces, Communicaton Skills, Leadership and Supervision, Microsoft & IT, Sales & Marketing, Personal Development, Health & Safety, Project Management, PA & Office Skills,
Course programme
- Have a good working knowledge of Microsoft Access.
- Be able to create a database from scratch.
- Understanding and use tables, fields and records and the rules for entering data
- Create simple queries, use forms and, ultimately create reports Understand relational databases and be able to work with related tables
During the course you cover:
Database Concepts:
- Database concepts and terminology
- Exploring the Access environment
- Planning and designing databases
- Getting help
- Closing a database and Access
Access Basics:
- Exploring tables
- Examining queries
- Exploring reports
Creating Databases:
- Creating a database
- Using the table wizard
- Working in design view
Working with Fields and Records:
- Changing the design of a table
- Adding and deleting records
- Finding and editing records
- Sorting and filtering records
Querying Tables:
- Creating and using queries
- Modifying query results and queries
- Using calculations in queries
Creating and Using Forms:
- Creating forms by using AutoForm
- Using the form wizard
- Using design view
- Finding, sorting and filtering records
Creating and Using Reports:
- Using the report wizard and queries
- Creating, modifying and printing reports
Importing, Exporting and Linking Objects:
- Importing Access objects
- Exporting Access objects
- Linking Access objects
Access Training for New Users