Course description

Excel Access & Databases:

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. A course for students wishing to learn how to construct, populate and analyse data in Excel Spreadsheets and MS Access.

Additional entry requirements

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.