The skills and knowledge acquired in Microsoft Access 2013 - Module 1 (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:

• understand how Access is used and how to navigate around it
• design a database with lookup tables
• create a database structure using Access 2013
• modify the structure of an existing table
• 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
• format the data in a table
• sort and filter records in a table
• create simple and effective queries
• perform more advanced queries using a variety of querying techniques
• create meaningful reports from tables
• create and use forms