Access databases - intermediate

This Level 2 class is a progression from a Level 1 course. Basic knowledge of a computer application is helpful e.g. Word or Excel. Increase your skills in using a database. Learn more about the different data types and how to create forms and reports, how to use a combination of logical and range operators in queries, forms and reports.

Entry requirementsLearners should have reasonable mouse and keyboard skills. Basic understanding of creating database tables (or have attended Access Database Beginners course) will be of definite advantage.

What you will need for your first sessionPen, notepad and folder to contain work.

Overall course aims and objectivesLearn more about data types, e.g. field sizes, input masks, validation rules & text, etc. Construct Queries, running, saving and printing them. Use 'sorting' on different Query fields. Using and changing criteria in a Query to interrogate data held. Amending data in a Query: editing, deleting, and adding. Amending a Query construction: editing, deleting adding fields. Use different criteria to produce specific results. Create Forms using the AutoForm and wizard facilities. Create reports using the AutoReport and wizard facilities. Apply techniques from Queries to Forms and Reports, e.g. sorting, using criteria, etc.

On this course you will develop the following skills:

1. Use various data types to improve data entry in Tables;
2. Create and use simple Queries;
3. Use a combination of logical and range operators in Queries to filter the information;
4. Create Forms and Reports to provide alternative methods of viewing data held.
5. Save, retrieve, edit and print Queries, Forms and Reports.

Assessment – (homework, on line tests, and/or exams)Learners will be set a number of guided exercises to be completed during the course, which will be intended to illustrate the topics covered. Consolidation exercises will be provided to assess understanding. Discussion, questioning and feedback, personal and group, will also be used to assess the level of learning.

Progression and qualifications available from this courseAccess Advanced