Fish4Development Business Training


Access Intermediate


Who is the course for?


If you find yourself needing to know more about what an Access database can do, this course will give you a good overview; providing practical hands-on experience with its many features.
You will finish the course with a good general knowledge on Access and how you can use it to meet your needs.

What the course will cover:


  • Database Concepts Revision
  • Database development
  • Creating a database
  • Creating tables


Field properties

  • Creating a Lookup fields (for drop down boxes)
  • Default values
  • Setting a mandatory field
  • Input masks
  • Validation rules/text


Queries

  • Creating a Sum and Count query
  • Average
  • Maximum and minimum values
  • Top Values
  • Parameter queries for a multipurpose query
  • Using wildcards in queries


Relationships

  • Looking at relationships and how they work
  • Applying relationships to tables
  • One to one relationships & Many to many relationships
  • Applying joins


Forms

  • Main/subform wizards
  • Linking forms
  • Form controls
  • Combo boxes & List boxes
  • Reports
  • Customising and modifying Reports
  • Creating Summary reports with calculations
  • Grouping reports
  • Sub reports
  • Calculating fields in a report
  • Headers and footers


Importing & exporting data


  • Time permitting Action queries - crosstab, find duplicates queries