A form is an Access object used to enter records into a database or to view one record at a time. In the form, the fields are laid out in a visually appealing format on the screen.
Because a form is usually designed to display only one record in the database at a time, a form is useful not only to the individual who performs the data entrytyping in the actual recordsbut also to anyone who has the job of viewing information in a database. For example, when you visit the Records office at your college to obtain a transcript, someone displays your record on a screen. For the viewer, it is much easier to look at one record at a time, using a form, than to look at all the student records in the database table.
There are various ways to create a form in Access, but the fastest and easiest is to use AutoForm. AutoForm incorporates all the information, both the field names and the individual records, from an existing table or query and then instantly creates the form for you. Records that you edit or create using a form automatically update the underlying table(s). In this activity, you will create an AutoForm and then use it to add new club members to the database.
Using the technique you practiced in Chapter 1, open My Computer, and then navigate to the location where you will store your projects for this chapter. Create a new folder named Access Chapter 3
Locate the file a03A_Fundraiser from the student files that accompany this text. Copy and then paste the file to the Access Chapter 3 folder you created in Step 1. Rename the file as 3A_Fundraiser_Firstname_Lastname Close My Computer, start Access, and then open your 3A_Fundraiser database.
Open the Club Members table in Datasheet view, and notice the five fieldsStudent#, First Name, Last Name, Phone, and Email Address. Close the table. Be sure the Club Members table is still selected, and then on the Database toolbar, click the New Object: AutoForm button . Compare your screen with Figure 3.2.
In the navigation area, click the Next Record button three times.
In the navigation area, click the Last Record button to display the record for Justin Hill, and then click the First Record button to display the record for Ranjan Biswas.
On the Form View toolbar, click the Save button . In the displayed Save As dialog box, accept the default nameClub Membersby clicking OK.
Chapter One. Creating Documents with Microsoft Word 2003
Chapter Two. Formatting and Organizing Text
Chapter Three. Using Graphics and Tables
Chapter Four. Using Special Document Formats, Columns, and Mail Merge
Chapter One. Creating a Worksheet and Charting Data
Chapter Two. Designing Effective Worksheets
Chapter Three. Using Functions and Data Tables
Chapter One. Getting Started with Access Databases and Tables
Chapter Two. Sort, Filter, and Query a Database
Chapter Three. Forms and Reports
Chapter One. Getting Started with PowerPoint 2003
Chapter Two. Creating a Presentation
Chapter Three. Formatting a Presentation
Chapter One. Using Access Data with Other Office Applications
Chapter Two. Using Tables in Word and Excel
Chapter Three. Using Excel as a Data Source in a Mail Merge
Chapter Four. Linking Data in Office Documents
Chapter Five. Creating Presentation Content from Office Documents
GO! with Microsoft Office 2003 Brief (2nd Edition)
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]