Results 1 to 7 of 7
  1. #1
    nacho is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2010
    Posts
    11

    Test data for queries


    Okay, so I need to identify some test data for the queries i've created.
    I'm not exactly sure how to lay this out but my queries are:
    qrySmith
    Which results in showing me the name of a customer, John Smith, his address, postcode, phone number and the service we provided to him.
    qrySales
    This results in showing me where the area were the highest number of sales/services provided by us
    qryServices
    This results in showing me the highest number of services in demand by our business (eg: constructing computer, reformatting, retrieving lost information/data, fixing viruses or bugs etc)
    So how exactly do i create a layout to describe my test data for my queries
    Could someone provide an example of just one, i'll construct the others myself.
    Thanks

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    test data for queriesdo you mean to say you need some sample queries like how to do all this practically. if Yes please let me know.

  3. #3
    nacho is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2010
    Posts
    11
    no, i've already created my queries, but i have to create a layout which shows that the queries work. SO basically i need to identify a set of test data to test my queries efficiency. What would an example of this be.. Right now im roughly thinking of:
    Table Name | Field Name | Test data | Outcome__________________________
    CustomerInfo l CustomerName | ????? | Shows all infomration about john smith,
    _________________________________ the services he used etc

    What would go in the test Data section?

  4. #4
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    qrySmith
    Which results in showing me the name of a customer, John Smith, his address, postcode, phone number and the service we provided to him.

    in this query test data could be type of service. You can give the user the option to select a specific service and see if the same has been provided to a Customer.

    This lay out seems to be nice and see if your query can find information about all customers whose name starts with J or any other alphabet.

  5. #5
    nacho is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2010
    Posts
    11
    oh okay, sure. that gets rid of a lot of ambiguity! Thanks
    So here it is:
    Table Name | Field Name | Test data | Outcome__________________________
    CustomerInfo l CustomerName | ????? | Shows all infomration about john smith,
    _________________________________ the services he used etc
    Under Test data, where it currently "????" i'll put Type of Service.
    Then the outcome is "Had graphics card installed"
    Correct?

  6. #6
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    Yes. You are on the right track think like a user. Think all the different things that you want to find out from the database and you will be just Ok.

  7. #7
    nacho is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2010
    Posts
    11
    ok thanks maxima

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Keying in Test answers to Access DB from Written Test
    By CityOfKalamazoo in forum Access
    Replies: 3
    Last Post: 03-01-2010, 08:58 AM
  2. Keying in Test Answers from Hard Copy
    By CityOfKalamazoo in forum Forms
    Replies: 4
    Last Post: 12-07-2009, 12:44 PM
  3. Graph totals queries with different data
    By maggioant in forum Queries
    Replies: 0
    Last Post: 10-01-2009, 12:12 PM
  4. Replies: 0
    Last Post: 03-31-2009, 02:05 AM
  5. Replies: 0
    Last Post: 12-01-2008, 03:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums