Create your relationships and populate your tables

Assignment Help Basic Computer Science
Reference no: EM13974168

ACCESS DB

Do Database Project Assignment.

In this assignment, you're going to do the field definitions, create your relationships, and populate your tables with data. It is extremely important that your tables be set up correctly, because all future assignments will depend on your having the correct number of records. So please pay close attention to what you end up with in your tables.

I have provided all of the data in the form of an Excel file, for you to transfer into your database, so you won't have any data-entry to do. Please make sure the data are being transferred in correctly. If an Excel worksheet has 25 records and you're transferring those data into your Access table, your Access table should end up with 25 records. (I know this is a "Duh" thing to say, but I have to mention it nonetheless. Stay awake while doing this! In previous semesters there were cases where the tables looked OK initially, but when we got to queries and reports, suddenly the wrong number of records were showing up. And this went back to the contents of the source data in the tables.)

Here's the assignment:

Based on the plan you developed in Assignment #1 for Week 4, create all of the tables for the database. Be sure to use the Leszynski Naming Convention for all table names.

Define all fields. Just set the properties specified below. Again, be sure to use the Leszynski Naming Convention for all field names.

Set captions for all fields.

Create all necessary and appropriate relationships.

Populate the tables with the data that are provided in the Excel workbook named Final Project Data.xls.

The name of your database will be Final DB Week x.

Attachment:- Database Project.rar

Reference no: EM13974168

How digital media has transformed how organizations

Discuss how Digital Media has transformed how organizations advertise and market their products and services. Include a historical (before and after digital media). Support

Development of a new information system

Willowbrook School is a small private school that has retained your services as a systems analyst to assist in the development of a new information system for the school's a

How far does the car travel in a horizontal direction

Railways The steepest railway in the world is the Katoomba Scenic Railway in Australia. The passenger car is pulled up the mountain by twin steel cables. It travels along th

Assignment on direct manipulation

Early computer systems relied on command line interfaces to perform all actions. Today, the majority of systems use direct manipulation rather than a command line interface.

Introduction to computing

Research at least three different executive support systems using a web search. Review each, and then answer the following questions: 1. Which ESSs did you review? Include a

Software engineering code of ethics

1. "Software Engineering Code of Ethics and Professional Practice" Please respond to the following:•Describe one of the eight principles of the ACM Software Engineering Code

Compute the mahalanobis distance between the origin

Suppose a cluster of three-dimensional points has standard deviations of 2, 3, and 5, in the three dimensions, in that order. Compute the Mahalanobis distance between the or

Include the wrapped element style class from the lecture

Create a HTML page with five images of your choice. Various button elements will also be used as described below. Be sure to include the wrappedElement style class from the le

Reviews

Write a Review

 
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!

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