Choose one (1) and only one of the following four 2 assignment options. Provide your response back
Question:
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.
Accounting
ISBN: 978-1337899451
27th edition
Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac