Lab%2012%20-%20Form%20Design%20Using%20Microsoft%20Access

Lab%2012%20-%20Form%20Design%20Using%20Microsoft%20Access -...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: FORM DESIGN USING MICROSOFT ACCESS LAB 12 WHAT DO FORMS DO? • Provide user-friendly way to enter, edit, and delete data: • Navigation buttons. • Search & filter options. • Combo boxes, list boxes and other powerful controls. • Display calculated information, looked up information, graphics, and more. • Can see either one record at a time or multiple records at a time. • Can see parent and child data on same form by using sub-forms. 2 CREATING FORMS WITH THE ACCESS FORM WIZARD (STEP 1) • In the menu at the top of the window, click Create. • Click the dropdown beside the More Forms icon in the toolbar. Then click Form Wizard. • Select the table or query upon which you want to base the form. • Move the fields you want on the form to the Selected Fields list. 3 CREATING FORMS WITH THE ACCESS FORM WIZARD (STEP 2) • The form design wizard then offers four kinds of layouts. • Columnar • Tabular • Datasheet • Justified 4 FORM LAYOUT CHOICES Columnar Forms: ◦ Text boxes appear in a column down the screen but can be moved. ◦ Shows one record on the screen at a time. ◦ Used most often. Tabular Form: ◦ Text boxes appear in a row across the screen. ◦ Shows multiple records on the screen at a time. ◦ Used for tables with few fields. 5 FORM LAYOUT CHOICES (CONT.) • Datasheet Form: • Text boxes appear as in a table in rows and columns. • Shows multiple records on the screen at a time. • Justified Form: • Text boxes are spread across the screen with labels above the text boxes. • Shows one record at a time. • Used to duplicate the look of paper forms. 6 FORM VIEW & DESIGN VIEW • Form View is how users see the form and is used to enter data. • Select with • Design View is used to modify the form’s structure. • Select with 7 FORM VIEW & DESIGN VIEW (CONT.) • Note two objects on Design View identified as ShipperID. • One is a Label – unchanging text. • One is a text box – Where data is displayed for each record. 8 Labe l Text box REMOVING A CONTROL LAYOUT • All the form controls by default sized together because the Form Wizard applies. • Press Control-A to select all the controls on the form. • Click on Arrange in the menu at the top of the screen. • Click the Remove button in the Control Layout group. 9 RESIZING FORM CONTROLS • Make sure there isn’t a control layout applied....
View Full Document

This note was uploaded on 01/30/2012 for the course CNIT 180 taught by Professor Victorbarlow during the Spring '12 term at Purdue.

Page1 / 30

Lab%2012%20-%20Form%20Design%20Using%20Microsoft%20Access -...

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

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