Business finance – accounting access assignment
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
