• Microsoft Access Intermediate

  • Availability/Duration

    This is a 1 day course.

  • Cost

    80.00

  • Start Date

    From 13 Nov 2017

  • Campus Availability

    Ayr

What's involved

On completion candidates will understand relational databases and be able to work with related tables. They will also be able to create efficient forms and reports, and create Macros to automate these forms.

Course Content:

Creating relational databases
  • Database normalising
  • Introducing relating tables
  • Adding referential integrity
  • Working with related tables
  • The lookup wizard
  • Changing lookup fields
  • Inputting data to related tables
  • Defining data entry rules
  • Using input masks
  • Setting a property
  • Setting a validation rule
  • Using advanced query features
  • How to join a query table in queries
  • Creating a calculated field
  • Creating advanced queries
  • Summarise and group values
  • Create a crosstab query
  • Using a parameter query
  • Creating advanced form design
  • Working with graphics
  • Working with calculations
  • Working with combo boxes
  • Working with unbound controls
  • Using advanced report features
  • Create customized headers and footers
  • Add a calculated value
  • Our Microsoft Access Intermediate course is suitable for those with a basic working knowledge of Microsoft Access (Databases).

    Funding and Fees

    For further information on potential funding and fees please call 0300 303 0303, then press option 4 or email: businessdevelopment@ayrshire.ac.uk

    Enquiries

    For further information call 0300 303 0303, then press option 4 or email: businessdevelopment@ayrshire.ac.uk