Course description
Microsoft Access- Introduction - In Company
This one-day instructor led course is designed to give an introduction to the different aspects of Access including basic design principles and effective use of an existing database. By the end of the course participants will be able to enter and edit data, extract data, and to design a new Access database table.
Why choose Keys Training
- Over 25 years’ experience of delivering quality Microsoft & Business Skills training.
- All Trainers are Microsoft Certified or equivalent.
- Scheduled Public and In-house training throughout the UK.
What’s included
All our inhouse course fees include:
- Reasonable customisation
- Trainer travel
- Handouts and supporting reference material
- Course completion certificates
About the provider
Keys Training specialise in creating and delivering focused one-day instructor-led courses that cover Microsoft Office and Personal Development skills.
Upcoming start dates
Suitability - Who should attend?
We recommend that all those who attend are able to:
- Use the mouse to select and open menus and icons
- Identify and use the Shift, Ctrl, TAB and Home keys on the keyboard
Outcome / Qualification etc.
- Understand database terminology
- Enter, edit and format data
- Create a new database table
- Design a new query to extract specified data
- Create and edit a database form for data entry and manipulation
- Create and edit simple reports to print out data
Training Course Content
Access Basics
- Exploring the Access window
- Understanding database terminology
- Viewing an existing database
- Understanding Access objects: Tables / Queries / Forms / Reports
- Looking at relationships within a database
- Understanding the function of the Primary Key
- Keyboard Shortcuts and Menu Items
Database Tables
- Understanding the difference between />fields and records
- Entering and editing data
- Moving and copying data
- Sorting and filtering data
- Finding and replacing data
- Looking at data types
- Designing a new table
- Printing data from a table
Query use and design
- Understanding the role of the query
- Modifying a query
- Creating a new query
Form Creation
- Creating a new form
- Editing data within a form
- Modifying the design of a form
Report Design
- Creating a new report
- Modifying the design of a report
Why choose Keys Training
Over 25 years’ experience of delivering quality Microsoft & Business Skills training.
All Trainers are Microsoft Certified or equivalent.
Scheduled Public and Tailored In-house training throughout the UK.
Expenses
Number and currency up to 8 attendees: £595.00
Request info
Keys Training
Keys Training® provides a Business Skills Training Service throughout the UK. We specialise in delivering one-day instructor-led courses that cover Microsoft Office and Personal Development Skills. Our training courses can be delivered on your site, at one of our venues...