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

  Create circuit at gate level to calculate function

Create the circuit at gate level to calculate the following function: if (a=b)y=a; else y=0;.let a,b and y be 16 bit buses. Suppose input and output capacitances are each 10 units.

  Importance of standards in networking technology

Discuss the importance of standards in networking technology and in communications in general. Evaluate how standards have helped to shape commonly used devices such as cellular phones or mobile devices.

  Arrow points downward a reveals content summary true false

The details element displays a right-pointing arrow next to a summary or caption when the document is rendered in a browser. When clicked, the arrow points downward and reveals the content in the summary element. True or False

  One or two most challenging issues in identifying

Discussion Question 2-1. What are the one or two most challenging issues in identifying and documenting IT acquisition requirements (i.e., the requirements for solving the problem that was defined)? Explain your reason(s) and how the issue(s) can be ..

  Review methodologies for design & development

Investigate the requirements for the system and produce a Requirements Specification. Review methodologies for design & development and select the most appropriate

  Compare and contrast intel 975x and amd amd580x chipsets

Compare and contrast INTEL 975X and AMD AMD580X chipsets

  University financial aide fee management application

Tracks payments paid by students for school to include any technology or lab fees they pay on top of tuition (library, computer labs, admission fees, books, etc.).

  Construct a structure chart, as well as a flowchart

Construct a structure chart, as well as a flowchart and pseudocode,for the following problem. Assume that input record contains a taxpayer's name, the value of personal property belonging to taxpayer, and a code defining the type of a personal ..

  Development of an hr system

Define the business requirements for the development of an HR system to support the objective of this request. Create a detailed system design and a project implementation plan required to complete the project.

  Why is it important to have integrity in your daily life

How would a lack of integrity on the part of your co-workers affect your dealing with them?

  Create a context diagram for the new billing system

Create a Context Diagram and a Diagram 0 for the new billing and payment system.

  Authenticator-data compression-encryption

1. An authenticator is:

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