Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Part 2. Building a Database [Due: Week 9} Worth 15% of Final Grade Iou will continue to evolve your database design from Part 1 into

image text in transcribed
Part 2. Building a Database [Due: Week 9} Worth 15% of Final Grade "I"ou will continue to evolve your database design from Part 1 into a working database that will demonstrate the following skill components that have been introduced in the A1165 portion of the course including; - At least 10 data records in each of the tables [there may be exceptions, but use this as a guideline] - Establish reasonable and correct relationship among ALL tables in the database. Please note, that all tables must have relationships to at least another table in the database. - At least 3 different types of queries [i.e. Basic, multi-table, with calculated and derived values, summary, lter, sort, etc.) based on the data provided in the tables. - At least 1 forms to facilitate data entry. Forms must be show contrasting form design approach - At least 3 reports to display your data in an attractive and profasional manner. Reports should show a variety of techniquesl| and demonstrate different Iaut formats and be contrasting from each other in both function and style. - Demonstrated capability to export data out of Access and into Excel for further decision support analysis [Tip: Develop queries to extract data into a tabular format. During the Excel development phase of the project, you will be making a data connection to these Access query results in order to drive data into your spreadsheet for further analysis. For this phase the important thing is to have predeyeloped queries that can be used to extract and transform your data so that it can be loaded into your spreadsheet as input data source} - JDptjonal: 't'ou may also use Excel as an input data source and create a data connection to your Access Database, however, it is more common to have an Excel spreadsheet connected to a database, rather than having a database connected to an Excel spreadsheet

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_2

Step: 3

blur-text-image_3

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

Services Marketing Concepts, Strategies, & Cases

Authors: Douglas Hoffman, john Bateson

4th edition

1439039399, 978-1439039397

More Books

Students explore these related Marketing questions