Accounting Information System Project
ACTG378 AP Database Assignment
This assignment will give you practice creating database tables and creating queries. Imagine you are helping set up the database tables for a new Accounts Payable (AP) system.
This individual database assignment you will be expected to: * Do additional verification queries by creating queries using the Access visual interface * Explain the SQL code generated by these additional queries * Make appropriate modifications to existing Create Table commands
The skills needed to complete this assignment are introduced in the previous walkthrough. If you try to complete the assignment without understanding what was done in the walkthrough you won’t learn as much and you will probably spend more time. Try to think through how you can complete each step before you begin. Look back to the walk through for related examples and explanations. This approach (think before you type) is much better for your learning. Jumping in without thinking will also, probably, take longer.
Watch carefully for what is requested in the assignment: sometimes a typed answer, sometimes the query (that means SQL), sometimes a relationship chart, and sometimes data. The following suggestions will help you complete the steps quickly:
Try out the Windows snipping tool that way you can remove extra clutter from your figures, dedicating more of the space on the page to content. This is good because small fonts can make documentation hard to read.
Show the SQL version of a query: * Create a query using Access’s design interface * Choose SQL view * Copy the selected text and paste it into the document
Show results from a query: * Run a query * Click the triangle as shown in the picture * That selects the data, copy it (ctrl-c) * Paste into word - It makes a table!
Query1 | Terms_Code_ID | Description | | Un-specified Terms | 210Net30 | 2% discount within 10 Days Net 30 Days | Net10 | Net 10 Days
This assignment will give you practice creating database tables and creating queries. Imagine you are helping set up the database tables for a new Accounts Payable (AP) system.
This individual database assignment you will be expected to: * Do additional verification queries by creating queries using the Access visual interface * Explain the SQL code generated by these additional queries * Make appropriate modifications to existing Create Table commands
The skills needed to complete this assignment are introduced in the previous walkthrough. If you try to complete the assignment without understanding what was done in the walkthrough you won’t learn as much and you will probably spend more time. Try to think through how you can complete each step before you begin. Look back to the walk through for related examples and explanations. This approach (think before you type) is much better for your learning. Jumping in without thinking will also, probably, take longer.
Watch carefully for what is requested in the assignment: sometimes a typed answer, sometimes the query (that means SQL), sometimes a relationship chart, and sometimes data. The following suggestions will help you complete the steps quickly:
Try out the Windows snipping tool that way you can remove extra clutter from your figures, dedicating more of the space on the page to content. This is good because small fonts can make documentation hard to read.
Show the SQL version of a query: * Create a query using Access’s design interface * Choose SQL view * Copy the selected text and paste it into the document
Show results from a query: * Run a query * Click the triangle as shown in the picture * That selects the data, copy it (ctrl-c) * Paste into word - It makes a table!
Query1 | Terms_Code_ID | Description | | Un-specified Terms | 210Net30 | 2% discount within 10 Days Net 30 Days | Net10 | Net 10 Days