Choose one (1) and only one of the following four 2 assignment options. Provide your response back in this document, and SUBMIT it back using Google Classroom once completed.

Instructions:

1: Download trial version of Sage 50
2: Create a company of your choice
3: create chart of accounts – 5 max see Accounts receivable

4 Create customers - max 5, create sales invoices, receipts Accounts payable
5 Create Vendors - max 5, create orders and payments Inventory
6 Create inventory list – max 5, assign 3 of the products to a job Payroll
7: Setup employees – max 5, use a time sheet to enter employee’s earnings and deductions, taxes, entitlements etc. See sample form below.

I would like to see the 5 employees time sheet input Print 3 reports of your in choice in pdf, attached it to your file Deliverable: backup your company and send the backup file to me as an attached zip file.

Option
2. Database creation

Create a database project with the following requirements, use any professional principles and standards.
Create Tables – Minimum of 10 tables to store your data
Design forms to view, update and add data into your tables
Write Queries to retrieve data from your tables
Create reports to print data in specific layout
Create a minimum of ten rows of test data in each table.
Submit file with the scripts needed to create your tables with keys and the insert test rows, etc., into the tables and submit the Assignment Files tab as Zip.

Transcribed Image Text:

Number 1-001 1-010 1-020 1-030 1-040 1-050 1-060 2-001 2-010 2-020 2-030 2-040 3-001 3-010 3-020 4-001 4-010 5-001 5-010 5-020 5-030 5-040 5-050 5-060 5-070 5-080 6-001 Chart of Accounts Description Cash Accounts Receivable Prepaid Expenses Inventory Fixed Assets Accumulated Depreciation Other Assets Accounts Payable Accrued Liabilities Taxes Payable Payroll Payable Notes Payable Common Stock Retained Earnings Additional Paid in Capital Revenue Sales returns and allowances Cost of Goods Sold Advertising Expense Bank Fees Depreciation Expense Payroll Tax Expense Rent Expense Supplies Expense Utilities Expense Wages Expense Other Expenses Account Type Asset Asset Asset Asset Asset Asset Asset Liability Liability Liability Liability Liability Equity Equity Equity Revenue Revenue Expense Expense Expense Expense Expense Expense Expense Expense Expense Other Financial Statement Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Number 1-001 1-010 1-020 1-030 1-040 1-050 1-060 2-001 2-010 2-020 2-030 2-040 3-001 3-010 3-020 4-001 4-010 5-001 5-010 5-020 5-030 5-040 5-050 5-060 5-070 5-080 6-001 Chart of Accounts Description Cash Accounts Receivable Prepaid Expenses Inventory Fixed Assets Accumulated Depreciation Other Assets Accounts Payable Accrued Liabilities Taxes Payable Payroll Payable Notes Payable Common Stock Retained Earnings Additional Paid in Capital Revenue Sales returns and allowances Cost of Goods Sold Advertising Expense Bank Fees Depreciation Expense Payroll Tax Expense Rent Expense Supplies Expense Utilities Expense Wages Expense Other Expenses Account Type Asset Asset Asset Asset Asset Asset Asset Liability Liability Liability Liability Liability Equity Equity Equity Revenue Revenue Expense Expense Expense Expense Expense Expense Expense Expense Expense Other Financial Statement Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Number 1-001 1-010 1-020 1-030 1-040 1-050 1-060 2-001 2-010 2-020 2-030 2-040 3-001 3-010 3-020 4-001 4-010 5-001 5-010 5-020 5-030 5-040 5-050 5-060 5-070 5-080 6-001 Chart of Accounts Description Cash Accounts Receivable Prepaid Expenses Inventory Fixed Assets Accumulated Depreciation Other Assets Accounts Payable Accrued Liabilities Taxes Payable Payroll Payable Notes Payable Common Stock Retained Earnings Additional Paid in Capital Revenue Sales returns and allowances Cost of Goods Sold Advertising Expense Bank Fees Depreciation Expense Payroll Tax Expense Rent Expense Supplies Expense Utilities Expense Wages Expense Other Expenses Account Type Asset Asset Asset Asset Asset Asset Asset Liability Liability Liability Liability Liability Equity Equity Equity Revenue Revenue Expense Expense Expense Expense Expense Expense Expense Expense Expense Other Financial Statement Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Number 1-001 1-010 1-020 1-030 1-040 1-050 1-060 2-001 2-010 2-020 2-030 2-040 3-001 3-010 3-020 4-001 4-010 5-001 5-010 5-020 5-030 5-040 5-050 5-060 5-070 5-080 6-001 Chart of Accounts Description Cash Accounts Receivable Prepaid Expenses Inventory Fixed Assets Accumulated Depreciation Other Assets Accounts Payable Accrued Liabilities Taxes Payable Payroll Payable Notes Payable Common Stock Retained Earnings Additional Paid in Capital Revenue Sales returns and allowances Cost of Goods Sold Advertising Expense Bank Fees Depreciation Expense Payroll Tax Expense Rent Expense Supplies Expense Utilities Expense Wages Expense Other Expenses Account Type Asset Asset Asset Asset Asset Asset Asset Liability Liability Liability Liability Liability Equity Equity Equity Revenue Revenue Expense Expense Expense Expense Expense Expense Expense Expense Expense Other Financial Statement Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement

Answer rating: 100% (QA)

TOPIC Business Intelligence Tools Description Main Feautures SAP BusinessObjects Business Intelligence SAP BusinessObjects BI SAP BO is a business intelligence BI platform that includes a consolidated ... View the full answer