assignment

User Generated

rat29

Programming

Description

Hello,

This is my homework.

Note: Chapter 5 Assignment 1 you already finished it and I attached the file here

Note: Please if it possible, write a brief explanation for me just to understand how it works.

If you have any question, let me know and take your time. :)

-------------------------------------------------------------------------------

Database Management Chapter 5 Assignment 2

Using your table from Chapter 5 Assignment 1, create that database in Microsoft Access. Now use the Report Design feature of Access to create a more readable report of the data. You will need to include report headings, explanatory column headings, group breaks and any subtotals and totals as appropriate. Also include a footer with report details such as:

  • Report Name
  • Filename of report
  • Date of report
  • Page n of m

Extra credit will be given for calculated fields and other special features that you add to the report.

Submit your Access database that includes your report.

Here is a useful link to creating reports:

https://www.gcflearnfree.org/access2016/creating-reports/1/ (Links to an external site.)Links to an external site.

Unformatted Attachment Preview

BEGIN TRANSACTION; /* Create a table called NAMES */ CREATE TABLE EMPLOYEES(Id integer PRIMARY KEY, Name text, age integer, No_clients integer, Address VARCHAR(30), ZipCode CHAR(10), hired_date DATE, salary DECIMAL, bonus DECIMAL, commission DECIMAL); /* Create few records in this table */ INSERT INTO EMPLOYEES VALUES(1,'John', 30, 4,'Main st Fl', '32423','02/08/2010',3000.00,1000.00,3150.90); INSERT INTO EMPLOYEES VALUES(2,'Roger', 53, 8,'1023 NW St', '34353','02/03/2010',3500.00,300.00,4100.50); INSERT INTO EMPLOYEES VALUES(3,'Donald', 23, 4,'5323 Av. Blvd', '34353','02/03/2010',3500.00,500.00,4000.00); INSERT INTO EMPLOYEES VALUES(4,'Janeth', 44, 7,'University St.', '36343','02/30/2010',3600.00,400.00,4000.00); INSERT INTO EMPLOYEES VALUES(5,'Francis', 33, 5,'1231 NE St.', '32346','02/30/2010',3800.00,300.00,4100.00); INSERT INTO EMPLOYEES VALUES(6,'Mike', 37, 6,'5235 N St.', '36234','02/30/2010',4200.00,200.00,4400.00); INSERT INTO EMPLOYEES VALUES(7,'Cynthia', 30, 8,'University Av.', '32153','02/01/2010',5300.00,1000.00,6300.50); INSERT INTO EMPLOYEES VALUES(8,'Robert', 48, 14,'Main st', '315233322','02/03/2010',6200.00,1000.00,7300.90); COMMIT; /* Display all the records from the table */ SELECT * FROM EMPLOYEES; /* List records that contain a specific field value */ SELECT * FROM EMPLOYEES WHERE age = 30; /* List records that do not contain a specific value */ SELECT * FROM EMPLOYEES WHERE NOT No_clients = 4; /* List of records equal to or above a certain value */ SELECT * FROM EMPLOYEES WHERE salary >= 4000.00; /* List an aggregation of two of the numeric fields */ SELECT (salary+commission) AS TotalPayment FROM EMPLOYEES; /* List of records ordered and grouped by value*/ SELECT COUNT(Id) AS Counter, hired_date, AVG(salary) FROM EMPLOYEES GROUP BY hired_date ORDER BY hired_date;
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Check it.The database contains the table EMPLOYEE...


Anonymous
Just the thing I needed, saved me a lot of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags