Master Budget Project:Schedule of Cash Payments

摘要

This month we'll create the Schedule of Cash Payments for the Direct Materials (DM) Budget. This entails creating a new table and a series of queries to load the table with data. Then we'll create a report. Create a table called "DM Cash Payments" that has five fields: Description, Q1, Q2, Q3, and Q4. The Description field should be the primary key and have a data type of Text. The other fields should have a data type of Currency. To load the data into the table, we will need to create five queries and add a text box to the Report Menu form.