CSC105 Assignments

Your PowerPoint slides presentation must include the following:

At least 6 slides in length including each of the following types of slides:

Turning in the Assignment:

Start Microsoft Access, and create a new blank database. You need to use Microsoft Access 2010.
Please name your database "LastnameFirstnameAccess" (e.g. "SmithJohnAccess"). It must be saved in Access 2010 format.
Close Table 1. Create a table called Owners using Design View. Add a field called Owner Name and set it as the primary key. Also add fields for the Owners’ addresses (street, city, state, and zip), and phone numbers as shown in figure 1 below.
Select appropriate data types for each field. Note that the zipcode and phone numbers contain symbols other than numbers. So the number datatype is not appropriate for those fields.
Set default values for city and state.
Set input masks for zip code and phone number.
Switch to datasheet view and enter the data for the six owners shown in figure 1.
Add yourself as another owner.
Resize the columns in the Owners table to display all data.
Close your Owners table.
Create a second table called Pets using Design View. Add a field called ID with a datatype of "AutoNumber" and set it as the primary key, unless it is already present. Add fields for the remaining fields shown in figure 2 below.
Use the Lookup Wizard as the data type for Owner. In the wizard, choose Look up values in a table, select the table Owner, then add Owner Name to the Selected Fields. Accept all other values in the wizard. (Note: after the Lookup Wizard has finished, the type will show as Text because that is the type of the Owner Name field)
Use the Lookup Wizard again for the data type for the Type field. This time, choose I will type in the values I want, enter Dog, Cat, Bird, Other in 4 rows under Col1 (the rows will open up as you type). Accept all other values in the wizard.(Note: after the Lookup Wizard has finished, the type will show as Text because that is the type of the values you entered)
Choose the appropriate data type for each of the other fields so that they display as shown in the table.
Enter the data for the pets in figure 2. Do not enter anything in the ID field. Access will automatically give each pet an ID. If you set up the Lookup fields appropriately in step 8, then the Owner and Type fields should now contain pull-down lists to select the data.
Add one or more pets for yourself.
Resize the columns in the Pets table to display all data.
Save the Pets table.

Owners
Owner Name	Street	City	State	Zip	Phone
Jackson, Laura	300 New Castle Pl	Wilmington	NC	28409	(910) 542-4745
Bradwell, Carolyn	132 Johnson Ln	Hampstead	NC	28412	(910) 270-8836
Jones, Laurie	601 S. College Rd	Wilmington	NC	28403-3297	(910) 961-4402
Greene, Lydia	123 Princess Pl	Wilmington	NC	28401
Stone, Mary	601 S. College Rd	Wilmington	NC	28403-3297	(910) 961-8829
Stone, Scott	1002 Wendover	Greensboro	NC	27111	(336) 766-9651

Figure 1: Owners

Pets
Pet Name	Owner	Type	BirthYear	LastVisit	Balance
Sadie	Stone, Mary	Dog	2005	10/1/2005	$0.00
Sasha	Stone, Mary	Cat	1987	3/25/2005	$50.00
Blackie	Stone, Mary	Cat	1989	3/25/2005	$0.00
Casey	Stone, Scott	Dog	1998	6/25/2005	$130.00
Dudley	Bradwell, Carolyn	Dog	2004	7/12/2005	$20.00
Diggity	Bradwell, Carolyn	Dog	1995	7/12/2005	$20.00
Nemo	Jackson, Laura	Other	2004	10/15/2004	$525.00
Buffett	Greene, Lydia	Bird	2002	1/10/2003	$0.00
Kodi	Jones, Laurie	Dog	2004	8/28/2005	$75.25
Quincy	Stone, Mary	Dog	2003	6/8/2005	$0.00

Figure 2: Pets

Part 2: Use the Pets table for the following:

Use the Filter by Selection feature to display only dogs. Sort alphabetically by Owner. Capture the screen by pressing Alt and Print Screen. This will put a copy of that window on the clipboard. Start Word and paste your results. Remove the filter.
Use the Advanced Filter to display all pets (not just dogs) born in either 2004 or 2005. Sort in descending order by Balance. Click the Toggle Filter button to see the results. Capture these results, paste into the Word document, remove the filter, and close the table. You do not need to save the changes to the table. You will need to save the Word document with pictures of the filters to turn in with your assignment.

Part 3: Create the four queries described below using the Design View for each. Also for each query, resize the columns to display all data. Save each query (once it’s working) using the default names: query1, query2, etc.

A list of dogs containing only pet name, owner, and date of last visit sorted alphabetically by owner. (Do not display the pet type)
A list of owners and balances for accounts having balances greater than or equal to $20. Sort in descending order by balance.
A list of pet names, owner names, phone numbers, and dates of last visit between January 2003 and March 2005, sorted (ascending) by date.
A list of all dogs and cats that includes the pet name, birth year, the owner's name, address (street, city, state, zip), and the animal type sorted in descending order by birth year.

Part 4:

Using the Form Wizard, create a form based on the Pets table. Include all fields from the table. Choose Justified layout and Oriel style.
Go to Design View
Make sure the detail section is at least 2.25" tall.
Select all the fields in the "Detail Section". Then click the "Remove" button in the "Control Layout" group of the "Arrange" tab.
Resize the fields to approximately the size shown below (both label and value boxes).
Rearrange the fields to display as shown below.
Expand the Header section so that it is approximately 1”, and change the label to: ABC Veterinary Services. Make the text size 20 points, and resize the box to display it fully.
Left align all form labels and values.
Add a label to the form footer with your name and email address.
Download this picture and add it as a logo to the detail section.
Save your form.

Figure 3: Example Form

Part 5: Create a report using the Report Wizard containing all of the fields from the Owners table and the Name, Birth Year, and Date of Last Visit from the Pets table.

On the next screen of the wizard, accept the default view.
On the next screen, add a grouping level containing Owners Name.
On the next screen, sort in ascending order by pet’s date of birth.
Accept all other defaults in the wizard.
Switch to design view.
Change the label box in the report header to contain only your name.
Make sure all fields are large enough to display all information.
Save the report.

In this assignment, you will be creating a spreadsheet of the weight of an astronaut on the 8 planets (Pluto is no longer a planet!).

Turning in the Assignment:

Note: It is a really good idea for you to have a copy of your assignment on your own storage (home computer or flash disk). If there is a problem with the submission, then you will need to resubmit. The lab computers are wiped clean everytime they reboot. If the only copy of your assignment is on the lab computer then it will be gone.

For this project, you will create an essay on your favorite holiday (which can include birthdays) using Microsoft Word 2010. (Please do not use any other word processor, such as Microsoft Works, OpenOffice, or another version of Microsoft Word.) The gist of this essay is to explain to the reader why you find this holiday (or birthday) so much fun. You can include activites you normally do, why it is so enjoyable/meaningful to you, memories you have of past holidays, plans for the future, interesting facts you find on the Internet, etc. You will need to create some tables and lists, so you should gather information like: places to go to enjoy the holiday, events and schedules, activities, interesting facts, etc. The essay needs to be at least 2 pages (it can be longer if you wish).

CSC 105 Intro to Computers

Assignments

Turning in the Assignment:

Figure 1: Owners

Figure 2: Pets

Figure 3: Example Form

Turning in the Assignment:

Turning in the Assignment:

The flyer must have the following:

Turning in the Assignment: