Scribd
Upload
5 views1 page

Report Design for Student Book Purchases

The document outlines the design of a table with specified fields and their corresponding data types for a report on book purchases. It includes instructions for entering records, generating a report that excludes the date, sorts by amount, and calculates totals for quantity and sales. Additionally, it specifies the report's heading and footer details.

Uploaded by

americanlonewolf111
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
5 views1 page

Report Design for Student Book Purchases

The document outlines the design of a table with specified fields and their corresponding data types for a report on book purchases. It includes instructions for entering records, generating a report that excludes the date, sorts by amount, and calculates totals for quantity and sales. Additionally, it specifies the report's heading and footer details.

Uploaded by

americanlonewolf111
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

TEST - Design a table and select a suitable data type for each of the field:

Field Names Data Type


#Roll Auto number
Date Date
Books Text
Qty Number
Amount Currency (USD)

Now… Enter the following records:

PRODUCE A REPORT
1. Show all fields, except date.
2. Ascending order of Amount.
3. Get the total calculated by multiplying Qty with Amount at the end of each record.
4. Create a Total-Qty field and get the total of the Qty for all records at the end of the page.
5. Get the sum of the total sale calculated at the end of the page – below total.
6. Give Heading “Books Purchased by Students”.
7. Write your Name, Center#YE100 and R#1234 at the end of the page in the footer.
REPORT IN DESIGN VIEW

Downloaded from [Link] - Where learning is just a click away

You might also like