Microsoft Access - Creating Input Screens and Printing Reports
Aligned with day 3 of the Microsoft Access: Comprehensive course, this session offers training for anyone wanting to create input screens to assist with data entry and reports for formatted output from a database. As this session only covers one stage of database use, the use of input forms and printed reports, you may find the three-day comprehensive course offering a complete overview of all components of Microsoft Access a better option for your needs than simply booking onto individual day sessions.
Topics Covered
Forms and reports can turn a simple database, consisting of tables and queries, into a useable computer based information system.
This one-day course looks at the principles of creating and using input forms for data entry as well as reports for formatted printed output.
By the end of this course you will be able to:
- design and create forms to allow easy input of data into one or more related tables on information
- design and create formatted reports to extract information from tables and queries in a structured understandable layout
The topics covered by this course match some of the more advanced elements of Module 5 (Databases) of the ECDL syllabus.
Prerequisites
You must be familiar with the Microsoft Access interface and understand the use of related tables and queries. It is advisable that you have attended the Microsoft Access: Working with Information in Your Database course.
Course Duration
2 x half-day (3 hours) sessions - length of course 6 hours.
Cost
£95 for members of staff and students of Cardiff University.
£125 for non-profit making organisations, e.g. other universities, charities, and government bodies, including Cardiff and Vale University Health Board.
£150 for commercial organisations (profit-making) wishing to book anyone onto this course.