Access databases - intermediate

Level
Total time
Logo Kingston Adult Education

Need more information? Get more details on the site of the provider.

Starting dates and places

This product does not have fixed starting dates and/or places.

Description

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.…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Microsoft Access, Microsoft Office, Microsoft Office (management), Programming (general), and IT Security.

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

There are no reviews yet.

    Share your review

    Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

    There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.