Monday, October 29, 2007

Data Base Assignment DUE Nov 5 Start of Class

1. Complete data base started in class. Add an additional field: CSZ. Using the CONCATENATE Function, combine data in this format: City, State Zip. Your data base must have 25 records.
2. 2:00 Class Create a new field and using the concatenate function combine the AC and the phone number connected by a -. For example: 251-716-3153.
2A 4:00 Class Create a new field combining the email and the server linked together by the @ sign. For example: strange.johnedm310@gmail.com
3. Develop a data base of your own with at least four fields of data and two fields that are a combination of two or more other fields. If you have no other reason to construct a data base, do one for your CD collection, your DVD collection, or some other articles you have such as blouses, hats, etc.
4. Share all of your spreadsheets with me as a viewer. Use this email address for sharing: strange.johnedm310@gmail.com

The above projects are DUE at the start of class on Monday Nov. 5.

No comments: