代写BSYS501 Semester 1, 2024 Assessment 1: Part B代写数据结构程序

S.

No.

Tasks

Pts

(100)

Tables

1

Import the given data set including all four tables (PACKAGE, CUSTOMER, SALES REP and SALES TRANSACTION).

20 pts

2

Ensure each table has an appropriate primary key.

4 pts

3

Ensure each table has appropriate data types for all fields.

4 pts

4

Create a Combo Box for entering data for the fields related to Payment Type.

4 pts

5

Create the following relationships among all the tables.

between CUSTOMESR and SALES TRANSACTIONS

between PACKAGE and SALES TRANSACTIONS

between SALE REP and SALES TRANSACTIONS

Make sure referential integrity is maintained for all relationships.

10 pts

Forms

6

Create a split form. for the SALES REP table that includes all fields.

5 pts

7

Create three buttons for the Sales Rep Form.:

- “Add” (add a new record)

- “Save” (save a new record)

- “Delete” (delete an existing record)

Make sure all the buttons behave according to their corresponding actions.

9 pts

8

Apply formatting (at least two features) to modify this form to enhance its visual appearance.

Save the form. as ‘Sales Rep Form’ .

4 pts

Query

Create a query that count of the number of packages sold by each rep. The query result should display:

- Number of packages sold

- Sales Rep ID Number

- First Name, and Last Name of Rep

- Ensure to add a meaningful column caption, where applicable).

- Save the query as ‘Sales Transaction Query’ .

20 pts

Report

Use the Report Wizard tool to create a report from the CUSTOMER, SALES REP, PACKAGE and SALES TRANSACTIONS tables. Your

report needs to meet the following criteria:

- You only need to display the following columns: Sales Rep’s First     Name, Last Name, Transaction Date, Customer’s Country, Package Price and Package Name.

- Use customer Country field as a grouping level for the report.

- Save the report as ‘Sales Rep Report’ .

- Preview the report to make sure that it looks professional and readable.

20 pts