Access Case #1 IS 2000 Databases are critical in business as they store a large amount...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Access Case #1 IS 2000 Databases are critical in business as they store a large amount of data for an organization, and various tools within the database are used to later retrieve and analyze this data. In this portion of the course you will be building a comprehensive database that will assist management/ students of a college to determine appropriate information relating to courses for the coming semester. In this segment, you will be helping determine what professors will be teaching what courses. You will need the following two tables. Create the database using the name [yourname]Casel accdb. tblCourse Course Title Course Number Professor ID Semester Hours 101 Surviving College BN 4 102 Intro to Accounting DS 103 Intro to Economics ED 104 Intro to Management Information Systems BN 105 Into to Entrepreneurship DS 3 tblProfessor Professor ID Professor Name BN Bethany Niese DS Daniel Smith ED Emily Donald 1. Create the two tables. Create the two tables above in Design mode. Use the data types of number and short text where appropriate. Make appropriate choices for primary keys and foreign keys. 2. Create the relationship Create a relationship between the tables using the Primary Key of Professor ID in tblProfessor and the Foreign Key Professor ID in tblCourse. 3. Create queries 1. Create a query that shows what classes will be taught by Bethany Niese. The query shows Professor Name and Course Title Name the Query gryBethany. 3 5 Ford Help O O Search tblCourse Query tblProfessor Query tblProfessor Professor D Professor Name Field: tblProfessor Professo Professor Name Table: tblProfessor tblProfessor Course Title tblCourse Sort Show: Criteria: "BN ☐ M 5 or: tblProfessor Query tblCourse Query Professor Name. Bethany Niese Course Title Surviving College Intro to MIS Bethany Niese 2. Make a copy of gryBethany, Change the criteria so that now the query shows you the courses taught by Daniel Smith. Name the query gryDaniel gryBethany tblProfessor ps Professor Name Course Number Daniel Smith Course Title tblCourse_Profe- Semester Hours - 102 Intro to Accountin DS DS Daniel Smith 105 Intro to Entrepren DS 3. Create a query that shows the courses that are longer than the standard 3 semester hours. The query shows from tblCourse: Course Number, Course Title, and Semester Hours. Name the query gryLongClass sey uuely ope tblCourse Query thiCourse bol Course Number Course Title Professor ID tblCourse Course Number Course Title Professor D Semester Hours Semester Hours Fec Help CH Search 2. Make a copy of gryBethany, Change the criteria so that now the query shows you the courses taught by Daniel Smith. Name the query gryDaniel qryBethany . . . tblProfessor Professor Name Course Number Course Title tblCourse Prof Semester 102 Intro to Accountin DS DS Daniel Smith Daniel Smith DS 105 Intro to Entrepren DS 3. Create a query that shows the courses that are longer than the standard 3 semester hours. The query shows from tblCourse Course Number, Course Title, and Semester Hours. Name the query aryLongClass Lavery setup spany spe thCourse Query > tblCourse Course Number Course Title Professor ID Semester Hours Field Course Number Table: tblCourse Sort: Show g Criteria or tblCourse Query Course Number d (Course Title) tblCourse Semester Hours tblCourse E 7 O +3 Course Title Semester Hours - 5 - - 101 Surviving Colle 104 Intro to MIS 0 0 Access Case #1 IS 2000 Databases are critical in business as they store a large amount of data for an organization, and various tools within the database are used to later retrieve and analyze this data. In this portion of the course you will be building a comprehensive database that will assist management/ students of a college to determine appropriate information relating to courses for the coming semester. In this segment, you will be helping determine what professors will be teaching what courses. You will need the following two tables. Create the database using the name [yourname]Casel accdb. tblCourse Course Title Course Number Professor ID Semester Hours 101 Surviving College BN 4 102 Intro to Accounting DS 103 Intro to Economics ED 104 Intro to Management Information Systems BN 105 Into to Entrepreneurship DS 3 tblProfessor Professor ID Professor Name BN Bethany Niese DS Daniel Smith ED Emily Donald 1. Create the two tables. Create the two tables above in Design mode. Use the data types of number and short text where appropriate. Make appropriate choices for primary keys and foreign keys. 2. Create the relationship Create a relationship between the tables using the Primary Key of Professor ID in tblProfessor and the Foreign Key Professor ID in tblCourse. 3. Create queries 1. Create a query that shows what classes will be taught by Bethany Niese. The query shows Professor Name and Course Title Name the Query gryBethany. 3 5 Ford Help O O Search tblCourse Query tblProfessor Query tblProfessor Professor D Professor Name Field: tblProfessor Professo Professor Name Table: tblProfessor tblProfessor Course Title tblCourse Sort Show: Criteria: "BN ☐ M 5 or: tblProfessor Query tblCourse Query Professor Name. Bethany Niese Course Title Surviving College Intro to MIS Bethany Niese 2. Make a copy of gryBethany, Change the criteria so that now the query shows you the courses taught by Daniel Smith. Name the query gryDaniel gryBethany tblProfessor ps Professor Name Course Number Daniel Smith Course Title tblCourse_Profe- Semester Hours - 102 Intro to Accountin DS DS Daniel Smith 105 Intro to Entrepren DS 3. Create a query that shows the courses that are longer than the standard 3 semester hours. The query shows from tblCourse: Course Number, Course Title, and Semester Hours. Name the query gryLongClass sey uuely ope tblCourse Query thiCourse bol Course Number Course Title Professor ID tblCourse Course Number Course Title Professor D Semester Hours Semester Hours Fec Help CH Search 2. Make a copy of gryBethany, Change the criteria so that now the query shows you the courses taught by Daniel Smith. Name the query gryDaniel qryBethany . . . tblProfessor Professor Name Course Number Course Title tblCourse Prof Semester 102 Intro to Accountin DS DS Daniel Smith Daniel Smith DS 105 Intro to Entrepren DS 3. Create a query that shows the courses that are longer than the standard 3 semester hours. The query shows from tblCourse Course Number, Course Title, and Semester Hours. Name the query aryLongClass Lavery setup spany spe thCourse Query > tblCourse Course Number Course Title Professor ID Semester Hours Field Course Number Table: tblCourse Sort: Show g Criteria or tblCourse Query Course Number d (Course Title) tblCourse Semester Hours tblCourse E 7 O +3 Course Title Semester Hours - 5 - - 101 Surviving Colle 104 Intro to MIS 0 0
Expert Answer:
Answer rating: 100% (QA)
Below is the solution Create a table tblProfessor and tblC... View the full answer
Related Book For
Introduction to Probability and Statistics
ISBN: 978-1133103752
14th edition
Authors: William Mendenhall, Robert Beaver, Barbara Beaver
Posted Date:
Students also viewed these mathematics questions
-
You wish to isolate a large amount of Fab fragments in order to examine their binding to protein X by X-ray crystallography. At first, you inject a large rabbit with protein X to obtain antibody. On...
-
A manufacturer uses a large amount of a certain chemical. Since there are just two suppliers of this chemical, the manufacturer wishes to test whether the percentage of contaminants is the same for...
-
In a lightning bolt, a large amount of charge flows during a time of 1.8 10-3 s. Assume that the bolt can be treated as a long, straight line of current. At a perpendicular distance of 27 m from the...
-
The City of Amarillo is authorized to issue $8,000,000, 3 percent regular serial bonds in 2017 for the construction of a new exit off the interstate highway within city limits. The bonds mature in...
-
A 10-ream case of printer paper sells for $39.99 and has a 47% markup based on the selling price. Find the markup and cost of one case of paper.
-
Figure Q2.15 shows the position graph of a car traveling on a straight road. At which labeled instant is the speed of the car greatest? A B. C D FIGURE Q2.15
-
Use random numbers to simulate tossing a coin 100 times. Let 0 represent heads, and let 1 represent tails. How many times did you obtain each number? Are the results what you expected?
-
In each of the following cases, determine the corporations that comprise an affiliated group. All corporations are includible corporations and have one class of stock. a. B Corporation owns 100% of C...
-
This week, you will learn a relativist approach to ethics and examine how people make decisions based on groups, cultures and affiliations they belong to and how this shapes decision-making. You will...
-
There is a parcel of land next to the Playful Paws, Inc. building. Ellen, the owner of this property, approached John to discuss the idea of selling it to him. John is interested. Ellen knows that...
-
Given the following adjusted trial balance and assuming no errors were made, what is the amount of Common stock? Cash-$1,662 Accounts receivable-2,098 Inventory-3,124 Prepaid rent-86 Equipment-300...
-
The account balances for a company are listed below. All balances are as of December 31, 2021, except where noted otherwise. Account Balance Account Balance Accounts Payable $10,800 Rent Expense...
-
Companies have different cost structures, both companies currently show a profit of $ 2 1 , 0 0 0 based on sales of 1 4 , 0 0 0 units as shown in the following financial statements for the month of...
-
Prewer, Inc. received a $ 1 6 0 , 0 0 0 dividend on its investment consisting of 1 6 percent of the outstanding stock of TKS , Inc., a taxable domestic corporation. Before considering this dividend,...
-
Giovanna is 1 3 and has a YouTube channel that she uses to generate sales of her handmade craft items. She is currently earning $ 5 , 0 0 0 a year in sales. Her parents also made investments in her...
-
(a) E(B) = mc 1-8 with m = 5.64910 20 kg and c = 3 108 m/s. (b) x(t) = A sin (g/L t + y) with A = 3 mm, g = 9.81 m/s2, L = 60 cm and p = 0.4 rad. (Calculator must be in radians.)
-
Use the following information from separate companies a through d: Net Income (Loss) Interest Expense Income Taxes a. $ 187,000 $ 63,580 $ 46,750 b. c. d. 181,600 158,950 190,100 65,376 66,759 91,248...
-
Suppose that the electrical potential at the point (x, y, z) is E(x, y, z) = x + y - 2z. What is the direction of the acceleration at the point (1,3,2)?
-
Refer to Exercise 8.90. Suppose you wish to estimate (p1 - p2) correct to within .06, with probability equal to .99, and you plan to use equal sample sizes- that is, n1 = n2. How large should n1 and...
-
A company was contemplating the installation of a flextime schedule in which a worker schedules his or her work hours or compresses work weeks. The company estimates that it needs a minimum mean of 7...
-
Suppose the four engines of a commercial aircraft are arranged to operate independently and that the probability of in-flight failure of a single engine is .01. What is the probability of the...
-
Trust Management System: A university would like to develop a system for students to evaluate their peers performance in some group projects. Students ratings in various categories will affect a...
-
Building trust in potential students to join music classes by a music teacher a. Explain the above scenario. b. Draw a class diagram for it. c. Document a detailed and significant use case. d. Create...
-
Define accessibility SAP.
Study smarter with the SolutionInn App