Microsoft Access 2013 Advanced: The Receipt Form, part 2
Microsoft Access 2013 Advanced: The Receipt Form, part 2
Project: Create and format a Receipt Form that uses a Combo Box to look up a customer by their phone number

This is Part 2 of a two-part lesson!

Advanced Access Objectives
1. Create a Select Query that combines (JOINS) several Tables by matching Keys.
2. Create a Blank Form and select a Query as the Record Source in the Form Properties.
3. Add existing Fields to a Form.
4. Add a Subform and Link the Form and Subform by three Key Fields.
5. Test the Receipt Form, see if it works

Another Computer Mama Guide:

If you wish to prepare for Certification Exam 77-424: Microsoft Office Access 2013 this course will help you build the skills and knowledge you need.
• Step-by-step video demonstrations
• Companion eBook with detailed instructions
• Sample databases
• Practice, Quizzes and Skill Test

All materials for this program are available online.

In Microsoft Access, you’ll cover basic through advanced topics, including:
• Learn how to navigate the online course and submit your assignments
• Understand the purpose of Tables and how they are used in a database
• Edit the Form Properties to help Users navigate the Form Fields and enter data
• Learn how to design Queries and use Queries to lookup records in the Tables
• Use Query Criteria and Parameter Queries to select specific records in the Tables
• Learn how to design and modify Reports in Layout and Design Views
• Learn how to manage Database files: Save and Save As

The Microsoft Access 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite.

Students who wish to prepare for Microsoft Certification Exam 77-424: Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics.

This course teaches the objectives for the following certification tests:
Expert Certification:
Access® 2013: Exam 77-424



(25% off)

Save for later
  • Access2013_Adv_Form2.pdf

About this resource


Created: Aug 18, 2016

Updated: Feb 22, 2018


pdf, 11 MB



zip, 80 MB


Report a problem

Tes Paid License

How can I re-use this?