Answered step by step
Verified Expert Solution
Link Copied!

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 6.4.1.1.Orders Database in your courses case narra ve you will: 1. 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 5 tuples [Records or rows] of data per table where applicable. i. Ensure one Order [OrderID] has at least 2 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. 2. 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 4 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. 3. Combine the outputs from 1c,1e, and 2c into a PDF document and submit to your eConestoga dropbox.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

Students also viewed these Databases questions

Question

A 300N F 30% d 2 m Answered: 1 week ago

Answered: 1 week ago