The writer is very fast, professional and responded to the review request fast also. Thank you.
Book/movie review
22/08/2022
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
The writer is very fast, professional and responded to the review request fast also. Thank you.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more