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

  Design of database systems

Write a trigger that will increment the new field numHours in the Employee table automatically whenever a record is inserted in the Works table - Create a view that shows the eids and managerids in Sales department.

  Show the records of depositor tables

Create 2 tables customer with fields customer_id, customer_name, customer_street, customer_city and depositor customer_id, account_number, balance Set relation between the two tables: Perform the following query: 1) Show the records of depositor tabl..

  What is sql and for what purpose is it used in databases

What is SQL and for what purpose is it used in databases

  Write down a 350-word summary explaining two of the most

write a 350-word summary describing two of the most popular database vendors in the marketplace. answer the following

  Give two illustrations of schedules which are not conflict

let t1 have the operations ry wy and t2 have the operations ry wy rx wx. consider the different possible concurrent

  Compare two non-sequential file structure models

Compare the two non-sequential file structure models. What advantages does the first one have over the second and what advantages does the second have over the first?

  How an organization would allow programmatic access

A few years have passed, and the restaurant has grown to become a national restaurant chain. Now, they are concerned that remote and branch offices and restaurants in all fifty states will not have ready access to the data.

  Construct an entity relationship diagram

Explain the differences between the notions of Database (DB), Database Management System (DBMS) and Database System (DBS).

  Write the application for university admissions office

Write the application for university admissions office. Prompt user for a student's High School Grade Point and an admission test score.

  Display the invoice number and the invoice date

Display the invoice number, the invoice date, the customer id, and the customer name for each order in the database

  Create a entity-relationship diagram

Create a Microsoft Visio entity-relationship diagram (ERD), based on the relations in the Entities and Attributes for Fleet Truck Maintenance file and any additional information needed to normalize the database.

  Draw e-r diagram with cardinalities of store revenue cycle

Marge's Crafts sells work by local artists at her small store in Burnsville. Customers pay for their purchases at the time sale. Commercial customers, purchasing over 10 items, may pay in installments.

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