Reference no: EM13764313
This week you will demonstrate your knowledge of action queries by using all four action queries to accomplish the tasks outlined.
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.
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.
Create an action query that makes a table called WestCoast, with the following records. CA, WA, OR Create an action query to add the NV records to the newly created WestCoast table.
Create an action query that would delete the records from the Customer table, that were transferred 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 Long Integer to Single or Double (to allow decimals and not just integers. In Access 2013, this might be slightly different).
Create your final action query to "fill-in" the TAX with .085 for all the San Francisco CA customers.
Change the name of the customer database to your name before uploading and submitting for grading
Submit your work by uploading the database with the 4 saved action queries using the Assignment tool.
Be sure to use the discussion board if you need clarification on any topic.
The database you submit will contain 4 Action Queries. If you are using the same database as last week, delete all past select queries.
|
Game changing technology
: The Internet is considered a ‘game changing' technology. Discuss at least three reasons why this is true.
|
|
Please post your ideas on mary olivers love poems
: Please post your ideas on Mary Oliver's "love poems." For this forum, focus only on this section of her Red Bird poems book!
|
|
What would be the result and why
: If Smith sues the dealer for breach of warranty and the dealer defends by relying on the contract disclaimer, what would be the result and why
|
|
Light of econometric analysis
: Using the Eviews/GRETL dataset attached, carefully explain the empirical evidence MRW provide in support in of their thesis. In the light of econometric analysis, do you share the authors' conclusion above?
|
|
Create an action query that makes a table called westcoast
: Create an action query that makes a table called WestCoast, with the following records. CA, WA, OR Create an action query to add the NV records to the newly created WestCoast table.
|
|
What occasion or event may have compelled the song writer
: What occasion or event may have compelled the song writer to write this song? Is this song about the life of one person or are the song's themes of religion and power universal to humankind?
|
|
Case - integrity staffing
: Case - Integrity Staffing, Facts: Pinpoint the determinative facts of a case, i.e., those that make a difference in the outcome
|
|
It systems that have affected business
: Identify five different IT systems that have affected business in the past few years (i.e., business software applications, networks, hardware, internet-based technologies, databases). For each system, briefly note the following:
|
|
Income recognition on long-term contracts
: Cornwell Construction Company has been operating in Pennsylvania for a number of years. During 2011, the firm contracted with the Borough of Lewisburg to build a domed sports complex. Cornwell estimated that it would take three years to complete..
|