Acess lab | Computer Science homework help

BMW Bikeworks is the manufacturer of parts for BMW motorcycles. BMW Bikeworks recently purchased a small competitor. You are the project manager responsible for integrating the systems of these two companies. In this exercise, you will explore some of the data compatibility issues of merging the sales order data.

Upon completing this lab, you will be able to do the following:

  1. Analyze the implications of data interfaces between new and existing systems.
  2. Discuss procedures for handling data compatibility issues.
  3. Consider the issues involved in porting data from old systems to new systems and the importance of timing.

Necessary Material(s):

  1. MS Excel Spreadsheet*
  2. MS Access DBMS*, MS Access tutorial: MS Access Tutorials
  3. Two Access files downloaded from Doc Sharing

Note: All materials marked with * are already installed in your lab environment.

Deliverables

  1. Excel file with imported data
  2. Word file with discussion of data handling issues
  3. Access Database with the newly merged data

Grading Rubric

Item

Points

Two files imported to Excel Spreadsheet and merged

10

One Access database with merged data imported

5

Data compatibility report containing:  
List of data issues

15

Suggestions for resolution of issues

20

Total point for assignment

50

iLAB STEPS

STEP 1: Download the Databases From Doc Sharing

Back to Top

  1. Download the order1.accdb and order2.accdb files from Doc Sharing.
  2. Open the orderRecords tables in each database, and familiarize yourself with the data.

STEP 2: Import the orderRecords Data into Excel

Back to Top

  1. Using MS Excel, import the orderRecords data from the order1.accdb database. Import all of the rows and columns from this table. Rename the sheet to “orders1”.
  2. Using MS Excel, import the orderRecords data from the order2.accdb database. Import all of the rows and columns from this table. Rename the sheet to “orders2”.
  3. Save the file as “lab5.xlsx”.

STEP 3: Analyze the Data for Compatibility Issues

Back to Top

There are several data compatibility issues that may arise when BMW Bikeworks is merging the data from these two sources. Assume that ORDER1 is the BMW Bikeworks database and the ORDER2 data needs to be properly merged with ORDER1.

  1. In MS Word, prepare a document that lists all of the data issues that you foresee concerning this project. Some of the issues are obvious; others take more analysis. List any and all of the issues you can determine.
  2. Based on the list that you created above, address each of the issues and give your suggestions for resolving them.
  3. Save the file as “lab5.docx”.

STEP 4: Merge the Data in Excel and Import Back Into Access

Back to Top

  • Manually apply the changes that you suggested in Step C, creating a new sheet in your Excel workbook (lab5.xlsx).
  • Import the merged data you have created into the order1.accdb database as a new table called orderInfo.

Submit the following files to this week’s Dropbox.

Calculate your paper price
Pages (550 words)
Approximate price: -

Why Choose Us

Quality Papers

We value our clients. For this reason, we ensure that each paper is written carefully as per the instructions provided by the client. Our editing team also checks all the papers to ensure that they have been completed as per the expectations.

Professional Academic Writers

Over the years, our Acme Homework has managed to secure the most qualified, reliable and experienced team of writers. The company has also ensured continued training and development of the team members to ensure that it keep up with the rising Academic Trends.

Affordable Prices

Our prices are fairly priced in such a way that ensures affordability. Additionally, you can get a free price quotation by clicking on the "Place Order" button.

On-Time delivery

We pay strict attention on deadlines. For this reason, we ensure that all papers are submitted earlier, even before the deadline indicated by the customer. For this reason, the client can go through the work and review everything.

100% Originality

At Essay USA, all papers are plagiarism-free as they are written from scratch. We have taken strict measures to ensure that there is no similarity on all papers and that citations are included as per the standards set.

Customer Support 24/7

Our support team is readily available to provide any guidance/help on our platform at any time of the day/night. Feel free to contact us via the Chat window or support email: support@acmehomework.com.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Essay USA has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.

Essays

Essay Writing Services

At Essay USA, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.

Admissions

Admission and Business Papers

Be assured that you’ll definitely get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.

Editing

Editing and Proofreading

Our skilled editing and writing team will help you restructure you paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.

Coursework

Technical papers

We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as much details as possible in the place order section.