What opportunities will this course give me?

After completing this course you will be prepared to attend the Intermediate Access training course.

What will I be learning?

Course Syllabus:
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 Auto Form
- 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 All one-day IT courses are bespoke and not qualification-based. Training formats available:
- 1 day instructor-led at the College
- On-site at your company office UK wide
- Bespoke one-to-one basis
- Tailored training courses to your requirements. At the end of this course you will have a good working knowledge of Microsoft Access 2003 basics. You will feel more confident using Access, and be able to create a database from scratch. Understanding and using tables, fields and records and the rules for entering your data is the foundation from which you can create simple queries, use forms and, ultimately, create reports.

Why is this course for me?

Training formats available
- 1 day instructor-led at the College
- On-site at your company office UK wide
- Bespoke one-to-one basis
- Tailored training courses to you requirements

What do I need to sign up?

No formal entry requirements

Is there anything else I need to know?

Our Microsoft Access 2003 training course is suitable for complete beginners to Microsoft Access. A working knowledge of Windows is required, but no experience of Microsoft Access is needed.

Pen and paper.

Course Code

CLBUX0/ACC1

Session Venue Starts Days Time Weeks Fees* 24+ Fees*
ACC1A Eastleigh College 09:30 – 16:30 1 £103.00 £103.00 Apply now

* Please note that although this tool looks to give customers the best indication of course costs, a final cost can only be confirmed once all submitted information is verified by our information, advice and guidance team.

Need some further advice?

If you require further advice and guidance about any course costs and/or the funding options available to you, the College has a dedicated Information, Advice and Guidance team who can be contacted on telephone 023 8091 1299.