Excel and Access

Ref: C2338552

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 also 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. Note the course will NOT be covering Excel for accounting.

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 but now want to develop their knowledge to include the construction and use of databases in Excel and Access

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

Pre-course work, reading and information sources

  • No pre reading is required but research on the subject on the internet or in the library may be helpful

What can I do next?

Download full course outline

Excel and Access Course Outline

Enrolment Conditions

You can enrol online if you meet all of the following requirements:

  • are paying the standard fee or are on any of the qualifying benefits
  • are paying with a credit/debit card or are not paying a fee because of a qualifying benefit
  • have a valid email address
  • have been resident in the UK, EU or EEA for the last 3 years
  • are aged 19 years or older on 1st September 2017
  • have read and accept the standard terms and conditions
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