Design And Develop Relational Databases - Microsoft Access 2016

B&W printed

This course has been mapped to the BSBITA411 - Design And Develop Relational Databases competency. It applies to individuals who may work independently or within an administrative support role, with the responsibility to use databases to store and retrieve data using commercially available database software.

At the completion of this course you should be able to:

  • understand how Access is used and how to navigate around it
  • design a relational database project
  • create a relational database file with multiple tables
  • modify the structure of an existing table
  • set table relationships and join tables together
  • add records to a new table
  • add transactional records to a lookup database
  • use various data validation features in Access to protect data
  • work with the records in a database table
  • export records to and import records from a wide variety of sources and applications
  • create simple and effective queries
  • perform more advanced queries using a variety of querying techniques
  • create queries based on one or more tables
  • create and use parameter queries
  • create calculated queries
  • create and work with aggregation queries
  • create and use a series of action queries
  • create meaningful reports from tables
  • create and use forms
  • modify and adapt an existing form according to specific needs
  • create a navigation form for a database in Access 2016
  • understand how to access and use help

  View outline

View a detailed outline of the course material. You may need to install Adobe Acrobat Reader to open this file.

View Outline

  Download student files

Download working files to go with this course. Read the installation instructions for opening these files.

Download Files Zip