Prepare a database using microsoft access

Assignment Help Database Management System

Reference no: EM1369268

Using Microsoft Access, create a database and save it as Acme Inc. Create the following tables: Employees and Products. The field names for the Employees table are first name, last name, street, city, state, zip code, phone number, job title (i.e. manager, secretary), date of hire, and annual salary. Use the correct data type for each field. Populate the table with at least ten fictitious employees (more than one employee can have the same job title). The field names for the Products table are product code, product name, product category, and product price. Populate the Product table with at least five different products from at least three different categories. The categories are kitchen, patio, and garage.

Reference no: EM1369268

Questions Cloud

Find horizontal and vertical components of launch velocity : Vector A has a magnitude of 7m and makes an angle of 58o with the positive x axis. Vector B also has a magnitude of 7 m and is directed along negative x axis. Enter your answers in distance then angle (in degrees).

How gdp increase if re are labour force participant : If average worker produces $70,000 of GDP, by how much will GDP increase if re are 140 million labour force participants and unemployment rate drops from 5.2 to 4.5 percent.

Staffing training and development : Compare and contrast the different organizations that you research, including their approaches. How are their processes similar/different? What elements impact each company's approach?

Perfectly competitive market adjust : Assume at present, firms in perfectly competitive market are receivings negative economic profits (losses). Describe the process by which this industry will reach long-run equilibrium.

Prepare a database using microsoft access : Using Microsoft Access, prepare a database and save it as Acme Inc. Prepare the following tables: Employees and Products. Field names for Employees table are first name,

Show the enron corporate governance system : How do you think each of the individual stake holders and components of the corporate governance system should have either prevented the problems an Enron or acted to resolve the problems before they reached crisis proportions?

How much work is done on the flight bag : An airplane flying horizontally 3600 ft above the ground at 120mi/hh, drops relief aid on the ground. Resolve the angle between the vertical and the line joining plane and target at the instant when he package is released.

What are monopolist profit maximizing output and price : What are monopolist's profit maximizing output and price. What is resulting deadweight loss relative to competitive outcome. Suppose government levies a specific tax of $5 per dose on monopolist.

Effectively delegate important to a leader - manager : Why is the ability to effectively delegate important to a leader - manager and why is the ability to effectively delegate important to the company?

User Account

All Pages