• Design and create a MS Access database
• Understanding relationships
• Creating objects in a MS Access database
• Using tables
• Rules for table and field names
• Data types
• Indexes
• The primary key
• Simple field validation
• Using queries
• Operators and functions
• Creating and using forms

Who is it for? This course is for delegates who have used an Access database and who want to be able to modify or construct a MS Access database application.

This one-day MS Access intermediate course will provide you with the understanding and hands-on ability to create Access queries and reports using your Access database. Other design considerations are the screens for the input of data and display of reports for output.

You will learn about the rules for tables in a database, the relationships between the data in different tables understand different data types and create validation rules for checking the input of data.

Please note that in response to current demand this course is currently delivered using Microsoft Office 2003 software. If you require training on Microsoft 2007 software please let us know.

“The course was very good and I would be interested in the Advanced course at a later stage.”

PP, Tonbridge and Malling Borough Council