Last month we created autoforms to use for data entry and navigation. This month we will create a query that will collect data to be used for our first report-a Materials List similar to the listing of materials on the Excel Budget sheet. Figure 1 shows the Material table after we have entered data. Notice that it includes the Product Number and Part Number. This is important because those fields are needed for the unique Materials Lists for the bikes. In essence, this table relates the bicycle parts to the products. This is a critical relationship needed to make the database effective.
展开▼