The skills and knowledge acquired in Microsoft Access 2013 - Module 2 (with Challenge Exercises) ebook are sufficient to be able to create database systems; enter, edit and delete data in database files; modify and format tables; sort and validate the data; generate queries on the data; and produce information in forms and reports.

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
• understand and use a variety of tools that ensure the wellness of your database files
• create some simple programming code using VBA