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.

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.

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 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 Processing

Peachtree 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 Procedures

Peachtree 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.