order.to.invoice.example.091709

order.to.invoice.example.091709 - Employees, Customers,...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
This example shows how an [Order Details] form presents some data to a user and allows that user to enter other data. It also shows where the data is stored [the Orders and Order Details tables] and and how the data is retrieved using the [Order Data] query. It then shows where that information is used in an Invoice [report]. 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
The figure above shows a “form” in MS access. This form allows a user to enter information into the Orders and Order Details tables. Note how this inputted information is later used to generate an invoice (shown on page 5). 2
Background image of page 2
3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
The data that is entered into the form (page 2 above) is stored in the Orders and Order Details tables. Note that the Orders table is related to
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 8
Background image of page 9
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Employees, Customers, Shippers, and the Order Details table as well as other tables and that the Order Details table is related to the Products table. These relations signify that Employees has foreign keys to Employees, Customers, and Shippers and Order Details has a foreign key to Products. 4 5 This query (shown in design view) is used by the Invoice [report] below (on page 6) to collect data from the Orders and Order Details tables, as well as the Employees, Customers, Shippers, and Products tables. 6 This is a datasheet view of the query that is in design view on page 4. Note I have selected two rows here that are used on the invoice below. 7 8 9...
View Full Document

Page1 / 9

order.to.invoice.example.091709 - Employees, Customers,...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online