Close

Microsoft Access 2013 - Module 2

INF1334
978-1-921939-92-1

The skills and knowledge acquired in Microsoft Access 2013 - Module 2 are sufficient to design and create a multi-table database, automate operations using macros, and provide a general understanding of the programming environment in Microsoft Access 2013.

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

  • design a relational database project
  • create a relational database file with multiple tables
  • set table relationships and join tables together
  • export records to and import records from a wide variety of sources and applications
  • 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
  • modify and adapt an existing form according to specific needs
  • create forms using a combination of wizards and manual techniques
  • create and use macros in Access
  • work with a number of macro techniques
  • create and work with macros in forms
  • make your Microsoft Access data and computer more secure
  • understand and use a variety of tools that ensure the wellness of your database files
  • create some simple programming code using VBA

  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