The custom report we would like made utilizes three tables (dbo_Orders, dbo_OrderItems and dbo_OrderCharges) from our Access database. A sample database can be provided when work on the project begins. The basic coding and report fields should be very simple to program.
## Deliverables
We need a customer invoice report made in MS Access.
Attached is a mock-up of exactly how the completed invoice should look.
The custom report we would like made utilizes three tables (dbo_Orders, dbo_OrderItems and dbo_OrderCharges) from our Access database. A sample database can be provided when work on the project begins. The basic coding and report fields should be very simple to program.
**We need this to look very professional;** this is the most important aspect of the project.
The three hardest parts of this project are:
· Report must match mock-up exactly!
· Invoice paper split into 4 sections so the invoice report needs to be split into four sections to match the paper and perfectly line up
· Specific data must be allowed to spill over
Please refer to the mock-up to understand this next section. The paper we print the invoice on is divided into 4 equal sections; we want the top two sections to contain the invoice data printed over the removable stickers while the bottom left section is the Picker Information Label and the bottom right section is the Return Label. The information on the Picker Label and Return Label (i.e., the bottom two sections) must fit within the stickers because the stickers containing data will be pulled off the paper and used elsewhere.
**Please note!** For the top half of the mock-up, the store address in the upper right corner uses the font Amelie (will be provided) set at a 19 point font size. The paragraph on returns uses the font Myriad set at a 10 point font size. The title Returns Are Easy! uses Arial Bold set at a 21 point font size. All other text on the upper half is Arial Bold at an eight point font size. For the bottom half of the mock-up, the two addresses on the return labels use Myriad at 12 point font size. The order number below the barcode on the bottom left section is Arial Bold at a 14 point font size. The Item Count is Arial Bold at a 18 point font size. The items listed are Arial Bold at a 12 point font size. On the bottom right section, the store address is Amelie set at a 19 point font size. The order number below it is Myriad set at a 10 point font size and the words return and exchange are Arial Bold set at a 10 point font size.
We also need to control how data will spill over to a new page. For example, refer to the mock-up and find where the items are listed (Standard Product A, B, etc on the top half of the page in the invoice data section.). A customer may purchase over 200 items and if only six items will fit on the first page without interfering with the two labels below, we need the additional 194 items to spill onto the next sheet. A similar issue is required for the bottom left Picker Information Label. If a large number of items are ordered (meaning multiple lines show up in the inventory section of the bottom left Picker Label) then we need that data to spill onto the new sheet in the bottom left section. If a customer purchases an excessive amount of items we would expect there could be many sheets printed. This is acceptable.
**The goal is to line everything up to the mock-up since our mock-up is formatted to fit our paper exactly**.
This custom report is similar to the Northwind Database Customer Invoice Report in Microsoft Access.