Commerce 391 Sample Access Questions


 

Above is the relationship page for the Megadeals Access database created in the second Access tutorial. Here are some sample questions based on that database.

The questions ask you how to perform a task in Access. You are given a number possible steps to choose from. Not all steps are required. Your answer is graded for choosing correct steps and for putting the steps in the correct order. The questions may not include all the steps, just the major steps involved.

Here is a sample question

How do you create a new blank database in MS Access?

  1. Open an internet brower window
  2. Select "Create a new database using Blank database"
  3. Go to Hotmail.com
  4. Give the file a name
  5. Open Access
  6. Select "open an existing file"
  7. Save the file by clicking the "create" button
The answer to this question would be 5, 2, 4, 7. For some questions the order of some of the steps doesnít matter (i.e. both 1,2,3 and 1,3,2 could be correct answers). Full marks will be awarded for either solution. Create a query that provides the total cost of the inventory at each location. (Hint: For this question the field "Price" in tblProduct is considered the price Megadeals paid for the goods) To help you along here is a print screen of what the results should look like


 
 
    1. Group by Branch ID and sum the calculated field
    2. Go to the report section of the database by clicking "report"
    3. Add tblProduct and tblInventory to the query
    4. Close and Name the query
    5. Rename the calculated field and set itís format to currency
    6. Go to the relationships window
    7. Go to the query section of the database by clicking "query"
    8. Base the calculated field on Price multipled by Qtyonhand
    9. Add the BranchID from tblInventory
    10. Group by Price and Sum QtyonHand
    11. Sum BranchID and average the calculated field
    12. Select the Create the query in design view option
    13. Add tblProduct and tblBranch
    14. Create a calculated field using the build option
    15. Select the casual style in the wizard