For this application, you'll use a Microsoft Access database to hold the stocks that you are tracking. The database is called Ch13.mdb and is placed somewhere accessible by the application you'll be building. Ch13.mdb contains one table called tblStocks, whose structure is as follows:
Field Name | Data Type | Length |
---|---|---|
StockID | Text | 5 |
LowPriceAlert | Currency | |
HighPriceAlert | Currency | |
CurrentPrice | Currency | |
LastPriceAlert | Date/Time |
The only field that is required is the StockID, which is also the primary key for the table. All the fields in the table will be provided for each row based on the stocks that you choose to watch.