Course description
Microsoft Access - Intermediate - In Company
This one-day instructor led course is designed for existing users of Microsoft Access who need to be able to create databases and manage data more effectively. By the end of the course participants will be able to design a new database with attractive forms for data entry and functional reports for printed management information.
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?
his course is designed for participants who have completed the Access Introduction course or have equivalent knowledge. participants should already be familiar with the different Access objects (tables, queries, forms and reports) and should be looking to develop their knowledge of database design and data manipulation.
Outcome / Qualification etc.
- Design a multi table relational database
- Create parameter queries and action queries
- Perform calculations in queries
- Create forms and sub forms
- Incorporate a graphic in a form
- Design reports with calculations
Training Course Content
Review of Access Basics
Database Design
- Creating a new database
- Understanding and modifying data types
- Setting field properties
- Assigning the primary key
- Creating relationships
- Importing data
Query Design
- Creating parameter queries
- Calculating in queries
- Using action queries: Make Table / Append / Delete / Update
Form Creation
- Creating forms with subforms
- Customising forms
- Using the forms control toolbox
Report Design
- Using calculations in reports
- Grouping and sorting data
- Creating and formatting labels
- Modifying field properties
- Adding a graphic to 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.
Reviews
Average rating 5
The course was well organised and gave me a greater understanding of the functions of Access to help develop databases. Good pace and easy to understand.
Expenses
Number and currency up to 8 attendees: £645.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...
I knew zero about Access before and now feel it's something that could be very useful to me.