User Account

All Pages

Create database objects to track the construction projects

Assignment Help Database Management System
Reference no: EM13842160

In this project, you will create database objects to track the construction projects and the events related to the projects at a college. You will create a table and import data from Excel to create a second table. You will use a database template to enter data into the Events table. You will create a simple query, a form, and a report.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

1 Start Access. Open the downloaded file named go_a01_grader_h3_Construction.accdb, enable the content, and then close the Event List multiple-items form that automatically opened. Open the Navigation Pane.

2 In Datasheet view, create a new table. Beginning in the second column of the table and using the data type of Short Text, create the Building Project, Site, and Contractor fields (in that order). In the fifth column, using the Currency data type, create the Budget Amount field.

3 Change the data type of the ID field to Short Text, rename the ID field to Project ID.

4 Starting in the Project ID field, add the following three records to the new table:

P-356 Student Center, 3-story Northeast Campus RR Construction 61450000
P-823 Student Center, 2-story Southeast Campus RR Construction 41960000
P-157 Health Professions Center Northwest Campus Marshall Ellis Construction 42630000

5 Save the table as Projects, and then close the table.

6 Append the records from the downloaded Excel file go_a01_grader_h3_Projects.xlsx to the Projects table.

7 In the Navigation Pane, organize the objects by Tables and Related Views. Open the Projects table (the table has eight records). Close the Navigation Pane.

8 Switch the Projects table to Design view. For the Project ID field, enter a description of Enter the Project ID using the format P-### and then change the field size to 5. Save the table.

9 Switch to Datasheet view, apply Best Fit to all of the fields in the table, save the table, and then close the table.

10 Import the records from the downloaded Excel file go_a01_grader_h3_Contractors.xlsx into the database as a new table named Contractors. Designate the first row as column headings and the ID field as the primary key.

11 Open the Contractors table in Datasheet view (the table has four records). Apply Best Fit to all of the fields in the table, save the table, and then close the table.

12 Based on your Projects table, use the Query Wizard to create a simple query. Add the Site, Building Project, and Budget Amount fields (in that order). Keep the default name of Projects Query, click Finish to display the query results, and then close the query.

13 Based on your Projects table, use the Form tool to create a form for the table. Save the form as Project Form, display the form in Form view, and then close the form.

14 Based on your Projects table, use the Report tool to create a report. Delete the Budget Amount field from the report. Save the report as Projects Report.

15 Sort the Building Project field in ascending order. Set the width of the Building Project, Site, and Contractor fields to 2 inches. Delete the page number from the report, save the report, and then close the report.

16 Open the Navigation Pane, open the Event List form, and then close the Navigation Pane. In the Event List multiple-items form, enter the following two records (the Start Time and End Time data will reformat automatically):

Title: Groundbreaking Start Time: 6/13/18 10a End Time: 6/13/18 11a Description: Student Centergroundbreaking Location: Northeast Campus

Title: Dedication Start Time: 8/26/18 12:30p End Time: 8/26/18 2p

Description: Gymnasium building dedication Location: Southwest Campus

17 In the Event List form, click New Event, and in the Event Details single-record form, enter the following record (the Start Time and End Time data will reformat automatically):

Title: Community Arts Expo Start Time: 10/5/18 6p
End Time: 10/5/18 9p Description: Book and Art Expo at Library Location: Southeast Campus

18 Close the Event Details single-record form. Close all database objects, open the Navigation Pane, and then exit Access. Submit the database as directed.


Attachment:- Assignment.rar

Reference no: EM13842160

Questions Cloud

Analysis of the levels of leadership theory : An analysis of the levels of leadership theory that are presented in this case. Also, be sure to examine ethical issues as they relate to this case. What ethical dilemmas could be occurring? What leadership styles are evident from the actions of H..
What are the implications of benedict claim : What are the implications of Benedict's claim that morality is simply whatever a culture deems normal behavior? Is this a satisfactory equation? Can you apply it to the institution of slavery or the Nazi policy of anti-Semitism
Implement a base class person : Implement a base class person
Payoffs always represent profits in decision analysis : Payoffs always represent profits in decision analysis problems. As the name suggests, the maximum likelihood criterion says to focus on the largest payoffs. Using Bayes' decision rule will always lead to larger payoffs.
Create database objects to track the construction projects : You will use a database template to enter data into the Events table. You will create a simple query, a form, and a report.
The different theories of intelligence proposed : Provide a summary of the different theories of intelligence proposed in the textbook (Spearman, Sternberg, Gardner, and Salovey/Mayer's theories);Describe which theory you believe best describes intelligence;explain why you feel this way;Describe whe..
Locate the errors in the following code : Locate the errors in the following code
Write a menu-driven java program : Write a menu-driven JAVA program that performs the following array/vector operations:
How does a date escalate to rape : How does a date escalate to rape?  There has been a drastic increase in the use of date rape drugs over the last several years.  Give some examples of current drugs being used, how they are administered, and their effects on the victim. Each students..

Reviews

Write a Review

Database Management System Questions & Answers

  Analyse the behaviour of the most important stateful object

Analyse the behaviour of the most important stateful object of the system and document this behaviour with.

  List and summarize all new loans for residential housing

This analysis report will clearly list and summarize all new loans for residential housing in the past month

  Discuss likely data integrity constraints on attributes

Write an SQL query to find out how many Computer Science departments are not in Victoria. Return the number -  Discuss likely data integrity constraints on attributes and specify all candidate keys and the primary key for each relation based on the..

  Draw the cash-flow diagram for this situation

Construct a loan amortization table, similar to the one shown in table 6-2, showing the principal and interest seperated for the first 6 months of FunSoft's loan.

  Create a few queries that allow you to practice concepts

Create a few queries that allow you to practice concepts from the Lab. Please, don't simply post queries from this week's lab assignment! Post a screenshot of the query design and the results set in a Word document.

  Vulnerability assessment matrix

Create a table of analysis based on the attributes below. Use RAND as a resource for referring to your readings. Name the attributes in one column (behavioral sensitivity). In the second column, identify possible indicators (behavior to be aware o..

  Decide which attributes are foreign keys and justify this

Foreign keys are not indicated in these relations. Decide which attributes are foreign keys and justify this. Draw an ER diagram for these relations, using your answer to problem 1

  What difficulties did you encountered and how did you

write a 200- to 300-word short-answer response for the followingwhat difficulties did you encountered and how did you

  Implement a database of courses and students for a school

implement a database of courses and students for a school keeping track of which students are taking which courses.

  Define a data flow in bus information system

Name four attributes that you can use to define a data flow in the bus information system. Name four attributes that you can use to define a data store in the bus information system.

  Explaining uses for views

Views are integral part of virtual private databases, yet views are utilized for many other reasons. Find out many other uses for views.

  Write names-e-mail addresses for customers by foreign key

Illustrate all data in each of the four tables. Don't show foreign key columns. Write down the names and e-mail addresses for all customers who have had stove repair which cost more than $50.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd