Integrating microsoft office project assignment

Assignment Help Database Management System

Reference no: EM132454168

Integrating Microsoft Office Project

Used Cell Phones for Sale:

You and a few of your classmates started a new business selling used cell phones, MP3/MP4 players, and accessories. You have been using an Access database to track your inventory. You decide to improve the data entry process by adding a few additional tables. After the new tables are added and t relationships are set, you will create several queries to analyze the data. You will also create forms, reports, and export/import data between Access, Excel, and Word. Students will submit individual fib as well as group files for grading.

Sellers = Phones sold to your company for resale

Buyers = Customers who buy the used devices

Assessment Task: a) Save the Phones.zip file on your H: drive. Unzip. Rename the Phones database as Phones_LastNameFirstName (where LastNameFirstName is your last name and first name). Open the database.

In the Database Properties settings update the following fields: Title (file name), Company (company name), Author (you), and Manager (the names of your group members).

Assessment Task: b) Import the data from the Carriers Excel file (Carriers worksheet) into a new Access table named Carriers. Let Access add a primary key field. Open the table and verify that the data imported correctly. Change the name of the ID field to CarrierlD. Save and close the Carriers table.

Assessment Task: c) Open the Inventory table in Design View and add a new field above/before the Carrier field named CarrierlD. Set the Data Type to Lookup and Lookup the CarrierlD in the Carriers table. Save and close the table.

Open the Inventory table and the Carriers table. Refer to the CarrierlD field in the Carriers table and enter the correct CarrierlD into each record in the Inventory table.

Open the Relationships window and create a One-to-Many relationship between the Carriers table and the Inventory table using the Carrie:ID field (you may need to modify the existing relationship). Enforce referential integrity. Close the Access Relationships window.

Assessment Task: d) Repeat steps b and c for the fields ManufacturerID and Colourla To do this, in the Carrier Excel file, first create an Excel worksheet named Manufacturers, which contains each unique manufacturer found in the Inventory table. Create another Exc worksheet named Colours, which contains each unique colour found in the Inventon table. Save and close the Carriers Excel file.

Create the lookup fields in the Inventory table for ColourlD and ManufacturerlD field, as you did for the CarricrlD.

Open the Inventory table and the Manufacturers table. Refer to the MansilacturerlD field in the Manufacturer table and enter the correct ManufacturerlD into each recon in the Inventory table.

Open the Inventory table and the Colours table. Refer to the ColourlD field in the Colours table and enter the correct ColourlD into each record in the Inventory table.

Assessment Task: e) Create or modify the relationships between the Inventory table and each of the other tables (Device, Manufacturer, Colour, Carrier). Create One-to-Many relationship types. Enforce referential integrity. Ensure all relationships can be seen clearly.

Assessment Task: f) Use Inventory table to create following queries. Make sure the text fields from the supporting tables appear in the queries (not include all the ID fields). Save each query as noted below.

• Display all the phones that are still for sale (SellDate is Null). Run the Quer Switch to Design View and move the SellDate to the first column. Sort the Query by SellerLastName in Ascending order. Run the Query. Save the Quer as LastName_Phones4Sale. Then close it.

• Copy LastName_Phones4Sale. Paste and rename as LastName_NotMicrosoftPhones. Remove all the existing sorting & criteria Display all the phones that are not made by Microsoft. In Design View and Son by Manufacturer in Ascending. Run the Query. Save and close the Query.

Attachment:- Integrated_Project_Files.zip

Reference no: EM132454168

Questions Cloud

What is Joe basis at the end of the year : Joe reported his share of partnership income of $1,000, and he took a cash distribution of $100. What is Joe's basis at the end of the year

Evaluation about what is the hazard : Discuss self inspection checklist and observe all safety hazard and take some picture then start to write evaluation about what is hazard and how to prevent it.

What steps should be taken to mitigate the risk : What steps should be taken to mitigate the risk (project description)? What are the anticipated costs associated with your suggested strategy?

What is Terry basis in the sports memorabilia : He received a distribution of a piece of appreciated sports memorabilia worth $5,000 with a basis of $1,500. What is Terry's basis in the sports memorabilia

Integrating microsoft office project assignment : Integrating Microsoft Office Project Assignment Help and Solution – Assessment Writing Service - create a One-to-Many relationship

Describe an obstacle you could potentially encounter : First, describe an obstacle you could potentially encounter when presenting quantitative information to a wider audience that includes participants.

Discuss about computer software security : Discuss about Computer Software Security,Analyze IA principles and practices for application security and system software security.

Create a chart or graph to help you present the crime data : Locate the most recent crime statistics for your home town or a nearby area. Create a chart or graph to help you present the crime data.

Explain what aspects of the lifestyle contribute : In regard to "lifestyles perspective": Explain what aspects of his/her lifestyle contribute to this. Discuss what ways he/she can reduce this risk.

User Account

All Pages