CSCI A114 / INFO I111
Lab Notes One

First semester 2001-2002

Tutorial Project One

Today in lab you should be starting Project One (pp. A1.1-63 in the lab manual).

On Friday we will verify that you have completed this project.

Here's how we will do it:

  1. we will come to each one of you
  2. and we will ask to see the tables
  3. with all the data in them, accurately entered
  4. as well as the form that you have created
  5. then you should produce a print preview of the Marina table
  6. and a print preview of the Billing Summary Report that you have created
This is your Lab Assignment One.

Homework Assignment One will be posted today (Wednesday) and will be due a week from today.

Just in case you don't have the lab manual yet I include all the notes for the first project here.

The notes below are exactly as in your lab manual, nothing is new.

Project One: Creating a database using design and datasheet views. The Bavant Marine Services database. Starting Access and creating a new database. The Access desktop and the database window. Creating a table. Defining the fields. Correcting errors in the structure. Saving a table. Adding records to a table. Closing a table and a database and quitting Access. Opening a database. Adding additional records. Correcting errors in the data. Previewing and printing the contents of a table. Creating additional tables. Adding records to the additional table.
Perform the following steps to start Access, create a new database, and save the database on a floppy disk. Place a formatted floppy disk in drive A:, click the Start button, then choose Programs, Databases, and then click on Microsoft Access.
Microsoft Access starts. Click "Create a new database using: Blank Access database."
Then click OK. The "File New Database" dialog box displays.
Look at the "File New Database" dialog box (move it around, etc). Locate the "Save in:" box, and the "Save in:" box arrow.
Only locate them. Locate the "File name:" text box and the Create button.
Now point your mouse to the "Save in:" box arrow. Click the "Save in:" box arrow.
The "Save in:" list displays. Locate the "31/2 Floppy A:" then click on it.
Now click inside the "File name:" textbox at the end of the text that appears inside it. Repeatedly press the Backspace key to delete "db1" (your number may be different).
Then type: ... as the file name. 
Bavant Marine Services
The file name is changed to "Bavant Marine Services". This will be the name of the database that you will be creating. Now point to the Create button, and click on it to create the database.
The "Bavant Marine Services" database is created. The "Bavant Marine Services: Database" window displays on the desktop. The Office Assistant, a tool you can use to obtain help while working with Microsoft Access may display.
If the office assistant displays, right-click the office assistant and then point to Hide on the shortcut menu. You should take some time to familiarize yourself with the Access desktop and the database window.
Yes, locate the following: ... and describe their functions.
  1. the Access window title bar
  2. the " :Database" window Close Window button
  3. the Access window menu bar
  4. the database window toolbar
  5. the Windows taskbar
  6. the status bar (and the message in it: Ready)
  7. the " :Database" window
Maximize the Access window and the "Bavant Marine Services: Database" window. Now you're ready for the next step.
Creating a table. Right-click "Create table in Design view".
The shortcut menu for creating a table in design view displays. Point to Open on the shortcut menu, then click on it.
The "Table1: Table" window displays. Click the Maximize button for the "Table1: Table" window.
A maximized "Table1: Table" window displays. As expected.
Now locate the following: ... and describe their functions.
  1. the status bar
  2. the upper pane (in which fields are created)
  3. the row selector (it's a small box or bar)
  4. the "Field Name" column
  5. the "Data Type" column
  6. the Description column
  7. the lower pane (in which field properties are specified)
Pressing F6 switches between the two panes.
Perform the steps below to define the fields of the table. The insertion point should be in the "Field Name" column.
Type
Marina Number
 (which is the name of the first field)
... in the "Field Name" column ... and then press the Tab key.
The words Marina Number display in the "Field Name" column ... and the insertion point advances to the "Data Type" column
... indicating that you can enter the data type. The word, Text, one of the possible data types, currently displays.
The arrow in the "Data Type" column indicates that a list of data types is available by clicking the arrow. Because Text is the correct data type, press the Tab key to move the insertion point to the Description column.
Type as the description.
Marina Number (Primary Key)
Now locate the "Primary Key" button on the database window toolbar, and point to it. A "Screen Tip", which is a description of the button, displays partially obscuring the description of the first field.
Click the "Primary Key" button to make the "Marina Number" the primary key. The "Marina Number" field is now the primary key as indicated by the key symbol that displays in the row selector.
Now press the F6 key to move the insertion point to the "Field Size" text box. The current entry in the "Field Size" textbox (50) is selected.
50 is the "Field Size" property. We need to make it 4.
Type 4 as the size of the "Marina Number" field. Press the F6 key to return to the Description column for the "Marina Number" field
... then press the tab key to move to the "Field Name" column in the second row. Field properties for the first field no longer display and the row selector moves to the second row just below the field name "Marina Number".

Correcting Errors in the Structure

When creating a table, check the entries carefully to ensure they are correct. If you make a mistake and discover it before you press the Tab key, you can correct the error by repeatedly pressing the Backspace key until the incorrect characters are removed. Then, type the correct characters. If you do not discover a mistake until later, you can click the entry, type the correct value, and then press the Enter key.

If you accidentally add an extra field to the structure, select the field by clicking the row selector (the leftmost column on the row that contains the field to be deleted). Once you have selected the field, press the Delete key. This will remove the field from the structure.

If you forget a field, select the field that will follow the field you wish to add by clicking the row selector and then press the Insert key. The remaining fields move down one row, making room for the missing field. Make the entries for the missing field in the usual manner.

If you made the wrong field a primary key field, click the correct primary key entry for the field, and then click the "Primary Key" button on the database window toolbar.

As an alternative to these steps, you may want to start over. To do so, click the "Close" button for the "Table1: Table" window and then click No. The original desktop displays and you can repeat the process you used earlier.

Use the techniques illustrated above to make the entries from the "Marina" table structure shown below ... up to and including the name of the Warranty field (which is the seventh field). 
Marina Number      Text         4    Marina Number (Primary Key)
Name               Text        20    Marina Name 
Address            Text        15    Street Address 
City               Text        15    City 
State              Text         2    State (Two-Character Abbreviation) 
Zip Code           Text         5    Zip Code (Five-Character Version)
Warranty
The additional fields are entered. A list of available data types displays in the "Data Type" column for the Warranty field.
Click the "Data Type" column arrow and then point to the Currency data type. Click "Currency" and then press the Tab key.
Make the remaining entries from the Marina table structure as detailed below. The fields should now be all entered, and the Marina table structure should now be complete. 
Marina Number      Text         4    Marina Number (Primary Key)
Name               Text        20    Marina Name 
Address            Text        15    Street Address 
City               Text        15    City 
State              Text         2    State (Two-Character Abbreviation) 
Zip Code           Text         5    Zip Code (Five-Character Version)
Warranty           Currency          Current Warranty Amount 
Non-warranty       Currency          Current Non-warranty Amount 
Tech Number        Text         2    Number of Marina's Technician
The final step is to save the table within the database. At this time you should also give the table a name.
To save the table, complete the following steps. Locate the Save button on the database window toolbar (it has a floppy disk icon on it). Click the Save button.
The "Save As" dialog box displays. Type Marina as the name of the table in the "Table Name: " text box,
... and then point to the OK button. The name of the table (Marina) displays in the "Table Name:" text box.
Click the OK button. The table is saved on the floppy disk in drive A:
The name of the table is now Marina as indicated on the title bar. Then point to the "Close Window" button for the "Marina: Table" window.
Be sure not to click the Close button on the Microsoft Access title bar, because this would close Microsoft Access). The "Marina: Table" window no longer displays. Now that you have created the table by building its structure and saving the table you're ready to add records to it.
Adding records to a table To open the Marina table and then add records to it, use the following steps.
Right-click Marina in the "Bavant Marine Services: Database" window (where the newly created table appears listed)
... and after the shortcut menu for the Marina table displays, point to Open on the shortcut menu. At this time "Bavant Marine Services: Database" window is maximized because the previous window (the "Marina: Table" window) was maximized.
If you wanted to restore the database window to its original size, you would click the "Restore Window" button. Now click Open on the shortcut menu.
The "Marina: Table" window displays. The window contains the Datasheet view for the Marina
The record selector is positioned on the first record. The record selector is the small box or bar to the left of the record.
The status bar at the bottom of the window also indicates that the record selector is positioned on record 1. Right above the status bar, near the lower left corner of the screen you will find the navigation buttons that we'll be using shortly.
Please locate the following: ... and describe their functionality.
  1. the field names in the datasheet view
  2. the space (row) for the first record
  3. the record selector
  4. the message on the status bar
  5. the navigation buttons
If your window is not already maximized, click the Maximize button to maximize the window containing the table. Type AD57 as the first marina number (as detailed below).
You often add records in phases. You may, for example, not have enough time to add all records in one session. To illustrate this process, this project begins by adding the first two records in the Marina table:

AD57 Alan's Docks 314 Central Burton MI 49611 $1,248.00 $597.75 23
AN75 Afton's Marina 21 West 8th Glenview MI 48121 $1,906.50 $831.25 36

The remaining records are added later. Be sure you type the letters in uppercase, because that is the way they are to be entered in the database.

The marina number should now be entered, with the insertion point still in the "Marina Number" field. Press the Tab key to complete the entry for the "Marina Number" field.
Then type the following entries, ... pressing the Tab key after each one.
The Name, Address, City, State and "Zip Code" fields are entered. Type 1248 as the warranty amount and then press the Tab key.
You do not need to type dollar signs or commas. In addition, because the digits to the right of the decimal point are both zeros, we do not need to type the decimal point. Type 597.75 as the non-warranty amount and then press the Tab key. Type 23 as the tech number to complete this record.
The fields may shift to the left if your screen is not wide enough. The Warranty and Non-warranty values display with dollar signs and decimal points.
The insertion point is positioned in the "Tech Number" field. Now press the Tab key. The fields will probably shift back to the right on your screen.
The first record has now been entered, and saved. The insertion point moves to the marina number on the second row, and the second record can now be entered.
Record 2 is the current record as indicated by the record selector between the navigation buttons at the bottom (located in the lower left corner, just above the status bar). Use the techniques illustrated above to add the data for the second row to the table.
The second record is added. The insertion point moves to the marina number on the third row. When you're done, you should have two records in the Marina table.
Closing a table and database. Quitting Access It is a good idea to close a table as soon as you have finished working with it.
This keeps the screen from getting cluttered and prevents you from making accidental changes to the data in the table. Perform the following steps to close the table and the database and quit Access:
Click the "Close Window" button for the "Marina: Table" window. The datasheet for the Marina table no longer displays.
Click the "Close Window" button for the "Bavant Marine Services: Database" window. The "Bavant Marine Services: Database" window no longer displays.
Click the Close button for the Microsoft Access window. The Microsoft Access window no longer displays.
Now you have a database, and a table with data inside it. To work with any of the tables, reports, or forms in a database, the database must be open.
Opening a database To open a database from the Windows desktop, click Start, Programs, Databases, and then choose "Microsoft Access".
Choose "Open an existing file". If not already selected, click the Bavant Marine Services database name (from your floppy).
The "Bavant Marine Services" database name is selected. Then point to the OK button, and click on it.
The database opens and the "Bavant Marine Services: Database" window displays. You're now ready to add additional records to its Marina table.
Adding additional records You can add records to a table that already contains data using a process almost identical to that used to add records to an empty table.
The only difference is that you place the insertion point after the last data record before you enter the additional data. To do so, use the navigation buttons found near the lower left corner of the screen.
Locate the following navigation buttons ... in the datasheet view:
  1. First Record button
  2. Previous Record button
  3. Next Record button
  4. Last Record button
  5. New Record button
The last one moves the cursor to the end of the table to a position for entering a new record.
Now you're ready to add to the remaining records to the Marina table. The records that are still to be added are listed below:

BL72 Brite's Landing 281 Robin Burton MI 49611 $217.00 $0.00 36
EL25 Elend Marina 462 River Torino MI 48268 $413.50 $678.75 49
FB96 Fenton's Boats 36 Bayview Cavela MI 47926 $923.20 $657.50 23
FM22 Fedder Marina 283 Waterfront Burton MI 49611 $432.00 $0.00 36
JB92 JT Boat Club 28 Causeway Torino MI 48268 $0.00 $0.00 36
NW72 Nelson's Wharf 27 Lake Masondale MI 49832 $608.50 $520.00 23
SM72 Solton's Marine 867 Bay Ridge Glenview MI 48121 $462.50 $295.00 49
TR72 The Reef 92 East Bay Woodview MI 47212 $219.00 $0.00 36

Complete the following steps to add to the remaining records to the Marina table. Right-click Marina in the "Bavant Marine Services: Database" window and then click Open on the shortcut menu.

The datasheet displays. Two records are currently in the table. When the Marina table displays, maximize the window by clicking the Maximize button.
Then point to the "New Record" button ... which is the rightmost navigation button.
Click the "New Record" button. Access places the insertion point in position to enter a new record.
Add the remaining records listed above to the table, using the same techniques you used to enter the first two records. All ten records are entered.
Then point to the "Close Window" button. The window containing the table closes.

Correcting errors in the data

Check your entries carefully to ensure they are correct. If you make a mistake and discover it before you press the Tab key, correct it by pressing the Backspace key until the incorrect characters are removed and then typing the correct characters.

If you discover an incorrect entry later, correct the error by clicking the incorrect entry and then making the appropriate correction. If the record you must correct is not on the screen, use the navigation buttons (Next Record, Previous Record, and so on) to move to it. If the field you want to correct is not visible on the screen, use the horizontal scroll bar along the bottom of the screen to shift all the fields until the one you want displays. Then make the correction.

If you add an extra record accidentally, select the record by clicking the record selector that immediately precedes the record. Then press the Delete key. This will remove the record from the table. If you forget a record, add it using the same procedure as for all the other records. Access will place it in the correct location in the table automatically.

If you cannot determine how to correct the data, you are, in effect, stuck on the record. Access neither allows you to move to any other record until you have made the correction, nor allows you to close the table. If you encounter this situation, simply press the Esc key. Pressing the Esc key will remove from the screen the record you are trying to add. You then can move to any other record, close the table, or take any other action you desire.

When working with a database, you often will need to print a copy of the table contents. Because the Marina table is wider substantially than the screen, it will also be wider than the normal printed page in portrait orientation.

Portrait orientation means the printout is across the width of the page. Thus, to print the wide database table, you should landscape orientation.
Landscape orientation means that that the printout is across the length of the page. A convenient way to change to landscape orientation is to preview what the printed copy will look like by using "Print Preview".
This allows you to determine whether landscape orientation is necessary and, if it is, to change easily the orientation to landscape. In addition you can also use "Print Preview" to determine whether any adjustments are necessary to the page margins.
Previewing and printing the contents of a table Perform the following steps to use "Print Preview" to preview and print the Marina table.
Right click Marina. The shortcut menu for the Marina table displays.
Point to "Print Preview" on the shortcut menu and click on it. The preview of the report displays.
Point anywhere in the upper right portion of the report. The mouse has a magnifying-glass pointer.
Click the magnifying-glass mouse-pointer somewhere in the upper right corner of the report. The portion surrounding the mouse pointer is magnified.
Not all fields display. The last field that displays is the "Zip Code" field. The Warranty, Non-warranty, and "Tech Number" fields do not display.
To display the additional fields, you will need to switch to landscape orientation. Click File on the menu bar, and then point to "Page Setup".
You might have to wait a few seconds for the entire menu to display. The File menu displays.
Click "Page Setup". The "Page Setup" dialog box displays.
Locate the Page tab and point the mouse to it. Click the Page tab.
The Page sheet displays. The Portrait option button currently is selected.
Option button refers to the round button that indicates choices in a dialog box. When the corresponding option is selected, the button contains within it a solid circle.
Clicking an option button selects it, ... and deselects all others.
Click Landscape and then click the OK button. Click the mouse pointer anywhere within the report to view the entire report.
The orientation is changed to landscape as shown by the report that displays on the screen. The characters in the report are so small that it is difficult to determine whether all fields currently display.
To zoom in on a portion of the report, click the desired portion of the report. Click the magnifying-glass mouse-pointer somewhere in the upper right corner of the screen.
The portion surrounding the mouse pointer is magnified. The last field that displays is the "Tech Number" field, so all fields currently display.
If they did not, you could decrease the left and right margins; that is, the amount of space left by Access on the left and right edges of the report.
Locate the Print button. Click the Print button to print the report.
Locate the Close button. Click the Close button when the report has been printed to close the "Print Preview" window.
The "Print Preview" window no longer displays. You can now create the second table, Technician.
Creating additional tables A database typically consists of more than one table.
The sample database contains two: the Marina table and the Technician table. You need to repeat the process of creating a table and adding records for each table in the database.
In the sample database, you need to create and add records to the Technician table. The structure and data are given below:
First the structure: 
Tech Number   Text         2     Technician Numner (Primary Key) 
Last Name     Text        10     Last Name of Technician 
First Name    Text         8     First Name of Technician 
Address       Text        15     Street Address 
City          Text        15     City 
State         Text         2     State (Two-Character Abbreviation) 
Zip Code      Text         5     Zip Code (Five-Character Version)
Hourly Rate   Currency           Hourly Rate of Technician 
YTD Earnings  Currency           YTD Earnings of Technician

Then the data:

23 Anderson Trista 283 Belton Port Anton MI 47989 $24.00 $17,862.00
36 Nichols Ashton 978 Richmond Hewitt MI 47618 $21.00 $19,560.00
49 Gomez Teresa 2855 Parry Ashley MI 47711 $22.00 $21,211.50

The steps to create the table follow. Make sure the Bavant Marine Services database is open.

Right click "Create table in Design view" and then click Open on the shortcut menu. Enter the data for the fields for the Technician table form.
Be sure to click the "Primary Key" button when you enter the "Tech Number" field. Locate the Save button on the database window toolbar after you have entered all the fields.
The entries display. Click the Save button.
Type Technician as the name of the table. Then click OK.
Click the "Close Window" button. The table is saved in the Bavant Marine Services database.
The "Technician: Table" window no longer displays. Adding records to the additional table
Now that you have created the Technician table, use the steps on the next page to add records to it. Right-click on the newly created Technician table.
The shortcut menu for the Technician table displays. Point to Open on the shortcut menu.
Click Open on the shortcut menu. The datasheet displays with three records entered.
Enter the Technician data from above into the Technician table. Click the "Close Window" button for the "Technician: Table" window.
Access closes the table and removes the datasheet from the screen. You are now ready to create a form and a report.
Project One continued: Using a form to view data. Creating a form. Closing and saving the form. Opening the saved form. Using the form. Switching between form view and datasheet view. Creating a report. Selecting the fields for the report. Completing the report. Printing the report. Closing the database. Access help system. Using the office assistant. Case perspective summary. Project summary. A1 and THQ1 due at the end of next lab.
In creating tables, you have used the Datasheet view; that is, the data on the screen displayed as a table. You also can use Form view, in which you see a single record at a time.
Using a Form to View Data The advantage with Datasheet view is that you can see multiple records at once.
It has the disadvantage that, unless you have few fields in the table, you cannot see all the fields at the same time. With Form view, you see only a single record at a time, but you can see all the fields in the record.
The view you choose is a matter of personal preference.

Creating a Form

To use Form view, you first must create a form. The simplest way to create a form is to use the New Object: AutoForm button on the Database window toolbar.
To do so, first select the table for which the form is to be created in the Database window and then click the New Object: AutoForm button. A list of available objects displays.
Click AutoForm in the list to select it. Perform the following steps using the New Object: AutoForm button to create a form for the Marina table.
Make sure that the Bavant Marine Services database is open, the Database window displays, and the Marina table is selected. Point to the New Object: AutoForm button arrow on the Database window toolbar.
Click the New Object: AutoForm button arrow A list of objects that can be created displays.
... and then point to AutoForm. Click AutoForm in the New Object: AutoForm list.
The form displays. An additional toolbar, the Formatting toolbar also displays.
(When you close the form, this toolbar no longer displays). Closing and Saving the Form
Closing a form is similar to closing a table. The only difference is that you will be asked if you want to save the form unless you previously have saved it.
Perform the following steps to close the form and save it as Marina. Click the Close Window button fr the Marina window.
The Microsoft Access dialog box displays. Point to the Yes button.
Click the Yes button The Save As dialog box displays. The name of the table (Marina) becomes the name of the form automatically. This name can be replaced with any other name.
... and then point to the OK button. Click the OK button in the Save As dialog box.
The form is saved as part of the database and is removed from the screen. The Bavant Marine Services: Database window again displays. Opening the Saved Form
Once you have saved a form, you can use it at any time in the future by opening it. Opening a form is similar to opening a table; that is, make sure the form to be opened is selected, right-click, and then click Open on the shortcut menu.
Before opening the form, however, the Forms object, rather than the Tables object, must be selected. Perform the following steps to open the Marina form.
With the Bavant Marine Services database open and the Database window on the screen, point to Forms on the Objects bar. Click Forms,
The Forms object is selected and the list of available forms displays. Currently, the Marina form is the only form. ... right-click Marina,
The shortcut menu for the Marina form displays. ... and then point to Open on the shortcut menu.
Click Open on the shortcut menu. The Marina form displays.
Using the Form You can use the form just as you used Datasheet view.
You use the Navigation buttons to move between records. You can add new records or change existing ones.
To delete the record displayed on the screen, after selecting the record by clicking its record selector, ... press the Delete key.
Thus, you can perform database operations ... using either Form view or Datasheet view.
Because you can see only one record at a time in Form view, to see a different record, such as the fifth record, ... use the Navigation buttons to move to it.
To move from record to record in Form view, perform the following step: Click the Next Record button four times.
The fifth record displays on the form. Switching Between Form View and Datasheet View
In some cases, once you have seen a record in Form view, you will want to move to Datasheet view to again see a collection of records. To do so, click the View button arrow on the Database window toolbar and then click Datasheet View in the list that displays.
Perform the following steps to switch from Form view to Datasheet view. Click the View button arrow on the Database window toolbar
The list of available views displays. ... and then point to Datasheet View.
Click Datasheet View. The table displays in Datasheet view.
The record selector is positioned on the fifth record. Click the Close Window button.
The Marina window closes and the datasheet no longer displays. Creating a Report
Earlier in this porject, you printed a table using a Print button. The report you produced included all the data in the table.
While this type of report presented the data in an organized manner, it was not very flexible. It included all the fields, but in precisely the same order in which they occured in the table.
A way to change the title was not presented. You will now create a report that features significant differences from the one before.
The new report will have a page header containing a custom title. The contents of the page header will display at the top of each page.
The detail lines, which are the lines that are printed for each record, contain only those fields you specify and in the order you specify. Perform the following steps to obtain the report:
Click Tables on the Object bar. Make sure the Marina table is selected.
Click the New Object: Autoform button arrow on the Database window toolbar. A list of available objects displays.
Click Report The New Report dialog box displays.
... and then point to Report Wizard. Click Report Wizard
The Report Wizard dialog box displays. ... and then click the OK button.
Point to the Add Field button. It's written as a > ("greater than" sign).
Selecting the Fields for the Report To select a field for the report, that is, to indicate the field is to be included in the report, click the field in the Available Fields list.
Next, click the Add Field button. This will move the field from the Available Fields box to the Selected Fields box, thus including the field in the report.
If you wanted to select all fields, a shortcut is available by clicking ... the Add All Fields button: >>
To select the Marina Number, Name, Warranty, and Non-warranty fields for the report, perform the following steps. Click the Add Field button to add the Marina Number field.
Add the Name field by clicking it and then clicking the Add Field button. Add the Warranty and Non-warranty fields just as you added the Marina Number and Name fields.
The fields for the report display in the Selected Field box. Click the Next button.
The Report Wizard dialog box displays. Completing the Report
Several additional steps are involved in completing the report. With the exception of changing the title, the Access selections are acceptable, so you simply will click the Next button.
Perform the following steps to complete the report. Because you will not specify grouping, click the Next button in the Report Wizard dialog box.
Click the Next button a second time because you will not need to make changes on the screen that follows. The Report Wizard displays. In this dialog box you can change the layout or orientation of the report.
Make sure that Tabular is selected as the layout and Portrait is selected as the orientation and then click the Next button. The Report Wizard dialog box displays. In this dialog box, you can select a style for the report.
Be sure that the Corporate style is selected and then click the Next button. The report Wizard dialog box displays. In this dialog box, you can specify a title for the report.
Type as the new title and then click the Finish button. 
Billing Summary Report
A preview of the report displays. Click anywhere within the report to see the entire report.
Click the Close Window button in the Billing Summary Report window. The report no longer displays. It has been saved automatically using the name Billing Summary Report.
Printing the Report To print a report from the Database window, first right-click the report.
Then click Print on the shortcut menu to print the report, ... or click Print Preview on the shortcut menu to see a preview of the report on the screen.
Perform the following steps to print the report: If necessary, click Reports on the Objects bar in the Database window, right-click Billing Summary Report
The shortcut menu for the Billing Summary Report displays. ... and then point to Print on the shortcut menu.
Click Print on the shortcut menu. The report prints.
Once you have finished working with a database, you should close it. Click the Close Window button for the Bavant Marine Services: Database window.
Case Perspective Summary In Project 1, you assisted Bavant Marine Services in their efforts to place their data in a database.
You created the database that Bavant will use. Within this database, you created the Marina and Technician tables by defining the fields within them.
You then added records to these tables. Once you created the tables, you printed the contents of the tables.
You also used a form to view the data in the table. Finally, you used the Report Wizard to create a report containing the Marina Number, Name, Warranty, and Non-warranty fields for each marina served by Bavant Marine Services.

Project Summary

In Project 1, you learned about databases and database management systems. You learned how to create a database and how to create the tables within a database. You saw how to define the fields in a table by specifying the characteristics of the fields. You learned how to open a table, how to add records to it, and how to close it. You also printed the contents of a table. You created a form to view data on the screen and also created a custom report.

What You Should Know

Having completed this project, you should now be able to perform the following tasks:

  1. Add Additional Records to a Table
  2. Add Records to a Table
  3. Add Records to an Additional Table
  4. Close a Database
  5. Close a Table and Database and Quit Access
  6. Close and Save a Form
  7. Complete a Report
  8. Create a Report
  9. Create a Table
  10. Create an Additional Table
  11. Define the Fields in a Table
  12. Open a Database
  13. Open a Form
  14. Preview and Print Contents of a Table
  15. Print a Report
  16. Save a Table
  17. Select the Fields for the Report
  18. Start Access
  19. Switch from Form View to Datasheet View
  20. Use a Form
  21. Use the New Object: AutoForm Button to Create a Form

What You Should Do Now

You should get started on Lab Assignment (Project) Two on which Homework One is based.

Last updated: August 29, 2001 by Adrian German for A114/I111