Database%20Instructions%20Stock

Database%20Instructions%20Stock - tblBrokers These are...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Please create a new Database called Stock_First.mdb Import three tables tblBrokers tblCustomers tblTrades In tblBrokers make the BrokerID Field the primary index field with NO duplicates allowed In the tblCustomers make the CustId Field the primary index field with NO duplicates allowed. In the tblTrades you should have no Index field and no Primary index Once you’ve done this you have a new database with three tables.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: tblBrokers These are stock brokers. Each has a unique B Number, a Name and an Office they work out of. tblCustomers these are the Brokers Customers who buy and sell stock. They have a customer number, and name tblTrades these are the trades the brokers did for the customers for 3 days in 2004. This table has a Trade Date, Number of Shares, Price Per Share, and Customer ID...
View Full Document

This note was uploaded on 04/26/2010 for the course ACC 639 taught by Professor Mccarthy during the Spring '10 term at St. Johns Duplicate.

Ask a homework question - tutors are online