rules_for_creating_compound_form - the Students table and...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Rules for Creating Compound Forms using the Forms Wizard in Access In Access, a compound form is a form that uses more than one underlying table. The Forms Wizard can be used to create  a compound form but it's important to adhere to the following rules- 1. Build the form by adding each table in the order  that it appears in the data model. For example, a form created on the  data model below would be created by using the Students table first, then the StudentLocation table, and then the  Classrooms table.  2. When selecting fields from the underlying table do not repeat the field. For example, StudentNumber appears in both 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: the Students table and the StudentLocation table but the StudentNumber field in the Students table is the only one that should be selected. Otherwise, StudentNumber would appear twice in the form. Below is an example of a StudentLocation compound form created using the Forms Wizard. This form will allow the user to see all of the student information, the student's location information (where & time slot) as well as the capacity of the room where the student is located....
View Full Document

This document was uploaded on 11/03/2011 for the course BUS 391 at Cal Poly.

Page1 / 2

rules_for_creating_compound_form - the Students table and...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online