Exercise 3:


On Computer Screen


- Use the table wizard to make the table

-        Select a Personal Table

-        Choose the fields that are needed

                    1.          First Name

                    2.       Last Name

                    3.       Nickname

                    4.       Address

                    5.       City

                    6.       State or Province

                    7.       Postal Code

                    8.       E-Mail Address

                    9.       Work Phone         


                    10.     Home Phone


                    11.     Birthdate

-        The Data Type for every field should be Text, except for AddressesID (Auto/Number) and Birthdate (Date/Time)

-    Save by left clicking disk at top.  Name table Friends and Family Table. 

-        Print and hand in to teacher.



Back to Solutions Page