|
Overview
An introduction to using Microsoft Access, to create high quality
databases for analysing information.
This course also provides the skills necessary to pass the ECDL Module 5 exam. ECDL is designed specifically for those who wish to gain a benchmark qualification in computing to enable them to develop their IT skills and enhance their career prospects.
Click here for more information on the ECDL (European computer driving licence).
Prerequisites
Good practical knowledge of how to use a computer. You should be able to use a mouse to select, open and close files and folders. You need to be aware of the file storage areas, such as My documents, desktop and hard drive. You should know how to ‘copy’ and ‘paste’, minimise and maximise a window, the difference between ‘save’ and ‘save as’ and how to switch between one open application and another.
If you are unfamiliar with these topics, you may be interested in our PC Basics course.
Platform PC | Duration 2 day
Price £390 ex VAT
Course outline:
Day 1
Theory
• Database concepts
• Terminology
• Planning and designing
• Relational databases
• Keys
• Good design
Creating a database
• The Access interface
• Naming conventions
• Creating a database
• Creating a table in design view
• Entering data into a table
• Modifying the design of a table
• Finding and editing records
• Sorting Querying
• Creating a query in design view
• Running a query
• Query criteria
• Wildcard queries
• Update and append queries
• Querying multiple table databases
• Creating queries with calculations |
|
Day 2
Working with forms
• Creating Forms using the form wizard
• Creating Forms without a wizard
• Using the toolbox to add controls to the Form
• Command buttons Working with reports
• Creating Reports using a wizard
• Headers and footers in reports
• Modifying report design
• Adding calculations to reports |
| |
|
|
| |
|
|
| |
|
|
|
