Thursday, May 5, 2011

Babbage Bookkeeping Database
Create the Babbage Bookkeeping Database

1. Create the Client Table following directions
2. Create the Bookkeeper Table
3. Make a query and display the Client Number, Name, and Bookkeeper Number for all clients with 24 as the Bookkeeper. Save the query as Clients of Mario Rodriguez
4. Make a report titled Balance Due Report
5. Finish any unfinished database assignments.
6. Test on Friday

Wednesday, May 4, 2011

Database Assignments

• Create a database called U.S. Presidents Database
• The field names of your table will be:
• President Name - Primary Key
• Political Party
• Years
• All data will be text
• Save the table as Presidents
• Using the Presidents table. Create a form and report
• Make two queries. One will be called :
• Democratic Presidents
• Whig Presidents

Atlanta Hawks Database

2010-11 Roster
NUM	PLAYER	POS	HT	WT	DOB	FROM	YRS
31	Hilton Armstrong	C-F	6-11	235	11/23/1984	Connecticut	4
34	Jason Collins	C	7-0	255	12/02/1978	Stanford	9
11	Jamal Crawford	G	6-5	200	03/20/1980	Michigan	10
6	Kirk Hinrich	G	6-4	190	01/02/1981	Kansas	7
15	Al Horford - C	C-F	6-10	245	06/03/1986	Florida	3
2	Joe Johnson - C	G	6-7	240	06/29/1981	Arkansas	9
27	Zaza Pachulia	C	6-11	275	02/10/1984	Tbilisi, Georgia	7
12	Josh Powell	F	6-9	240	01/25/1983	North Carolina State	5
25	Magnum Rolle	F	6-11	235	02/03/1986	Louisiana Tech	R
5	Josh Smith - C	F	6-9	240	12/05/1985	Oak Hill Academy (Mouth of Wilson, VA)	6
19	Pape Sy	F-G	6-7	225	04/04/1988		R
0	Jeff Teague	G	6-2	180	06/10/1988	Wake Forest	1
36	Etan Thomas	C	6-10	260	04/01/1978	Syracuse	8
3	Damien Wilkins	G-F	6-6	225	01/11/1980	Georgia	6
24	Marvin Williams	F	6-9	240	06/19/1986	North Carolina	5

Create a database called Atlanta Hawks.

Create a table called Atlanta Hawks with the following fields:

·        Player Number- primary key

·        Name of Player

·        Position

·        Height

·        Weight

·        Birthday Month—data type should be lookup wizard. Type in all months

·        College

·        Years in NBA 

        All data will be text.

        The table should be sorted by Position.

        Make a form and report of the Player’s Name, College, and Years in NBa.

        Make the following queries:    

·        240 Pound Players-include all fields

·        Players with 5 Years Experience—include the fields of Player Number, Name of Player, Position, and Years in the NBA

·        Players with 6 Years Experience- include the fields of Player Number, Name of Player, Position, and Years in the NBA

·        Birthdays in February-include the fields of  Name, Birthday Month

·        Birthdays in June- include the fields of Name, Birthday Month

Save all queries with appropriate name.

Tuesday, May 3, 2011

Create the City Guide Database

• Create the Advertiser Table
• Ad Rep Table
• Create a form using the Advertiser table
• Use the form and make correction listed on handout
• Create a query to find which accounts Kyle Martinson represents.
• Prepare a report listing the advertiser's number, name, balance currently owed, and paid to date

Monday, May 2, 2011

Database Vocabulary
Open a blank word document and type the definitions using your handout of the following words:

1. database
2. database management system
3. record
4. field
5. unique identifier
6. primary key
7. query
8. data entry and update

Changing Data, Creating Queries, and Creating Reports Handout
The name of the database is Birds2U
The first table will be saved as Item table.
The second table will be saved as Supplier table.

Create a form for the supplier table.
Make a report titled Inventory Report with the item code, description, on hand, and cost include.