Microsoft Access: Introduction

Title:Microsoft Access: Introduction

Duration:2 days
Central Short Courses

Learning Outcomes:

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

Pre-requisites:

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.

Process:

Course Leader input, demonstrations and hands-on practical sessions. 



Book whole Programme
Location
Start Date
All Dates
Times
OtherTimes
Places Left
Tutor
Price
Funding can be used
 
 
 
 
 
 
 
 
 
 
 
 
University Park
24 July 2019
24/07/2019 00:00:00
24, 25 July 2019
9:30 AM - 4:00 PM
7
Teri Browett
£ 0.00
No