Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Referring to narra ve sec on 6 . 4 . 1 . 1 . Orders Database in your course s case narra ve you will:
Referring to narra ve sec on Orders Database in your courses case narra ve you will: U lizing Microso Access, you are to leverage the content within the prescribed narra ve to develop a database ACCDB and report PDF a You will be construc ng the en es Tables found within the Orders Schema component. i You need only include the en es Tables and a ributes columns from within this schema. ii iii. Any Foreign Key field within Orders Schema that connects to a Primary Key field outside of the Orders schema can be treated as a standard field, allowing the inser on of any relevant data. You are not required to build any PKs or Tables outside of Orders Schema. En es are to be named without the schema name. Orders.CustomerOrder will appear as CustomerOrder. b You are required to include tuples Records or rows of data per table where applicable. i Ensure one Order OrderID has at least products ProductID associated to it ii Insert your name and student number in a single record anywhere in the dataset. This does not need to make sense according to any other data constraints. c Take a screenshot of the Datasheet view of each data table. Ensure that all fields names and values are visible. d Create rela onships that enforce referen al integrity between the PK Primary Key FK Foreign Key f ields. e Take a screenshot of the Rela onships screen. Ensure that all tables are showing, and that all table and f ield names are fully visible. Using Microso Access Report Wizard you will develop a simple report. a The name of the report must include your first and last name. Ie For Dianne Gravel this would be DianneGravelReport This must be visible in the Report Header sec on of the report. b The body of the report must display the PK values for each of the tables, organized by ProductID in descending order. c Ensure all headings are clearly visible. Print or screenshot the first page of the report and include it in the PDF document. Combine the outputs from ce and c into a PDF document and submit to your eConestoga dropbox.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started