Excel Access & Databases

Ref: C2341201

The course will look at the use of MS Excel as a database and will teach students how to construct populate and interrogate information in an excel spreadsheet. The course will include the construction of an Access database including constructing forms, queries and reports. The course will be a very practical hand on approach with projects based on real life needs and real situations rather than the theory of spreadsheets and databases.

Course aim

A course for students wishing to learn how to construct, populate and analyse data in Excel Spreadsheets and MS Access

Do I need any particular skills or experience?

  • This course is for improvers
  • The course is for students who already have a grasp of using excel for accounts and finance. Students should also be proficient in the use of Windows and saving and moving files.

By the end of the course I should be able to:

  • Create a simple excel database
  • Sort/filter and analyse information in a database including conditional formatting
  • Protect data integrity by the use of data validation and password protection
  • Construct a simple Access database and populate it
  • Construct forms, queries and reports in an Access database

How will I be taught?

  • The WEA tutor will use a range of different teaching and learning methods and encourage you and the group to be actively involved in your learning
  • You may be asked to undertake additional work in your own time to support your learning

What kind of feedback can I expect?

  • A range of informal activities will be used by the tutor to see what you are learning which may include quizzes, question and answer, small projects and discussion
  • You will have opportunities to discuss your progress with your tutor
  • You will be encouraged to share your work with the group and discuss your learning
  • You will be encouraged to consider other students work and give your opinions and suggestions
  • A file of work will be kept which will help to record your progress

What else do I need to know?

  • If students have any real situations that they need to work on, for example through voluntary work or home situations, they are encouraged to bring them and work on them during the course

Pre-course work, reading and information sources

  • No pre reading or pre course work is required

What can I do next?

  • Progress to another WEA course
  • Progress to a course with another provider
  • This course could lead to a range of job opportunities. Follow link to National Careers Service for more details https://nationalcareersservice.direct.gov.uk/
  • Become involved with the WEA in a range of voluntary work and other activities including campaigning as a WEA member
  • Become involved as a volunteer for a WEA partner or another organisation

Download full course information sheet

Excel Access & Databases

Enrolment Conditions

As a registered charity, and to meet our funders’ requirements, we need to check a few things with you before you book. Please could we ask that you check the list below to ensure you meet our basic criteria:

  • You are paying the standard fee (with a credit or debit card) or you are on any of the qualifying benefits
  • You have a valid email address so that you can receive confirmation of your booking
  • You have been resident in the UK, EU or EEA for the last 3 years
  • You are aged 19 years or older on 1st September 2018
  • You have read and accept our standard terms and conditions

Not sure or have further questions? Contact courseenquiries@wea.org.uk

Visa Credit payments supported by RBS WorldPay Visa Debit payments supported by RBS WorldPay Visa Electron payments supported by RBS WorldPay Mastercard payments supported by RBS WorldPay Maestro payments supported by RBS WorldPay JCB payments supported by RBS WorldPay Solo payments supported by RBS WorldPay
RBS WorldPay Payments Processing