At the completion of this course you should be able to:
understand how Microsoft Access is used and how to navigate around it
create a database structure using Microsoft Access
create a relational database file with multiple tables
modify the structure of an existing table
set table relationships and join tables together
add records to a new table
add transactional records to a lookup database
work with the records in a database table
format the data in a table
sort and filter records in a table
export records to and import records from a wide variety of sources and applications
create and use a variety of forms
modify and adapt an existing form according to specific needs
create simple and effective queries
create meaningful reports from tables
The course assumes little or no knowledge of the Access software. However, before attending this course, we strongly recommend that you attend the half-day "Introduction to Database Design" course which will introduce participants to the concepts behind designing and structuring a database before starting to use Microsoft Access.
You must have a general understanding of personal computers and the Windows operating system environment. If you need help with basic computer skills or are worried in any way whether this is the right course for you, please book a place on the Supported IT Self-Study course.
Course Leader input, demonstrations and hands-on practical sessions.