Access Intermediate Training Course
This one day course is aimed at more experienced users of Access, who, having attended the Intro course, now wish to enhance their knowledge. This course will provide the necessary skills to allow the user to create a database based on multiple tables and use macros and security to create a functional system.
Course Details
This is a structured
course with expert tuition, demonstrations and hands on practice. A
training manual or reference guide and appropriate exercises are provided.
Course Objectives
- To enable the user to create a database
- To add records to the database and retrieve information
- To print basic reports.
Course Content
- The structure of a database
- The terminology
- Designing tables
- Setting field properties in a table
- Working with tables and setting a one-to-many relationship
- Creating a drop down field
- Adding records to a table
- Designing, creating and managing forms
- Adding records using a form
- Finding and managing records
- Sorting and filtering
- Using basic queries for information retrieval
- Basic reporting
- Importing and exporting data
- Useful tips and shortcuts
Microsoft Access Training Course Locations
- West Yorkshire: Leeds, Bradford, Halifax, Huddersfield, Wakefield, Bingley, Pontefract, Castleford, Dewsbury, Keighley
- South Yorkshire: Sheffield, Doncaster, Barnsley, Rotherham
- North Yorkshire: Skipton, York, Harrogate, Wetherby, Whitby, Scarborough
- Lancashire: Manchester, Preston, Blackburn, Accrington, Burnley, Oldham, Bolton, Wigan, Liverpool, Lancaster, Stockport, Southport, Rochdale
- Derbyshire: Derby, Chesterfield, Dronfield, Long Eaton
- Nottinghamshire: Nottingham, Ilkeston, Mansfield, Sutton in Ashfield, Worksop, Hucknall, Beeston
- Lincolnshire: Lincoln, Gainsborough, Boston, Sleaford, Market Rasen, Grantham, Grimsby, Scunthorpe, Cleethorpes, Skegness
- Leicestershire: Leicester, Loughborough, Hinckley, Melton Mowbray, Coalville, Lutterworth
- Staffordshire: Stafford, Stoke-on-Trent, Wolverhampton, Walsall, Cannock, Lichfield
Contact Us
Use our simple form to contact us for further information about this course.
