SQL Accounting Database
Not what you're looking for?
PLEASE USE SQL 2008 ATTACHED FOR ALL SQL DATABASE CREATION
Design an SQL database that contains the fields found in the company's Chart of Accounts. Add a balance field to the database. Create a query that will display all of the fields of the database and run a report totaling the balance field using test data added to the database.
Basically, the spreadsheet (Chart of Account) needs to be on a SQL Database.
What needs to be completed:
An SQL database containing the fields in the current Chart of Accounts, plus a "balance" field.
An SQL query that will display all of the database fields.
A test of the database by means of a query by account number and a report totaling the balance field test data entered by the database design team. The query will display all fields (description, short description, and balance) using the account number as the key to the query. The report will display all fields with a break based on the first two digits of the account number and subtotal of the balance field at each break. A grand total of the balance field will be provided at the end of the report. The database design team will load sufficient entries into the balance field to prove their total routine is working - test balance entries are not necessary for all account numbers.
Purchase this Solution
Solution Summary
The solution includes an SQL database containing the fields in the current Chart of Accounts, plus a "balance" field, an SQL query that will display all of the database fields, a test of the database by means of a query by account number and a report totaling the balance field test data entered by the database design team.
Purchase this Solution
Free BrainMass Quizzes
C# variables and classes
This quiz contains questions about C# classes and variables.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Basic Networking Questions
This quiz consists of some basic networking questions.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.