User Account

All Pages

Create a table and import data from excel

Assignment Help Basic Computer Science
Reference no: EM131058711

College Construction Projects and Events

Project Description:

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:

Instructions

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 ofEnter 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 Center groundbreaking 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:- a_ch01_gov1_h3.zip

Reference no: EM131058711

Questions Cloud

Different between the two elements : If we have two different elements, and each has an electron drop from the first excited state to the ground state, they will both have emission lines. But these lines may be very different between the two elements. Explain how this is possible.
Fraction of the speed of light : Galaxy C moves away from galaxy B in the same direction at 0.701 of the speed of light. How fast does galaxy C recede from galaxy A? Express your answer as a fraction of the speed of light.
Tension in the wire cd : To relieve the strain on the top hinge, a wire CD is connected as shown in the figure. the tension in CD is increased until the horizontal force at hinge Ais zero. what is the tension in the wire CD?
Momentum of the propellant gases : The loosely held rifle recoils at a speed of 2.05 m/s relative to the earth. Find the momentum of the propellant gases in a coordinate system attached to the earth as they leave the muzzle of the rifle.
Create a table and import data from excel : 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.
Detailed description of the normal physiological features : ACMGAS205A ASSESSMENT - Provide a detailed description of the normal physiological features, normal vital signs and normal behaviour of the species of animal that you are observing
What is force on box b : Boxes A and B are in contact on a horizontal, frictionless surface, as shown. Box A has mass 175.0 kg and B has mass 8.0 kg. A horizontal force of 190 N is exerted on box A. What is force on box B?
Bank of the river and pointing south : A river flows due south with speed of 2.0m/s. a man steers a motorboat across the river. the river is 800m wide. at what angle in the counterclockwise direction, measured from an axis aligned with the bank of the river and pointing south, should t..
Evaluate the options in relationship to the problem : Identify the reasons (technological and / or business drivers) behind the problems. Select at least one problem area and research different systems solutions (3 options) or technologies currently available or under development that may help solve ..

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Find the solution for the given initail value problem

find the solution for the given initail value problem y'' + 2y'+5y=4e^-t cos2t, y(0)=1, y'(0)=0:

  What other major discoveries in cosmology have relied

Some advances in our knowledge have been made possible through better equipment, such as Hubble's discoveries using the 100-inch Hooker telescope at Mount Wilson. What other major discoveries in cosmology have relied on improvements in existing ap..

  Explain how to reasoned access to company resources

Given home computers and access to company resources, employees will work extra hours at home and thereby increase company profits." Explain how well reasoned etc.

  What are different sources of secondary data information?

What are different sources of secondary data information?

  Prepare a detailed design document for the user interface

Your design document should not exceed ~25 pages in length, excluding references. You will need to reference all literature, applications and websites using the APA 6th edition referencing style.

  Differentiate matrix and blosum matrix

Write down the difference between matrix and a Blosum60 Blosum20 matrix? If one uses one and when other? What is meant by Clustal and summarize the operation.

  Outline the primary ways in which the traditional approach

Outline the primary ways in which the traditional approach to modeling a use case differs from an object-oriented approach. Develop a scenario in which you would use the traditional approach over the object-oriented approach, and explain your reasons..

  Safeguards against unreasonable searches and seizures

In this assignment, you need to work on the Fourth Amendment. Before starting on the assignment, make sure that you read about the Fourth Amendment and understand the nature/features of this amendment related to privacy. The Fourth Amendment safeguar..

  Establishing an effective it security policy framework

Establishing an effective Information Technology Security Policy Framework is critical in the development of a comprehensive security program. Additionally, there are many security frameworks that organizations commonly reference when developing t..

  Plan the logic for a program for the sales manger

plan the logic for a program for the sales manger of the couch potato furniture company. The manger needs a program to determine the profit on any item sold. Input includes the wholesale price and retail price for an item.

  What is not a reason to update bios

What is not a reason to update BIOS?What software is protected against viruses and malware?

  National, and international national agencies

Create list of 3-5 contacts of local, national, and international national agencies where individuals and organizations can report computer and cybercrimes

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