Blog

You can save each query (query1, query2, query3 etc. and then upload the database for grading. The online lecture should be quite enough to do this exercise but the topic can be found in pages 116 – 127 of the textbook. The book discusses the concept of query criteria very briefly and uses a lot of wizards to accomplish simple filtering tasks. I’m “kicking it up a notch” and having you perform some rather sophisticated tasks that were explained in my lecture. So as you read the chapter, experiment with the exercises as outlined, paying attention to what relates to wildcard characters, but don’t focus on the multiple tables section. We will get back to that later on in the course. Proceed as follows: Download the PDF document provided. It contains the list of queries you are to make. Two customer tables are also provided, so you wont’ have to make your own table just for this assignment. Both the PDF document and the customer tables can be downloaded from the links on the opening page in the week 5 section. The queries for the first part (1 -14) can be accomplished with the * and ?, parameter query and the proper use of AND and OR. The last 3 queries, (15-17) use the second customer table for the functions that are needed. As you go through testing the syntax of your command, in your query grid, you will know right away if the query worked. Submit your work by using the Assignment Upload File tool.You will be uploading just the database with the saved queries, not the PDF document. This week you will d

emonstrate your knowledge of action queries by using all four action queries to accomplish the tasks outlined. In addition to the my lecture, you can the topic of Action Queries in the text book on pages 276 to 283. For this exercise, you can use the same database form last week or download a fresh copy, download the Customer database file. The customer database contains 52 records of names and addresses. Before you begin the assignment, you might want to make a copy of the table first, in case you make a mess of things or want to test it out over and over again. Just select the table and Copy and Paste. Use the customer table to create the action queries below. Save each one when you are satisfied that it works as it should. There will be 4 queries in Total. Each with its own icon showing what kind of action will take place when the query is run. called WestCoast, with the following records. CA, WA, OR the NV records to the newly created WestCoast table. that would delete the records from the Customer table, that were to the WestCoast table i.e. CA, WA, OR and NV records. (we don’t need them anymore in the Customer table) Add a new field to the table called TAX. Set the data type to number and in the property fields pane, in the second half of the screen, change the format from to or (to allow decimals and not just integers. In Access 2013, this might be slightly different). the with for all the customers. Submit your work by uploading the database with the 4 saved action queries using the Assignment tool.