Access 2010 - Build a Database

Information

Course description

Course Overview

This course takes you through the initial stages of building an Access database. It’s a hands-on practical course which will give you the skills you need to build a simple database.  You will also gain an understanding of the theory behind why and how to relate tables within your database.

“Excellent overview of creating a database and very well explained”

Date(s)

Tuesday 14 May 2013 (1.30pm - 5.00pm)

What can I expect to cover? 

During the course we will review and discuss the pre-course reading about designing a relational database, planning your structure and relationships.

You will learn how to create tables containing different types of data and learn the principles of relating tables to each other. You will design and build a two table database to test out the theory.

What will I get out of this course? 

On completion of this course you will be able to:

  • Create a table with the correct data types and properties
  • Separate data into two related tables
  • Relate two tables to create a one-to-many relationship
  • Design and build a simple database
Who is it for?

All staff

Participant preparation needed?

You need to read about the principles of database design (7 pages) before attending the course.

Additional Information

Please see Access database courses. 

What prior experience do I need?

Before attending you must have attended Access 2010 - Introduction (or equivalent Access 2007 course) or already have knowledge of:

  • Database terminology
  • How to navigate, add and amend database records
  • How to use simple queries to extract data
Formal assessment

No.

Facilitator(s)

Teri Browett (External Trainer)

Hazel Guyler (IT Services)

Delegate places

Maximum 11 delegates

Minimum 5 delegates

How to make
your reservation

Please complete the appropriate On-line Booking Form submitting to the Staff Development Partnership.

Booking Conditions apply

Questions

About the workshop content:
Contact Hazel Guyler (IT Services) email: hmg6@le.ac.uk tel: 229-7959

About the workshop arrangements:
Contact Us at the Staff Development Partnership

For Office Use Only

Course Code: SDCCT002

 

Share this page: