Solved by verified expert :iLab – MS Access
Do Problem 4.4 on page 110. Here are the WK 2 MS Access Lab Requirements.
Here is the Week 2 Lab starter kit database file. Download the file and save it to your computer.
If you do not have Microsoft Access on your computer, you can go to the
“iLab – MS Access” tab under Course Home and log in to Citrix.
Submit your lab to the Dropbox located on the silver tab at the top of
this page. For instructions on how to use the Dropbox, read these step-by-step instructions or watch this Tutorial Dropbox Tutorial.WEEK 3 Peachtree Lab 1 of 5: General Ledger
Summary
In this Lab you will begin using Peachtree Complete 2010
General Ledger Accounting Software. All of your work will be done using the
following:
Practice Set:
“Comprehensive Assurance & Systems Tool (CAST), An Integrated Practice
Set, 2nd Ed., by Laura R. Ingraham and J. Gregory Jenkins. This Practice Set
uses the “Winery at Chateau Americana” case project.
Peachtree Complete
2010 software available from the iLab tab under Course Home
Deliverables
Create a file named PT_Lab_1_LastName_FirstInitial.docx. It
should contain screen prints of your work as indicated in the lab steps.
i L A B
S T E P S
STEP 1: Preparation
Back to
top
Open a Word
document and save it as PT_Lab_1_LastName_FirstInitial.docx. This is where you
will paste your screen shots of your progress through this Lab.
At the top of the
Word document, add the following:
Your Name
Your
Instructor’s name
Course Number
Date
Peachtree Lab
When indicated in the lab steps, take a
screenshot of your computer screen and paste it to this file. At the end of the
Lab, you will upload this Word document containing the screen shots to this
week’s Lab dropbox.
Tutorial icon
Review the Tutorial: “General Ledger – Setup New Company”
Read pages AIS-35
to AIS-49 in the CAST Practice Set Book
Start Peachtree:
Open the iLab Tab in Course Home and then click on the “Toolwire”
link.
STEP 2: Setting up a new company
Back to
top
Starting on page
AIS-36: “SETTING UP A NEW COMPANY”, complete Requirements 1-11.
At Requirement # 4
on page AIS-44, take a screenshot and paste it to your Word document.
Label this
screenshot – “New Company”
Note: You can close the file and Peachtree will automatically
save your work.
STEP 3: Setting up a General Ledger
Back to
top
Starting on page
AIS-40: “SETTING UP THE GENERAL LEDGER”, complete steps 1 thru 5.
Note: You can close the file and Peachtree will
automatically save your work.
STEP 4: Setting Up Beginning Balances
Back to
top
Starting on page
AIS-46: “SETTING UP BEGINNING BALANCES”, complete steps 1 thru 4.
At step 3, page
AIS-46, make a screenshot and paste it to your Word document.
Label this
screenshot – “Beginning Balances”
STEP 5: Setting Up User Security
Back to
top
Starting on page
AIS-46: “SETTING UP USER SECURITY”, complete steps 1 thru 9.
STEP 6: Submitting the Deliverables
Back to
top
Close Peachtree
and your work will be automatically saved by Peachtree.
Deliverable
Save your Word
document containing your two screen shot.
Submit the
Word document to this week’s Lab dropbox.WEEK 4In this Lab you continue using Peachtree Complete 2010
General Ledger Accounting Software. All of your work will be done using the
following:
Practice Set:
“Comprehensive Assurance & Systems Tool (CAST), An Integrated Practice
Set, 2nd Ed., by Laura R. Ingraham and J. Gregory Jenkins. This Practice Set
uses the “Winery at Chateau Americana” case project.
Peachtree Complete
2010 software available from the iLab tab under Course Home
This week’s lab will focus on the Accounts Receivables and
Accounts Payables processes.
Deliverables
Create a file named PT_Lab_2_LastName_FirstInitial.docx –
contains screen prints of your work as indicated in the lab steps
i L A B
S T E P S
STEP 1: Preparation
Back to
top
Open a Word
document and save it as PT_Lab_2_LastName_FirstInitial.docx. This is where you
will paste your screen shots of your progress through this Lab.
At the top of the
Word document add the following:
Your Name
Your
Instructor’s name
Course Number
Date
Peachtree Lab
2
When indicated in
the lab steps, take a screenshot of your computer screen and paste it to this
file. At the end of the Lab, you will upload this Word document containing the
screen shots to this week’s Lab dropbox.
Tutorial icon
Review the Tutorial: “Purchase/Payment Process”
Read pages
Computerized AIS-49 to Computerized AIS-55 in the CAST Practice Set Book
Start Peachtree:
Open the iLab Tab in Course Home and then click on the “Toolwire”
link.
STEP 2: Setting up a new company
Back to
top
Starting on page
Computerized AIS-49: “SETTING UP ACCOUNTS RECEIVABLES”, complete
Requirements 1-6. (pages Computerized AIS-49 thru 52)
Get a trial
balance of A/R and do a print screen and paste it to your Word document.
Label this
screenshot – “Accounts Receivables”
Note: You can close the file and Peachtree will
automatically save your work.
STEP 3: Setting Up Accounts Payable
Back to
top
Starting on page
Computerized AIS-52: “SETTING UP ACCOUNTS PAYABLE “, complete
Requirements 1 thru 7. (pages Computerized AIS-52 thru 55)
Get a trial
balance of A/P and do a print screen and paste it to your Word document
Label this
screenshot – “Accounts Payable”
Note: You can close the file and Peachtree will
automatically save your work.
STEP 4: Submitting the Deliverables
Back to
top
Close Peachtree
and your work will be automatically saved by Peachtree.
Deliverable
Save your Word
document containing your two screen shots.
Submit the
Word document to this week’s Lab dropbox.
Peachtree Lab 3 of 5: Receivables and Payables
Summary
In this Lab you continue using Peachtree Complete 2010
General Ledger Accounting Software. All of your work will be done using the
following:
Practice Set:
“Comprehensive Assurance & Systems Tool (CAST), An Integrated Practice
Set, 2nd Ed., by Laura R. Ingraham and J. Gregory Jenkins. This Practice Set
uses the “Winery at Chateau Americana” case project.
Peachtree Complete
2010 software available from the iLab tab under Course Home
This week’s lab will focus on the Inventory and Payroll
processes.
Deliverables
Create a file named PT_Lab_3_LastName_FirstInitial.docx –
contains screen prints of your work as indicated in the lab steps
i L A B
S T E P S
STEP 1: Preparation
Back to
top
Open a Word
document and save it as PT_Lab_3_LastName_FirstInitial.docx. This is where you
will paste your screen shots of your progress through this Lab.
At the top of the
Word document, add the following:
Your Name
Your
Instructor’s name
Course Number
Date
Peachtree Lab
3
When indicated in
the lab steps, take a screenshot of your computer screen and paste it to this
file. At the end of the Lab, you will upload this Word document containing the
screen shots to this week’s Lab dropbox.
Tutorial icon
Review the Tutorials: “Sales/Collection Process” and “HR New
Hire Process”
Review pages
Computerized AIS-56 to Computerized AIS-70 in the CAST Practice Set Book
Use Transaction
Set A
Start Peachtree:
Open the iLab Tab in Course Home and then click on the “Toolwire”
link.
STEP 2: Setting Up Inventory
Back to
top
Starting on page
Computerized AIS-56: “SETTING UP INVENTORY”, complete Requirements
1-6. (pages Computerized AIS-56 thru 59)
USE TRANSACTION
SET A
At Requirement #5,
click on “Beginning Balances”, take a print screen and paste it to
your Word document.
Label this
screenshot – “Inventory – Transaction Set A”
Note: You can close the file and Peachtree will
automatically save your work.
STEP 3: Setting Up Payroll
Back to
top
Starting on page
Computerized AIS-59: “SETTING UP PAYROLL “, complete Requirements 1
thru 16. (pages Computerized AIS-59 thru 67)
Note: You can close the file and Peachtree will
automatically save your work.
STEP 4: Setting Up Payroll Formulas
Back to
top
Starting on page
Computerized AIS-67: “SETTING UP PAYROLL FORMULAS “, complete
Requirements 1 thru 6. (pages Computerized AIS-67 thru 70)
Open an employee
list and make a screenshot of this screen and save as yourname.AIS6.
Open an Employee
List, do a print screen and paste it to your Word document
Label this
screenshot – “Payroll Set-up”
Note: You can close the file and Peachtree will
automatically save your work.
STEP 5: Submitting the Deliverables
Back to
top
Close Peachtree
and your work will be automatically saved by Peachtree.
Deliverable
Save your Word
document containing your two screen shot.
Submit the
Word document to this week’s Lab dropbox.Peachtree Lab 4 of 5: Transaction ProcessingPeachtree Lab 4 of 5: Transaction Processing
Summary
In this Lab you continue using Peachtree Complete 2010
General Ledger Accounting Software. All of your work will be done using the
following:
Practice Set:
“Comprehensive Assurance & Systems Tool (CAST), An Integrated Practice
Set, 2nd Ed., by Laura R. Ingraham and J. Gregory Jenkins. This Practice Set
uses the “Winery at Chateau Americana” case project.
Peachtree Complete
2010 software available from the iLab tab under Course Home
This week’s lab will focus on Transaction Processing.
Deliverables
Create a file named PT_Lab_4_LastName_FirstInitial.docx –
contains screen prints of your work as indicated in the lab steps.
i L A B
S T E P S
STEP 1: Preparation
Back to
top
Open a Word
document and save it as PT_Lab_4_LastName_FirstInitial.docx. This is where you
will paste your screen shots of your progress through this Lab.
At the top of the
Word document, add the following:
Your Name
Your
Instructor’s name
Course Number
Date
Peachtree Lab
4
When indicated in
the lab steps, take a screenshot of your computer screen and paste it to this
file. At the end of the Lab, you will upload this Word document containing the
screen shots to this week’s Lab dropbox.
Review the
following pages in the CAST Practice Set – Computerized AIS-70 thru 77
Use Transaction
Set A (page Computerized AIS-77)
Start Peachtree:
Open the iLab Tab in Course Home and then click on the “Toolwire”
link.
STEP 2: Setting Up Inventory
Back to
top
Starting on page
Computerized AIS-70: “ENTERING TRANSACTIONS”, complete Requirements
1-10. (pages Computerized AIS-70 thru 76)
USE TRANSACTION
SET A located on Page Computerized AIS-77
Bring up the Trial
Balance Screen, take a print screen and paste it to your Word document.
Label this
screenshot – “Transaction Processing – Set A”
Note: You can close the file and Peachtree will
automatically save your work.
STEP 3: Submitting the Deliverables
Back to
top
Close Peachtree
and your work will be automatically saved by Peachtree.
Deliverable
Save your Word
document containing your two screen shots.
Submit the
Word document to this week’s Lab dropbox.Peachtree Lab 5 of 5: Month-End and Year-End ProceduresPeachtree Lab 5 of 5: Month-End and Year-End Procedures
Remember This!
Connect to the Toolwire -Peachtree iLab here.
Note!
Submit your assignment to the Dropbox located on the silver
tab at the top of this page.
(See Syllabus/”Due Dates for Assignments &
Exams” for due dates.)
i L A
B O V E R V I E W
Summary
In this Lab you continue using Peachtree Complete 2010 General
Ledger Accounting Software. All of your work will be done using the following:
Practice Set:
“Comprehensive Assurance & Systems Tool (CAST), An Integrated Practice
Set, 2nd Ed., by Laura R. Ingraham and J. Gregory Jenkins. This Practice Set
uses the “Winery at Chateau Americana” case project.
Peachtree Complete
2010 software available from the iLab tab under Course Home
This week’s lab will focus on Month-End and Year-End
Procedures.
Deliverables
Create a file named PT_Lab_5_LastName_FirstInitial.docx. It
should contain screen prints of your work as indicated in the lab steps.
i L A
B S T E P S
STEP 1: Preparation
Back to
top
Open a Word
document and save it as PT_Lab_5_LastName_FirstInitial.docx. This is where you
will paste your screen shots of your progress through this Lab.
At the top of the
Word document, add the following:
Your Name
Your
Instructor’s name
Course Number
Date
Peachtree Lab
5
When indicated in
the lab steps, take a screenshot of your computer screen and paste it to this
file. At the end of the Lab, you will upload this Word document containing the
screen shots to this week’s Lab dropbox.
Tutorial icon
Review the Tutorials: “Financial Statements” and “Adjusting
Entries in Financial Statements”
Use Transaction
Set A
Start Peachtree:
Open the iLab Tab in Course Home and then click on the “Toolwire” link.
STEP 2: Month-End Procedures
Back to
top
Starting on page
Computerized AIS-78: “MONTH-END PROCEDURES”, complete Steps 1-4.
(pages Computerized AIS-78 thru 79)
Bring up the Trial
Balance Screen, take a print screen and paste it to your Word document.
Label this
screenshot – “Month-End”
Note: You can close the file and Peachtree will
automatically save your work.
STEP 3: Year-End Procedures
Back to
top
Starting on page
Computerized AIS-80: “YEAR-END PROCEDURES”, complete Steps 1 and 2.
Go to financial
statements and bring up the balance sheet, take a print screen and paste it to
your Word document.
Label this
screenshot – “Year-End Balance Sheet”
Go back the
financial statements and bring up an income statement, take a print screen and
paste it to your Word document.
Label this
screenshot – “Year-End Income Statement”
Note: You can close the file and Peachtree will
automatically save your work.
STEP 4: Submitting the Deliverables
Back to
top
Close Peachtree
and your work will be automatically saved by Peachtree.
Deliverable
Save your Word
document containing your two screen shot.
Submit the
Word document to this week’s Lab dropbox.
