ACC 365 - Accounting Spreadsheets/Datab

1. Manage Excel spreadsheets.
   1. Review basic terms of spreadsheet application including row, column, cell, cell reference, formula, formula bar, sort, filter, fill handle, merged cells, relative reference and absolute reference.
   2. Manipulate the text and numbers in a spreadsheet application by inputting, selecting, editing, formatting, copying and rearranging data.
   3. Apply functions and formulas in a spreadsheet.
   4. Manipulate worksheets including inserting and deleting rows, resizing column widths and row heights and merging cells to produce reports in an accounting format.
   5. Enhance spreadsheets with tables, hyperlinks and charts derived from data in the workbook.
   6. Review VLOOKUPs and pivot tables.
   7. Develop templates for financial worksheets using data ranges.
   8. Create macros and demonstrate their use with financial worksheet templates.
   9. Save and print reports.
2. Combine accounting and spreadsheet knowledge to create worksheets.
   1. Develop financial statements,
   2. Perform bank reconciliations.
   3. Prepare budget estimates using “What-if” worksheets, perform cost-volume-profit analysis.
   4. Track perpetual inventory quantities, calculate inventory valuations.
   5. Determine the value of short-term investments.
   6. Calculate and analyze financial ratios, perform vertical financial statement analysis.
   7. Develop master budgets including cash flow, sales and production, develop a three-month master budget
   8. Calculate process costs using FIFO inventory valuation methods.
   9. Generate a loan payment schedule.
   10. Develop a payroll register and manipulate the information using a pivot table.
   11. Design a flexible budget, calculate and analyze material and labor variances.
   12. Develop a capital budget.
3. Access features and terminology.
   1. Demonstrate the use of panes, ribbons and the help feature.
   2. Discuss other available features.
4. Plan a simple database table.
   1. Separate fields into specific subject areas.
   2. Create and modify a database and table.
   3. Create a primary key.
   4. Add, edit, move and delete records.
   5. Navigate among records.
   6. Adjust column widths and hide columns.
   7. Sort and filter records.
   8. Relate two or more tables.
5. Create and modify a query.
   1. Use sorting options within a query.
   2. Use criteria in a query.
   3. Create multiple-table queries.
   4. Apply the AND and OR criteria.
   5. Use the wildcard character.
   6. Create a calculated field.
   7. Use Summary queries.
   8. Create a crosstab query.
6. Create new forms from scratch.
   1. Create a split form.
   2. Use Form Layout.
   3. Add bound and unbound controls.
   4. Insert an image.
   5. Add subforms.
   6. Add headers and labels.
   7. Add, edit and delete records using the form.
7. Produce reports.
   1. Design a report using report wizards.
   2. Preview and modify a report design.
   3. Apply group and sort orders.
   4. Resize and align controls.
   5. Apply conditional formatting.
8. Customize a database.
   1. Add controls to forms and reports.
   2. Connect tables by setting relationships.
   3. Use properties for tables, queries, forms and reports.
   4. Perform calculations in queries, forms and reports.
   5. Copy database objects.
   6. Copy data using the clipboard.
   7. Import data from Excel.
   8. Apply various data type features.
   9. Apply formatting techniques.
9. Modify the database structure.
   1. Use many-to-many relationships.
   2. Enforce referential integrity.
   3. Create Lookup fields.
   4. Use Input Mask properties in a table.
   5. Create attachment fields