MS Access and data base entry.

The aim of this specialist course to enable proficient users to use templates to help them list, create inventories or reports. Leading to you creating your own basic database's that can link together to create reports, queries or forms to list the data you have input in different ways.

Topics covered are:

  • To do this software you will need to have competencies in MS Office or ECDL
  • Databases what are there uses
  • Computer basics on indexing and why it is important
  • Preparing your requirements, and the form layout you require
  • Designing a database view, form view
  • Linking in data bases
  • Using a wizard
  • Creating a Query and producing a report
  • Jargon explained: Primary keys, auto numbers

** As the courses are bespoke you will find some areas over lap each other.