Slide 1 : 1
Slide 2 : 2 Maintaining Your Address Book using Microsoft Access 2003
Instructor: Mary Wright
By the end of this workshop, you should be able to: : 3 By the end of this workshop, you should be able to: Operate a Database
Navigate the menu systems.
Use the help feature.
Minimize and maximize the database window.
Minimize and maximize the database application.
Access a Database
Open and exit database software.
Open and close a database 3. Create a Database
Design and create a new database.
Create an auto-form for data entry.
Enter data using a form.
Create and print a report..
Manage a Database
Search a database.
Scroll through a database.
Sort database records.
Edit existing data.
What is a Database? : What is a Database?
Slide 5 : 5 database 1) Often abbreviated DB. A collection of information organized in such a way that a computer program can quickly select desired pieces of data. You can think of a database as an electronic filing system.
Traditional databases are organized by fields, records, and tables. A field is a single piece of information; a record is one complete set of fields; and a table is a collection of records. For example, a telephone book is analogous to a table. It contains a list of records, each of which consists of three fields: name, address, and telephone number. http://webopedia.internet.com/
Slide 6 : 6 Here is an example of a simple database.
The database has 3 records.
Each record has 4 fields:
the Name field,
the Address field,
the City field, and
the Phone Number field TekMom's Tech Buzzwords for Students . . . . . . . . . www.tekmom.com/buzzwords
Slide 7 : 7
What are database objects? : What are database objects?
Slide 9 : 9 TABLES QUERIES FORMS REPORTS
Slide 10 : 10
Slide 11 : 11 © 2007 Microsoft Corporation. All rights reserved.
Slide 12 : 12 © 2007 Microsoft Corporation. All rights reserved.
Slide 13 : 13
Slide 14 : 14
OPEN : OPEN Microsoft Access 2003
Slide 16 : 16 Step 1: Click START.
Step 2: Click MICROSOFT OFFICE.
Step 3: Click MICROSOFT OFFICE ACCESS 2003.
CREATE A NEW DATABASE. : CREATE A NEW DATABASE.
Slide 18 : 18 Step 4: CLICK CREATE A NEW FILE…
Slide 19 : 19 Step 5: CLICK BLANK DATABASE.
SAVE A NEW DATABASE. : SAVE A NEW DATABASE. Step 6: INSERT A 3 ½ “ FLOPPY DISK INTO THE FLOPPY DRIVE A.
Slide 21 : 21 Step 7: CLICK THE DOWN ARROW TO THE RIGHT OF THE SAVE IN…BOX.
Step 8: CLICK 3 ½ Floppy (A:)
Slide 22 : 22 Step 9: CLICK THE DOWN ARROW TO THE RIGHT OF THE FILE NAME…BOX.
Step 10: PRESS THE BACKSPACE KEY TO CLEAR “db1.mdb”.
Slide 23 : 23 Step 11: TYPE A NAME FOR YOUR NEW DATABASE IN THE FILE NAME…BOX.
Step 12: CLICK CREATE.
Slide 24 : 24
CLOSE A DATABASE. : CLOSE A DATABASE.
Slide 26 : 26 Step 13: CLICK File.
Step 14: CLICK Close.
Slide 27 : 27
OPEN A SAVED DATABASE. : OPEN A SAVED DATABASE.
Slide 29 : 29 Step 15: CLICK File.
Step 16: CLICK Open.
Slide 30 : 30 Step 17: CLICK THE DOWN ARROW TO THE RIGHT OF THE LOOK IN…BOX.
Step 18: CLICK 3 ½ Floppy (A:)
Slide 31 : 31 Step 19: CLICK on the name of your database file.
Step 20: CLICK Open.
Slide 32 : 32 Step 21: Click NO.
Slide 33 : 33 Step 22: Click OPEN.
Slide 34 : 34
CREATE A NEW TABLE. : CREATE A NEW TABLE. Address Book
Slide 36 : 36 Step 23: CLICK “Tables”. CLICK “Create table by using wizard.” CLICK Open.
Slide 37 : 37 Step 24: CLICK PERSONAL.
Step 25: SCROLL DOWN under “SAMPLE TABLES:” and CLICK “ADDRESSES”.
Slide 38 : 38 STEP 26:
Under “SAMPLE FIELDS: “CLICK on the field you would like to include in your new table. CLICK the single right-facing arrow (>) to send the field to the “Fields in my new table” box.
Slide 39 : 39 Step 27: Type a name for your table in the text box provided under :
“What do you want to name your table?”
Step 28: CLICK “Yes, set a primary key for me.”
CLICK NEXT.
Slide 40 : 40 Step 29: CLICK “Enter data into the table using a form the wizard creates for me.”
CLICK the FINISH button.
Slide 41 : 41 Step 30 : CLICK in each field to enter data, or press the TAB key to travel from field to field, and from record to record.
Step 31 : To save the changes:
CLICK File.
CLICK Close.
CLICK Yes.
Type a name for your form in the Save As box.
CLICK OK.
Slide 42 : 42
CHANGE THE STYLE OF A FORM. : CHANGE THE STYLE OF A FORM.
Slide 44 : 44 Step 32: CLICK Forms.
CLICK on your address book form.
CLICK Design.
Slide 45 : 45 Step 33: CLICK the Select Form button.
CLICK Format.
CLICK AutoFormat.
Slide 46 : 46 Step 34: CLICK on the style of your choice.
CLICK NEXT.
Slide 47 : 47 Step 35: CLICK File.
CLICK Close.
CLICK Yes.
Slide 48 : 48
ENTER DATA.For practice data, copy & paste the following link in the address bar of your browser:http://tinyurl.com/35ev6m : ENTER DATA.For practice data, copy & paste the following link in the address bar of your browser:http://tinyurl.com/35ev6m
Slide 50 : 50 Step 36 : CLICK Forms.
CLICK on the name of your form.
CLICK Open.
Slide 51 : 51 Step 37 : CLICK in each field to enter data, or press the TAB key to travel from field to field, and from record to record.
Step 38: To save the changes:
CLICK File.
CLICK Close.
CLICK Yes.
SORT RECORDS : SORT RECORDS
Slide 53 : 53 Step 39 : CLICK the Sort Ascending button to sort the records from A to Z.
Slide 54 : 54 Step 40 : CLICK the Sort Descending button to sort the records from A to Z.
ADD A RECORD : ADD A RECORD
Slide 56 : 56 Step 41 : CLICK the New Record button to add a new record.
DELETE A RECORD : DELETE A RECORD
Slide 58 : 58 Step 42: CLICK the Delete Record button to delete a record.
Slide 59 : 59 Step 43: Verify that you want to delete the record by clicking Yes. If you do not want to delete the record, click No.
SEARCH FOR A RECORD : SEARCH FOR A RECORD
Slide 61 : 61 Step 44: To search for a record:
CLICK the field you want to search.
CLICK the Find button.
Type the name of the record in the
Find What text box.
CLICK in the Look In box to choose a table.
CLICK in the Match box and choose Whole Field, Any Part of Field, or Start of Field.
CLICK All, Up, or Down in the Search box.
CLICK the Find Next button.
CLICK the Close Button ?.
FILTER RECORDS : FILTER RECORDS
Slide 63 : 63 Step 45: CLICK the Filter by Form button.
Slide 64 : 64 Step 46: CLICK in the field you want to filter by.
CLICK the down arrow that appears.
CLICK the field type.
Slide 65 : 65 Step 47: CLICK the Apply Filter button.
Slide 66 : 66
Slide 67 : 67 Step 48 : CLICK the Remove Filter button.
Slide 68 : 68 Step 49 : CLICK File.
CLICK Close.
CREATE A REPORT : CREATE A REPORT
Slide 70 : 70 Step 50: CLICK Reports.
CLICK “Create report by using wizard.”
CLICK New.
Slide 71 : 71 Step 51:
CLICK Report Wizard.
CLICK the desired table on which you want your report based.
Click OK.
Slide 72 : 72 Step 52: CLICK the down arrow to the right of the Tables/Queries box.
CLICK the desired table.
CLICK the double right-facing arrow (>>) to send all the fields in your table to the “Selected Fields” box.
CLICK NEXT.
Slide 73 : 73 Step 53:
CLICK NEXT.
Slide 74 : 74 Step 54: CLICK the down arrow under the heading: You can sort records by up to four fields, in either ascending or descending order.
CLICK the field or you want to sort or you may leave it blank..
CLICK Next.
Slide 75 : 75 Step 55:
CLICK Justified.
CLICK Portrait.
CLICK Next.
Slide 76 : 76 Step 56:
CLICK on the report style of your choice.
CLICK Next.
Slide 77 : 77 Step 57: Type a name for your report in the text box provided under:
“What title do you want for your report?”
CLICK “Preview the report.”
CLICK Finish.
Slide 78 : 78 Step 58: CLICK the right-facing arrow at the bottom of the report window to go to the next page of the report.
To Print the report: CLICK File. CLICK Print. Click OK.
CLICK File. CLICK Close to close the report window and return to the database window.
Slide 79 : 79 Step 60:
To close the database you have created:
CLICK File.
CLICK Close.
To close Microsoft Access:
CLICK File.
CLICK Exit.
Slide 80 : 80 Step 59: To Close Microsoft Access:
CLICK File..
Step 60: CLICK Exit.
Slide 81 : 81
Would you like a copy of the presentation we used during class for review and practice? : 82 Would you like a copy of the presentation we used during class for review and practice? http://tinyurl.com/3y4p3d
Type the above URL in the address bar of your browser.
If you have a Google account, LOG IN.
If you don’t have a Google account, CLICK the
GET STARTED button to create one, or CLICK :
View published presentation in a new window .
to start the presentation without logging in.
Slide 83 : 83
Would you like to practice your database skills? Try the following websites to continue your education… : 84 Would you like to practice your database skills? Try the following websites to continue your education… Microsoft Access 2003 Courses
Self-paced training courses for Microsoft software are available from Microsoft. They can be accessed at: http://office.microsoft.com/en-us/training/default.aspx
Free Learning Opportunities : 85 Free Learning Opportunities www.GCFLearnFree.org This website is administered by Goodwill Industries and is supported by the Goodwill Community Foundation. GCF GLOBAL LEARNING® is a free computer and life-skill training program that
offers online learning opportunities in English and Spanish. Goodwill Industries- GCF Global Learning
Slide 86 : 86
Slide 87 : 87 To search for ebooks on ACCESS 2003:
Log onto www.plcmc.org
Click RESEARCH/HOMEWORK
Click NetLibrary.
Type Access 2003.
Slide 88 : 88
Slide 89 : 89 Join us for the next class:
Cataloging Your Household Inventory using Microsoft Access 2003