Sheet and then insert ten records

Assignment Help Basic Computer Science
Reference no: EM131502633

Task 1: By using Ms. Office Excel create two Work sheets and enter the columns below in each sheet and then insert ten records below these columns.

Sheet 1: Car Number, Car Model, Company, Color, Price, License Number

Sheet 2:License, Number, Name, Address, Age

Task 2 : Create a Database file and name it [Car Info]. Then, Import MS Excel sheets into as an MS Access table.

Task 3: Assign the primary key for each table.

Task 4: Create relationship between the tables.

Task 5: Create car query to display: car no, company name price where the price is >5000.

Task 6: Save the query under the name "price".

Task 7: Add the suitable criteria to display license no, name to people who live in Dubai.

Task 8: Save the query under the name "Dubai city"

Task 9: Create a form by using form wizard that is based on the car table to display all car details, save it under the name "car info".

Task 10: Create a report by using report wizard that is based on the owner table to display all car details, save it under the name "Owner info".

Reference no: EM131502633

Questions Cloud

Project for the whole class : Compute the average grade per test, final exam, and project for the whole class. Note: the grades should be realistic in being comparable.
Discuss effect of your enculturation or group identification : State your position on the topic you selected. Discuss the effects of your own enculturation or group identification that may have influenced your biases.
Distinguish between administrative staff and program staff : Distinguish between administrative staff, program staff, and custodial staff; and discuss the importance of each.
The differences among robbery and burglary and larceny : Compare and contrast the fundamental similarities and differences among robbery, burglary, and larceny.
Sheet and then insert ten records : By using Ms. Office Excel create two Work sheets and enter the columns below in each sheet and then insert ten records below these columns.
The us constitution does afford offenders some protection : Choose two (2) of the four (4) key sources of prisoners' rights (i.e., the U.S. Constitution, federal statutes, state constitutions, and state statutes).
An unexamined life is not worth living : According to Socrates, "an unexamined life is not worth living." What did Socrates mean by this? When ethics asks that we live mindfully?
How school districts measure adequate progress for students : Assignment: Adequate Progress- How school districts measure adequate progress for all students, including those with special education needs.
Prepare a memo on the issue of interference of contract : Prepare a memorandum on the issue of interference of contract, if any, in the case.Advanced Technology was a new start-up company.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Determine how to diagnose and reseat the ram

You investigate and consider the idea that one of the RAM sticks in her PC may have become unseated. Detail the steps you would take to determine how to diagnose and reseat the RAM.

  Plot calculated column vs time

Plot Calculated Column 2(CC2) vs. Time (in minutes please). All runs in one plot. you have about 10 runs, I need you plot all these runs in one graph.

  Percentage of the total number contributed

Silvia's Pizzeria sells four different sizes of pizzas: small, medium, large, and family. The manager of the pizzeria wants a program that displays the total number of pizzas sold, as well as the percentage of the total number contributed by each ..

  Deep understanding of the organization strategy

The (enterprises architecture) EA process can be a time and resource intensive exercise that requires a deep understanding of the organization's strategy, strong technical experience, and strong organizational skills.

  Identifying the risks associated with the current position

Be sure to add a conclusion with a rationale detailing how risks can be mitigated. Reference your research so that Sean may add or refine this report before submission to senior management.

  System exceptions and application exceptions

What is the difference between System exceptions and Application exceptions?

  Minimum requirement of random access memory

What should be minimum requirement of random access memory (RAM) for internet access?

  Benefits of using wds over traditional imaging process

1. What are the benefits of using WDS over traditional imaging process? What are the requirements for implementing WDS? 2. You are asked to implement a WSUS infrastructure. What are some considerations or requirements you will need to take into acc..

  A team of five laborers working in a garment factory

A team of five laborers working in a garment factory in Indonesia divides the task of making men's dress shirts for export to Unites States. Each laborer works 10hours  day, six days a week, gets paid on Indonesian minimum wage of 2.50 per day. In on..

  Additional web resources for telecommunication & network sec

You may search these questions or part of them on the web resource links available under "Additional Web Resources for Telecommunication & Network Security.pdf".

  Find the mean deviation of the data

What is the median of the number of women's teams playing a sport?

  Importance of application maintenance in organizations

Explain the importance of application maintenance in organizations and assess the need for robust patch and update management programs and procedures.

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