1 / 0

Your Tasks

Your Tasks. Create queries and reports that will meet the needs of the business. Reports should have a consistent house style . B. Explain any testing you have carried out and provide justification for your choice of method(s).

miyoko
Download Presentation

Your Tasks

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Your Tasks Create queries and reports that will meet the needs of the business. Reports should have a consistent house style. B. Explain any testing you have carried out and provide justification for your choice of method(s). The scenario for which queries and reports you should create can be found here: Egaict.wikispaces.com
  2. Scenario behind tasks You should now be able to produce a range of queries and reports to meet business needs of the company , which include: identifying customers living in particular counties, so that invitations can be sent to promote local events where Cards by James are being sold. The next event is in Cambridgeshire, with more planned in different counties promoting new ranges of online cards to existing customers by email. The latest range will appeal particularly to female customers identifying customers who have not yet paid, allowing reminder letters to be posted out to these customers.
  3. Scenario behind tasks identifying customers who have bought particular types of card in particular months, so that they can telephone special promotional offers to different groups of customers. For example, they had a special promotion for Thank You cards in June 2012 and needed to telephone all customers who had bought this type of card in that month. analysing sales data for each month, showing the different types of cards sold and the income from the cards sold.
  4. How to create a query Instructions
  5. How to create a query 1. Click on Create 2. Click on Query Design 3. Select the tables you want to get information from by double clicking on them 4. Close this menu before continuing
  6. Creating a query- entering criteria Once you have selected the information that you want to show up in the query results you will have to enter the criteria you want the records to match. You will sue the criteria line to do this
  7. The following slides will take your through some examples of different Queries The examples are based on a Music Database. You will have to apply them to the Cards by James task where relevant Different types of queries
  8. Simple Query- songs by a particular artists Example query : songs by Beyonce Save this query as ; songs by ‘name of artist’ A simple query is where we are searching for records that match only one criteria like the example we just did. If you did it correctly the design view of the query will look like this-
  9. And Query- popular songs of 2011 Example query : popular songs of 2011 Save this query as ; popular songs of ‘year’ An and query is where we are searching for records that match two or more criteria like the example shown below. If you do correctly the design view of the query will look similar to this
  10. Wildcard query- songs beginning with Save query as: Song name begins with ‘letter*’ ( you only have to enter the letter followed by the *. The computer will add the word like automatically) Example query : songs beginning with S A wild card query uses the * symbol to find criteria that begins, ends or contains a particular letter. *a- means ends with a A* - means begins with A *a*- means it contains an A anywhere in the word
  11. Advanced Queries On the following slides are some a examples of advanced queries that some of you may want to try in your own database. We will look at these types of queries in more detail next year when we come back to databases but feel free to have a go now.
  12. Logical Query These types of queries use the following symbols Can be used on the following types of data Number fields Currency Fields Date/Time fields
  13. Example of a logical query Pocket money is Less than £10
  14. Parameter Query A query related to particular query that can be used over and over again It comes up with a prompt box for you to enter criteria every time it is run E.g. Find all the people with a certain special talent
More Related