Description
Project 1: Microsoft Access Copy the “shoppingmall.mdb” file using “youraccountname_shoppingmall.mdb ” as the name of the copy and use this file to complete Project 1.
1. Change the name of store “Nancy’s Fish House” to your to “Your Lastname Fish House ” (example: Smith’s Fish House).
2. Create a query that lists only those stores that have a lease that will end in 2014. Show the results from the query listing the stores in chronological order by start date of the lease, with the earliest date shown first. In the query calculate the monthly rent based on the Square Footage (SqFt) of the store multiplied by the Price Per Square Foot (PricePerSqFt). Change the name of the calculated field to Monthly Rent. The query should include only the following fields: store name, manager name, lease start date, lease end date and monthly rent.
3. Create the report in a tabular format based on the query. The report can be created using the Report wizard and then modified as needed. In the descriptive header include “Trantor City Shopping Mall”, “Leases Ending in 2014” and the date of the report. (PricePerSqFt). Include the store name, manager name, lease start date, lease end date and monthly rent fields on the report. Adjust the field widths to ensure all of the data is visible. The report should have a format similar to the following:
4. Save your database in the file named “youraccountname_shoppingmall.mdb (.accdb)” and attach the file to your submission.
Project 2: Microsoft PowerPoint Create a PowerPoint presentation based on the following criteria: – presentation will contain (at least) six slides describing your favourite electronic device – the first slide of the presentation will be a Title slide, containing the name of the electronic device being profiled in the presentation, your name and an appropriate image (clip art or picture) – the second slide will provide information on the function of the electronic device and add speaker notes in the Notes pane to this slide containing features (or description) of the device – add a minimum of four additional slides providing additional information about the electronic device – on the last slide of the presentation place a hyperlink to a web page related to the electronic device – add a footer to all of the slides except the Title page that contains the date the assignment is due and the slide number. – apply an appropriate design template to the presentation – apply a different transition effect to each slide Save your presentation in a file named “youraccountname.ppt(x)” and attach this file to your submission.
Project 3: SQL Statements
Using the database shown above, create a Microsoft Word document containing the SQL statements (as shown in the lecture materials) to do the following: a. Find the Employee Name, Employee Address for all employees who work in Department Number 124430. b. Find the Employee Number (ENumber), Employee Name, Employee Birthdate and Department Name for all employees working in a Toronto office. c. Modify the employee information for Employee number (Enumber) equal to 706421 to your name, address, birth date and gender. d. Find the Project Location, Project Name and Employee Name for all projects who have an employee working on the project that has a salary greater than $50,000. e. Find the number of projects that are controlled by a department located in Vancouver. f. Find the Department Name and Project Name for all projects that have you working on them (your name will appear in the criteria). Save your SQL statements in the Word file named “youraccountname_sql.doc(x)” and attach the file to your submission.
Project 4: Queries in Microsoft Access Create a copy of the file “university.mdb” in a file called “youraccountname_university.mdb (.accdb)”. Update the student table by replacing the student name “Ima Dunsull” with your own name.
Create in the database the following relationships enforcing referential integrity: 1. SID in the Student table related to the SID in the Takes table. 2. CID in the Course table related to the CID in the Takes table 3. CID in the Course table related to the CID in the Teaches table. 4. PID in the Prof table related to the PID in the Teaches table.
Create a query for each of the following (name each query as follows: QueryA, QueryB, etc..): a. Find the subject, course number, term and section for all of the second year B term courses (courses in the ‘B’ term) in the database. Second year courses all have a course number that begins with a “2”. b. Find the Course Identification number (CID), course subject, course number, and term for all of the courses taken by the student with the SID= 2986574. c. Find the student number (SID), first name and last name for all students who have taken a Journalism course. In addition to showing the student number, student first name and student last name, show the course number and term as part of the resulting dataset. If a student has taken more than one Journalism course that student will appear more than once in the resulting dataset. d. Find the total number of students who have taken a Journalism course. Students who have taken more than one Journalism course will be included in the answer for each Journalism courses that they have taken. e. Find the professor first name, professor last name, subject name, course number, term and mark for all of the courses that you have taken (use your last name in the query not the SID). List the professors in ascending order by the professor’s last name.
Save your database in the file named “youraccountname_university.mdb (.accdb)” and attach the file to your submission.
Project 5: Information Systems Questions about Your Company
Create a one page MS Word document and complete the following questions pertaining to the business you described in Assignment One (1).
1.) Does your company have a Customer Relationship Management (CRM) system? – if yes, then was it developed in house or purchased from a vendor (and briefly why)? – if no, then how do you manage customer service?
2.) What mechanism do you use to provide business data for your company? – when a corporate decision has to be made, how (and/or with what) do you gather information required to make that decision? (i.e. we need to advertise more – where do you get data to say if this is a good decision?)
3.) List any mechanisms you use to increase your companies Social Capital.
The format of this document should be identical to format you used in Assignment One (1). Place your name, followed by the company name at the top. Fill in the required information after. At the end of the document, include your name, Student number and Western ID (the first part of your Western email (i.e. if your email was – derntwis@uwo.ca your ID would be – derntwis) Formatting is not important as long as the document is easy to follow:
This document must be a Word file saved and submitted as a .doc (or .docx) file The name must be a combination of your Western Account Name and the name of your company. The file name must be youraccountname_companyname.doc (or .docx)
Submission Instructions:
You must upload, attach and submit, via the CS1032 OWL/Sakai course site, the following files:
• youraccountname_shoppingmall.accdb (for later versions) (.mdb – for Access 2003) • youraccountname.pptx (for later versions) (.ppt – for Access 2003) • youraccountname_sql.docx (for later versions) (.doc – for Access 2003) • youraccountname_university.accdb (for later versions) (.mdb – for Access 2003) • youraccountname_companyname.docx or youraccountname_companyname.doc
NOTE: This description of the assignment contains instructions that tell you to create files with names that have a specific format. In these file names; the “youraccountname” is your university username.