Business Finance - Accounting Access Assignment
I need this assignment by 5:30pm today
3 years ago 20
First_Deliverable_Cover_Sheet_Access_Assignment1.docx
First_Deliverable_Tables_and_Figures_Access_Assignment4.docx
First_Deliverable_Cover_Sheet_Access_Assignment1.docx
COVER SHEET OF FIRST DELIVERABLE OF ACCESS ASSIGNMENT
Statement of Academic Honesty
The deliverable items (including answers to questions) turned in are solely the work of the student identified below and were created this semester (does not involve any work from a prior semester if repeating this course). No outside assistance has been obtained (for example – but not limited to – another current student in the course, a student who has taken this course in the past, any other student for that matter, a faculty member other than your professor in this course, a business professional of any sort, a tutor, an accountant; an auditor; a friend, a relative, etc.). The only allowable assistance that may have been received is from your professor in this course. Other than assistance from this one source, all work on this deliverable has been done by the student identified below.
|
Student Name _________________________________ |
|
|
|
Number of Base Points: 35 Number of Possible Points: 36
|
|
|
|
|
Rubric
|
|
|
|
Points Earned |
Grade Comments |
|
Five Tables: |
|
|
|
Primary keys properly assigned (5 point)
|
|
|
|
Proper formatting of fields in tables (9 point)
|
|
|
|
Assigning Relationships: |
|
|
|
Proper relationships established (4 point)
|
|
|
|
Enforce referential integrity (4 points)
|
|
|
|
Screenshots: |
|
|
|
Employee table after creating EmpLastName field (place on page 2 of this output) (2 points) |
|
|
|
Inventory table after creating ProdDesc field (place on page 3 of this output) (2 points) |
|
|
|
Questions (place all answers on page 4 of this output): |
|
|
|
Control procedure – field size (2 points) |
|
|
|
Information characteristic – caption feature (2 points) |
|
|
|
Information characteristic – required data in field (2 points) |
|
|
|
Control procedure – validation rule (2 points) |
|
|
|
Information characteristic – validation rule (2 points) |
|
|
|
Total |
|
|
First_Deliverable_Tables_and_Figures_Access_Assignment4.docx
ACCESS ASSIGNMENT
TABLES AND FIGURES FOR FIRST DELIVERABLE INSTRUCTIONS
Print and staple this document of tables and figures separately from the first deliverable instructions for ease of referring back and forth between instructions and tables and figures.
As a reminder from the first deliverable instructions, the data shown in Table 2 of this document is NOT to be entered into your database until completing the second deliverable . The data is shown here for the purpose of giving students a frame of reference of what tables will be created in the first deliverable. Entry of this data when completing the first deliverable will result in a reduction in grade. Table 1. Contents of Company Files and Database Tables
|
Information required |
Table description |
Table name |
|
Data about employees |
Employee master file |
Employee |
|
Data about inventory items |
Inventory master file |
Inventory |
|
Data about customers |
Customer master file |
Customer |
|
Data about sales transactions |
Invoice transaction file 1 |
Invoice |
|
Data about specific line items within each sales transaction |
Invoice transaction file 2 |
InvoiceLine |
Table 2. Database Tables
Employee Table
EMPCODE |
EmpFirstName |
EmpLastName |
CommRate |
|
21 |
John |
Thomas |
.04 |
|
22 |
Coby |
McCool |
.04 |
|
23 |
Chadwick |
Branson |
.06 |
Inventory Table
PRODNO |
ProdDesc |
UnitPrice |
|
c1050 |
Calculator HP 10b |
20.00 |
|
c1080 |
Calculator TI 2200 |
60.00 |
|
a1100 |
Auxiliary Hub |
40.00 |
|
a1130 |
Cat 50 Cable |
10.00 |
Customer Table
CUSTCODE |
CustOrgName |
CustCity |
|
142 |
TechLogic |
Tallahassee |
|
190 |
University High School |
Birmingham |
|
204 |
Village of Mannheim |
Mannheim |
|
230 |
Dobler, Lenart & Ulonska, LLC |
Niederkirchen |
Invoice Table
INVNO |
InvDate |
EmpCode |
CustCode |
|
100022 |
09/05/202X |
21 |
142 |
|
Remaining invoice data provided separately.
|
|||
|
|
|
|
|
InvoiceLine Table
INVNO |
PRODNO |
QtySold |
100022 |
c1050 |
20 |
Legend
UPPER CASE denotes a primary key.
denotes a foreign key (a nonprimary key in one table that is the primary key of another table)
Figure 1. Office 365 User Interface
Quick Access Toolbar
File
tab
Office Ribbon
Figure 2. Access Opening Window View
Ribbon Group
Figure 3. Selecting Location to Save and Naming Database in Access
Change the file name to LastNameFirstInitialAccessAssignment
Select to save your database
Select the location of where you would like to save your database
Page | 7
Quick Access Toolbar can be customized to include frequently used tools and menus.
FIGURE 4. Access Datasheet View
Views buttons allows you to quickly change from Datasheet to Design View.
Use these controls to navigate between records.
Office ribbons provide tools that are contextually sensitive to your current view.
The left side of the view is the Navigation Pane.
Section 2.2 naming a table.
Use View → Design View → Employee
All open objects (tables, forms, queries, reports) will appear as a tab in this right-side pane.
Section 2.3 renaming a table.
Step 2: Right click on this tab to close the table.
Section 2.3 renaming a table.
Step 3: After closing the table from the right-hand pane, right click here to rename the table.
Figure 5: Table Design View
Field Properties section of Table Design View
Figure 6. Employee Table with EMPCODE Field Structure
Figure 7. Design View of Employee Table
Figure 8. Show Table Dialog Box
Figure 9. Table Relationships
Figure 10. Edit Relationship Window
Enforce Referential Integrity
Relationship Type
Page | 11
image6.png
image7.png
image8.png
image9.png
image10.png
image11.png
image12.png
image13.png
image4.png
image5.png
First_Deliverable_Cover_Sheet_Access_Assignment1.docx
COVER SHEET OF FIRST DELIVERABLE OF ACCESS ASSIGNMENT
Statement of Academic Honesty
The deliverable items (including answers to questions) turned in are solely the work of the student identified below and were created this semester (does not involve any work from a prior semester if repeating this course). No outside assistance has been obtained (for example – but not limited to – another current student in the course, a student who has taken this course in the past, any other student for that matter, a faculty member other than your professor in this course, a business professional of any sort, a tutor, an accountant; an auditor; a friend, a relative, etc.). The only allowable assistance that may have been received is from your professor in this course. Other than assistance from this one source, all work on this deliverable has been done by the student identified below.
|
Student Name _________________________________ |
|
|
|
Number of Base Points: 35 Number of Possible Points: 36
|
|
|
|
|
Rubric
|
|
|
|
Points Earned |
Grade Comments |
|
Five Tables: |
|
|
|
Primary keys properly assigned (5 point)
|
|
|
|
Proper formatting of fields in tables (9 point)
|
|
|
|
Assigning Relationships: |
|
|
|
Proper relationships established (4 point)
|
|
|
|
Enforce referential integrity (4 points)
|
|
|
|
Screenshots: |
|
|
|
Employee table after creating EmpLastName field (place on page 2 of this output) (2 points) |
|
|
|
Inventory table after creating ProdDesc field (place on page 3 of this output) (2 points) |
|
|
|
Questions (place all answers on page 4 of this output): |
|
|
|
Control procedure – field size (2 points) |
|
|
|
Information characteristic – caption feature (2 points) |
|
|
|
Information characteristic – required data in field (2 points) |
|
|
|
Control procedure – validation rule (2 points) |
|
|
|
Information characteristic – validation rule (2 points) |
|
|
|
Total |
|
|
First_Deliverable_Tables_and_Figures_Access_Assignment4.docx
ACCESS ASSIGNMENT
TABLES AND FIGURES FOR FIRST DELIVERABLE INSTRUCTIONS
Print and staple this document of tables and figures separately from the first deliverable instructions for ease of referring back and forth between instructions and tables and figures.
As a reminder from the first deliverable instructions, the data shown in Table 2 of this document is NOT to be entered into your database until completing the second deliverable . The data is shown here for the purpose of giving students a frame of reference of what tables will be created in the first deliverable. Entry of this data when completing the first deliverable will result in a reduction in grade. Table 1. Contents of Company Files and Database Tables
|
Information required |
Table description |
Table name |
|
Data about employees |
Employee master file |
Employee |
|
Data about inventory items |
Inventory master file |
Inventory |
|
Data about customers |
Customer master file |
Customer |
|
Data about sales transactions |
Invoice transaction file 1 |
Invoice |
|
Data about specific line items within each sales transaction |
Invoice transaction file 2 |
InvoiceLine |
Table 2. Database Tables
Employee Table
EMPCODE |
EmpFirstName |
EmpLastName |
CommRate |
|
21 |
John |
Thomas |
.04 |
|
22 |
Coby |
McCool |
.04 |
|
23 |
Chadwick |
Branson |
.06 |
Inventory Table
PRODNO |
ProdDesc |
UnitPrice |
|
c1050 |
Calculator HP 10b |
20.00 |
|
c1080 |
Calculator TI 2200 |
60.00 |
|
a1100 |
Auxiliary Hub |
40.00 |
|
a1130 |
Cat 50 Cable |
10.00 |
Customer Table
CUSTCODE |
CustOrgName |
CustCity |
|
142 |
TechLogic |
Tallahassee |
|
190 |
University High School |
Birmingham |
|
204 |
Village of Mannheim |
Mannheim |
|
230 |
Dobler, Lenart & Ulonska, LLC |
Niederkirchen |
Invoice Table
INVNO |
InvDate |
EmpCode |
CustCode |
|
100022 |
09/05/202X |
21 |
142 |
|
Remaining invoice data provided separately.
|
|||
|
|
|
|
|
InvoiceLine Table
INVNO |
PRODNO |
QtySold |
100022 |
c1050 |
20 |
Legend
UPPER CASE denotes a primary key.
denotes a foreign key (a nonprimary key in one table that is the primary key of another table)
Figure 1. Office 365 User Interface
Quick Access Toolbar
File
tab
Office Ribbon
Figure 2. Access Opening Window View
Ribbon Group
Figure 3. Selecting Location to Save and Naming Database in Access
Change the file name to LastNameFirstInitialAccessAssignment
Select to save your database
Select the location of where you would like to save your database
Page | 7
Quick Access Toolbar can be customized to include frequently used tools and menus.
FIGURE 4. Access Datasheet View
Views buttons allows you to quickly change from Datasheet to Design View.
Use these controls to navigate between records.
Office ribbons provide tools that are contextually sensitive to your current view.
The left side of the view is the Navigation Pane.
Section 2.2 naming a table.
Use View → Design View → Employee
All open objects (tables, forms, queries, reports) will appear as a tab in this right-side pane.
Section 2.3 renaming a table.
Step 2: Right click on this tab to close the table.
Section 2.3 renaming a table.
Step 3: After closing the table from the right-hand pane, right click here to rename the table.
Figure 5: Table Design View
Field Properties section of Table Design View
Figure 6. Employee Table with EMPCODE Field Structure
Figure 7. Design View of Employee Table
Figure 8. Show Table Dialog Box
Figure 9. Table Relationships
Figure 10. Edit Relationship Window
Enforce Referential Integrity
Relationship Type
Page | 11