BCIS 1305 North Lake College

Create a Business Letter using a template:

Create a new Word document using the Business Letter (Simple Design) template.

  1. Change the Company name to BCIS 1305 PC Repair Co

Modify the date to be the current date and the address to be 3939 Valley View Lane, Dallas, TX 75244

  1. Change the salutation to Dear Customer:
  2. Type in the following task under the salutation:
    BCIS 1305 PC Repair Co is dedicated to providing our customers quality repairs at reasonable prices.
  3. Copy and paste the following text after the line above:
    Computer privacy and security have become increasingly difficult as hackers become more sophisticated and aggressive. As a result, at BCIS 1305 PC Repair, we have a new goal to help our customers better safeguard their equipment and data from outside threats. Beginning in January, 2022, we will be offering two new services:The Home Security Evaluation is a one hour session with one of our experienced technicians who will come to your home to review your network and computer security settings and make recommendations on steps you can take to ensure your home technology is safe and secure from hackers. This service is available at a discounted price of $75 for the first 3 months of the year, $100 thereafter.We will also begin offering Virtual One-on-One Sessions with our technicians via Zoom. These sessions can be customized to meet your needs – training in a particular software application, troubleshooting issues, security and privacy recommendations – your wish is our command! These sessions are available for $40/hour with a 1 hour minimum. After the first hour, you will be billed in half-hour increments at the rate of $20 per half hour.We hope you will take advantage of these new services to stay safe and protected during the new year. Visit our website at www.bcis1305pcrepair.com or call us at 214-555-1212 for more information or to schedule an appointment.
  4. Change the closing to Sincerely, Your friends at BCIS 1305 PC Repair
  5. Modify the footer to use the same address as in step 3 above. Telephone is 214-555-1212 and URL is www.bcis1305pcrepair.com

Change the color of the Company name and date from red to green. Change the color of the text in the footer to green.

  1. Change the font of the footer to MV Boli with a font size of 8.

Make Home Security Evaluation in paragraph 3 and Virtual One-on-One Sessions in paragraph 4 bold. 

Make the website URL into a hyperlink (in last paragraph and footer).

  1. Change the word Zoom in paragraphy 4 to be in italics.
  2. Reduce the line spacing above the date to 18pt, and the line spacing above the address (after the date) to be 30pt.

Modify the bottom margin to be left margin to be 1″ and the right margin to 1.5″.

ORDER THIS OR A SIMILAR PAPER AND GET 20% DICOUNT. USE CODE: GET2O

BCIS 1305 North Lake College

Objective:

Organize, manage and analyze information using database software

Requirements:

For this assignment, you will be creating a Microsoft Access database for the BCIS 1305 PC Repair Company. You will:

  • Create the database

Create a table

Add data to the table

Create tables using an Excel spreadsheet

Create a form

Create reports

Select data for decision support

  • Requirements:
  • Create a new database in MS Access called BCIS1305
  • Create a table called ChargeRates with the following fields
  • Position – Primary Key – character data – 30 characters max
  • ChargeRate – decimal in format 00.00
  • Add data to the table for each position:PositionChargeRateTech 125.00Tech 235.00Sr. Tech50.00
  • Use the attached spreadsheet to add 5 more tables to the database: Customers, Employees, Jobs, Parts, JobDetails.

Add 2 columns to the Jobs table: AmountDue (decimal: 000.00) and Paid (binary)

Create relationships between the 6 tables as follows:
Jobs to Customers using CustomerID
Jobs to Employees using EmployeeID
Jobs to JobDetails using JobNo
JobDetails to Parts using PartNo
ChargeRates to Employees using Position

Create a form to add Customers to the Customer Table. Use the form to add 2 new customer to the table (data of your choice).

  1. Create a form to add Jobs to the Jobs Table. Add 2 new jobs to the table.
  2. Create queries

Display all fields for all Customers in the Customers table

  • Display the Jobno, DateRequested, DateCompleted and HoursBilled for all Jobs in the Jobs table
  • Display the JobNo, DateRequested, DateCompleted and HoursBIlled for all Jobs for EmployeeID = 3
  1. Display the JobNo, DateRequested, DateCompleted and HoursBIlled for all Jobs with HoursBilled > 1

Display the JobNo, DateRequested, DateCompleted and HoursBIlled from the Jobs table, plus the LastName, FirstName and Position from the Employees table for all Jobs with HoursBilled > 1

Display the JobNo, DateRequested, DateCompleted and HoursBilled from the Jobs table, plus the LastName, FirstName and Position from the Employees table for all Jobs with HoursBilled > 1

Display the JobNo, DateRequested, DateCompleted and HoursBilled from the Jobs table, plus the LastName, FirstName and Position from the Employees table plus the CustomerName from the Customers table for all Jobs with HoursBilled > 1

Create reports

Create a report of all Customers in the Customers table

Create a report using query g above for all jobs in May and June of 2021 that includes the JobNo, Date Requested, DateCompleted, HoursBilled, Employee LastName, Employee FirstName and CustomerName

Create a report that lists the CustomerName, Address, City, and PostalCode fromthe Customers table, the JobNo, DateCompleted, HoursBilled and AmountDue from the Jobs table for all jobs that have not been paid.

Create a report with the JobNo, DateRequested, DateCompleted, Employee Lastname, Employee FirstName, HoursBilled and AmountDue for all jobs where the DtaeRequested is different from the DateCompleted.

ORDER THIS OR A SIMILAR PAPER AND GET 20% DICOUNT. USE CODE: GET2O