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

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

Info iconThis preview shows pages 1–4. 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
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: L AB 12 F ORM D ESIGN U SING M ICROSOFT A CCESS ACCESS FORMS Forms display and allow entry to records in a table. A form provides a more user-friendly way than either tables or queries for users to enter and edit information. The use of forms was explored in Lab 1. You may want to review that lab to refresh your memory. In this lab we will learn how to create forms. CREATING A TABULAR WITH THE ACCESS FORM WIZARD As with reports, Microsoft Access provides a wizard that leads you through form creation and does a lot of the work for you. You don't have to use the wizard, but many Access developers find it faster in the long run to let the wizard create the form and then manually modify it. That is what we will do. Do the following: If you have not already done so, launch Microsoft Access and the special version of the Northwind database that works with these labs. 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. You will see the wizard dialog box shown here. Let's assume we want to build a form on the Shippers table. From the Tables/Queries dropdown box, select Table: Shippers. You will then see the fields of the Shippers table in the Available Fields box. Move them all to the Selected Fields box using the buttons in the middle of the screen. Click Next. CNIT 180: Lab 12 - Form Design Using Microsoft Access Page 1 The form design wizard then offers the four kinds of layouts shown here. They are each illustrated and described below. Columnar Forms o Text boxes appear in a column down the screen but can be moved. o Shows one record on the screen at a time o Used most often Tabular Form o Text boxes appear in a row across the screen o Shows multiple records on the screen at a time. o Used for tables with few fields. Datasheet Form o Text boxes appear in rows and columns as in a table. o Shows multiple records on the screen at a time Justified Form o Text boxes are spread across the screen with labels above the text boxes o Shows one record at a time o Used to duplicate the look of paper forms CNIT 180: Lab 12 - Form Design Using Microsoft Access Page 2 For our wizard, select Tabular. The Shippers table has few fields and few records. It will work well as a tabular form. Click Next. Next you can select a style for your form. For our purposes, highlight Office and click Next. On the final screen you will be asked to enter a name for the form. Use the default name of Shippers and click Finish. The wizard-built form will appear as shown next. FORM VIEW AND DESIGN VIEW There are two ways to view forms. You can switch between the views by clicking the Design View icon and the Form View icon in the bottom right of the screen. Form View (shown below) is how users see the form. Form View is used to enter data....
View Full Document

Page1 / 22

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

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

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