By the end of these two units, the student will gain an understanding of how to implement spreadsheets and databases using Microsoft's Access and Excel 2007 packages.
The first unit comprises the basic principles of database design and the structures and terminologies of databases. The student will develop useful skills including structuring/storageretreival and maniplation of data, the ability of creating databases with associated forms and reports, querying of data together with documenting a database.
The second unit deals with spreadsheets can be used in many different situations such as finance and engineering and the unit content includes a wide range of spreadsheet features, formulae and functions. In addition, spreadsheet users need to be able to choose from a variety of different ways of presenting and analysing spreadsheet data, including producing graphs and filtering and sorting lists of data. Successful learners will be able to combine the skills learnt to produce a spreadsheet solution that is tailor-made for the specific needs of the user.