o Add the 'Balance column' to the COA table.
o Update the new column and add test data.
o Create account number query. The query should display all of the columns.
o Test query.
o Create SQL database Chart of Accounts report.
o Provide a query that totals the balance field (grand total).
o Provide a query that does a subtotal on the balance field based on the first two digits of the account.
o Test Chart of Accounts report.
o Submit queries, screen shots and Chart of Accounts report