NETWORKING+CONTACTS


 * Having a database of local businesses at your fingertips wlll make networking fast and easy.**

The Chamber of Commerce is an excellent resource for making connections in the local business community. A business networking database should include the business name, contact person, mailing address, email address, and phone numbers.

//You will create a database of business contacts that you obtained as a member of the Chamber of Commerce.//


 * Strategies:**
 * Research the names of businesses in the community and use either real or fictitious contact information for those businesses in your database.
 * Be consistent with capitalization and abbreviations when entering data into records.
 * Verify the accuracy of the data returned in the Query

// Refer to Amanda's example for guidance. Do not copy the content or design of the example //
 * Instructions: **


 * 1) Create a new blank database.
 * 2) Create a new Table in Design View.
 * 3) Set up the database Table by using the database structure provided below.


 * Note:** //Database setup may vary based on which version and application you are using//


 * Field Name || Data Type ||
 * Business Name || Short or Long text ||
 * Street || Short or Long text ||
 * City || Short or Long text ||
 * State || Short or Long text ||
 * Zip Code || Short or Long text ||
 * First Name || Short or Long text ||
 * Last Name || Short or Long text ||
 * Email || Short or Long text ||
 * Type || Short or Long text ||

4. Save the Table as "//Chamber Contact List"// without defining the Primary Key. 5. Go to Datasheet View and enter the data for each record. 6. Adjust the Field Name column widths as necessary. 7. Carefully proofread your work for accuracy, format, spelling, and grammar, then resave. 8. Create a new Query in Design View that displays the business name, street, city, state, and zip code for each Chamber contact that has the type "Office" 9. Save the Query as "//Chamber Contacts Office//"

[|Amanda's Business Networking Contacts] //Do not duplicate Amanda's work//