Field and Query free essay sample

Traders Project Description: In this project, you will create several queries, use grouping and sorting criteria, and create expressions to make calculated fields. You will also set numeric and date criteria to produce specific results. Instructions: For the purpose of grading of the project you are required to perform the following tasks: Step| Instructions| Points Possible| 1| Start Access. Open the downloaded Access database named Exploring_a03_Grader_EOC. accdb. | 0| 2| Create a new query in Design view. Add the Customers, Orders, and Employees tables to the query design window. From the Customers table, add the CompanyName, ContactName, and ContactTitle fields; from the Orders table, add the OrderID, OrderDate, and ShippedDate fields; from the Employees table, add the LastName field. Be sure to add the tables and fields in the order listed. | 7| 3| In the first empty field cell of the design grid, create a new field in the query named DaysToShip that subtracts the OrderDate from the ShippedDate. We will write a custom essay sample on Field and Query or any similar topic specifically for you Do Not WasteYour Time HIRE WRITER Only 13.90 / page In the criteria row of the DaysToShip field, enter gt;20. | 10| 4| Run the query and then save it as Shipping Efficiency. | 5| 5| View the query in Design view. Add the Order Details table to the query window, and then add the ProductID and Quantity fields (in that order). Sort the query in ascending order by OrderID. | 5| 6| Set the caption property of the LastName field to SalesRep. Run, save, and then close the query. | 6| 7| Create a new query in Design view. Add the following tables in this order: Orders, Order Details, Products, and Customers. From the Orders table, add the fields OrderID and OrderDate (in that order) to the query design grid. | 6| 8| In Design view, add a Total row to the query. In the first empty field cell of the design grid, create a new field in the query named ExtendedAmount that multiplies Quantity by UnitPrice (in that order). Select the Sum function from the Total row in the new field. | 15| 9| In the next empty field cell of the design grid, create a new field in the query named DiscountAmount that multiplies Quantity by UnitPrice by Discount. Select the Sum function from the Total row. Format the calculated field as Currency. | 13| 10| Run the query and then save it as Order Summary. | 5| 11| View the Order Summary query in Design view. Set the criteria for the OrderDate field to return dates between 5/1/2012 and 5/31/2012. Run, save, and then close the query. | 8| 12| In the Navigation Pane, copy the Order Summary query and paste it into the database as Order Summary by Country. View the new query in Design view. | 8| 13| Replace the OrderID field with the Country field (from the Customers table). Sort the query by the ExtendedAmount field in Descending order. Run, save, and then close the query. | 12| 14| Close the database and then exit Access. Submit the database as directed. | 0| | Total Points| 100|

How to Study for a Social Science Test

How to Study for a Social Science Test When you study for a test in one of the social sciences, like history, government, anthropology, economics, and sociology, you must keep in mind that three things are important. You must understand the vocabulary of your discipline.You must understand the concepts you encounter in each segment of your study.You must understand the significance of each concept. Students are sometimes frustrated after an exam in the social sciences because they feel they prepared adequately but discovered during the exam that their efforts didnt seem to make a difference at all. The reason this happens is because students prepare for one or two of the items above, but they dont prepare for all three. Common Mistakes When Studying Social Science Vocabulary   The most common mistake students make is studying the vocabulary alone - or mixing concepts in with vocabulary. There is a big difference! To understand this, you can think of your material as a batch of cookies that you need to prepare. The vocabulary words are the ingredients, like sugar, flour, and eggs.Each individual concept is a cookie. Each looks a little different from the others, but each one stands alone as important.Altogether, the cookies make up a batch. You must create an entire batch of comprehension when you study for an exam in social science; you cant stop with a collection of ingredients! Here is why this is so important: Vocabulary words show up as short answer or fill-in-the-blank questions. Concepts often show up as multiple choice questions and essay questions. Treat your vocabulary as a set of ingredients for understanding the concepts. Use flashcards to memorize your vocabulary, but remember that to fully understand your vocabulary definitions, you must also understand how they fit into the larger concepts. Example: Imagine that you are preparing for a political science test. A few vocabulary words are a candidate, vote, and nominate. You must understand these individually before you can understand the concept of an election cycle. Studying in Stages The bottom line for preparing for a test in any social science is that you must study in stages. Practice vocabulary, but also study concepts and understand how different vocabulary words fit into each concept. Your concepts will also fit into a greater collection of knowledge (batch), like a specific historical period (Progressive Era) or a certain government type (dictatorship). The concepts you study are as individual as your vocabulary words, but it will take time and practice to recognize concepts as entities because the lines can be somewhat blurred. Why? The idea of a single vote (vocabulary word) is pretty clear cut. The idea of a dictatorship? That can be defined as many things. It can be a country with a dictator or a country with a very strong leader who demonstrates unchallenged authority, or it can even be an office that holds control over an entire government. Actually, the term is used to define an entity (like a company) that is controlled by one person or one office. See how blurred the concept can become? To summarize, any time you study for a social science test, you must go back and forth studying vocabulary, studying concepts, and studying how those concepts fit into the overall theme or time period. To study effectively for a social science exam, you must give yourself at least three days of study. You can use your time wisely and gain a full understanding of both terminology and concepts by using a method called  3 Way 3 Day study technique.