Free Microsoft Access 2003 quiz - Test Your Skills!

Adding Filters

The aim of this quiz is to check your knowledge of Adding Filters in Microsoft Access 2003.

Please ensure that you read all questions carefully and spell all answers correctly! Once you have completed the quiz, please click the 'score my answers!' button to find out how you did.

If you like this quiz, there are plenty more where it came from! You can see the full list of subjects here.

You can learn more about our classroom, online and soft skills courses at our Happy websites.

Questions

  1. Look at the picture below. Which department will be filtered if you click on the Filter by icon? Enter the department, exactly as it appears in the picture, in the box below.Screen shot for question 1
  2. Open Table Staff in the Testfilter database. Use the Filter by icon to extract all the records where the position is Development Worker.How many records does this find? Enter your answer in words into the box below, (e.g. if you find 20 records, type in twenty). Do not save this query once it is created!

  3. Which icon would you click on to remove a filter? Click on the correct icon on the picture below.

  4. Open Table Contacts in the Testfilter database. Use Filter by Form to extract all the secretaries and trainers.How many records does this filter find? Enter your answer in words into the box below, (e.g. if you find 20 records, type in twenty). Do not save this query once it is created!
  5. Open Table Staff in the Testfilter database. Use Filter by Form to extract all the people who earn 25,000 as development workers. Remember to delete any previous criteria.How many records does this filter find? Enter your answer in words into the box below, (e.g. if you find 20 records, type in twenty). Do not save this query once it is created!

  6. Which icon would you click on to save a filter? Click on the correct icon on the picture below.

Top