[solved]-Need Help Access Queries Fill Exel Chart Query1 Example Need Help Query 4 5 Query 4 Query Q39092843

I need help in Access Queries ( but fill in exel chart)

This is Query1 is a example, I need help in Query 4 5

Query 4

Query 5

Here is some lecture file

Complete the following in Query Design: a. Create an expression field called Alunni for name tags that combines the Name and GradYear (and appropriate punctuation/ spaces) fields for b. Alumni Association members only -Note: AlumniAssoc is a “Yesl No” field c. Who graduated after 2010 d. Sort on Names alphabetically AlumniAssoc Field Name GradYear Alumni:[Name]&” “a[GradYear] Alumni Alumni Alumni Table Total Ascending Sort Show Criteria 2010 Yes 4 1 3 4 Query 2 Query 5 Query 1 (Sample) Query 3 Query 4 Query Query Query 8 A P C F G 1 In the following Query design view, setup a query that answers the following question: 2 Who are our customers and what cities do they live in? 3 a. Create an expression called FullName that combines the FirstName field and the Last Name (and appropriate punctuation/spaces) field. 4 b. Sort alphabetically on the LastName field 5 8 Zip LastName City State 9 Field 10 Table Customers Customers Customers Customers 11 Total 12 Sort 13 Show 14 Criteria 15 16 17 A G 1 In the following Query design view, setup a query that answers the following question: 2 Set up fields to be ready for a label report. US Postal Addressing uses three lines. a. reate an expression callea FuluName that comDInes the Firstvame fiela ang the Last Name (and appropriate punctuation/spaces) field. 4 b. Sort alphabetically C. Create an expression called Locale that combines the City, State and Lip and appropriate on the LastName field 5 punctuation/spaces) fields. 6 7 8 LastName Address 9 Field Customers Customers 10 Table 11 Total 12 Sort 13 Show 14 Criteria 15 16 17 Expressions Expressions allow you to create new fields (in a query) that are calculated from data in other fields. The values of an expression are temporary – they are not “saved” anywhere, they only exist when the query is run. Why Use Expressions? Modify Text Combine strings together See just the first few letters of a string Calculations: Commission Tax Quantity Price To Tell me what you want to do File Home Create External Data Database Tools Help Design esert Columms f Insert Rows -Through Select Make Append Update Crosstab Delete Totals Param View Run Show Return ll Data Definition ABuilder Table able Resuts Query Type Query Setup Queryt All Access Obj… « Secrch Emplovee Orders Customers Tables O Tell me what you want to do Home Create File External Data Database Tools Help Design Customers Inset Rows KDetete Rows Delete Columns +I kUnion Pass-Through Select Make Append Update Crosstab DeletevDaa Definition “Insert Columns Employee Totals Param Orders View Run Chou Table Builder Retam All Table . Products Type Query Setup Queries commisions Summary All Access Obi. « Query rCustomer Type Purchases Customers Employee Orders Tabler Customers and Locations tls OrderD GmplayeeName Customers customers Mailing Labels Sert CommPercent CustomerD Employee rEmployee Commusion LastNamer Criteria Orders moiuatmal ProductiD Month Orders Address oir HireDater OrderPrice Predacts Forms Adive OrderDate Queries Commisions Sunmary Customer Type Purchaces eld FulName: FirstName) & LastNamel customers and Locations OrderPrice OrderDatel bels Tota Group t Group y aroup By Total row allows you to Shoc criteria group, sum, average, etc… Tot eontan fuerv Employee mproye Customers Orders 9 OrderiD EmployeeName CustomeriD CommPercent CustomeriD FirstName EmployeelD EmployeePhone LastName EmployeeEmail In this query, we are telling Access to group by Employee, and sum the Prices. We’re also Address HireDate City Active filtering only for sales between the 1st and 5th Field: FullName: [FirstName] & [LastName] brderDate Orders Where OrderPrice Table: Orders Tota roup By Sum Sort Show: Between #1/1/2018# Query FullName Criteria: SumOfOrderl or: AfsoonYousefi $58.00 $20.00 DENNISBIDDLE $30.00 Karenfluetsch MIKEduran $40.00 $25.00 SondraDean Home rea :mal Data Tell me what you want to do Database Tools File Help Design Insert Rows ” Insert Columns D Union ADelete Columns Pass-Through x Delete Rows Select Make Append Update Crosstab Delete Totals Parameters View Run Show bData Definition Builder Return: All Table Table Show Results Query Type Query Setup Query All Access Obj… « Searc.. Employee Customers Orders Tables 9 OrderiD EmployeeName CommPercent Customers CustomeriD CustomeriD Employee FirstName EmployeePhone EmployeelD LastName Orders Use the “Sort” row to specify ways to sort your data. This setting will save with your query for later use Address Products City Queries Commisions Summary Customer Type Purchases OrderDate Field: FirstName OrderPrice Customers and Locations Table: Orders Orders Customers Customers Mailing Labels Sort Show Employee Commusion Criteria: Month Orders or Use the “Criteria” row to specify which rows should stay. Try any combinaticn of:a#” and #4/10# Show transcribed image text Complete the following in Query Design: a. Create an expression field called Alunni for name tags that combines the Name and GradYear (and appropriate punctuation/ spaces) fields for b. Alumni Association members only -Note: AlumniAssoc is a “Yesl No” field c. Who graduated after 2010 d. Sort on Names alphabetically AlumniAssoc Field Name GradYear Alumni:[Name]&” “a[GradYear] Alumni Alumni Alumni Table Total Ascending Sort Show Criteria 2010 Yes 4 1 3 4 Query 2 Query 5 Query 1 (Sample) Query 3 Query 4 Query Query Query 8
A P C F G 1 In the following Query design view, setup a query that answers the following question: 2 Who are our customers and what cities do they live in? 3 a. Create an expression called FullName that combines the FirstName field and the Last Name (and appropriate punctuation/spaces) field. 4 b. Sort alphabetically on the LastName field 5 8 Zip LastName City State 9 Field 10 Table Customers Customers Customers Customers 11 Total 12 Sort 13 Show 14 Criteria 15 16 17
A G 1 In the following Query design view, setup a query that answers the following question: 2 Set up fields to be ready for a label report. US Postal Addressing uses three lines. a. reate an expression callea FuluName that comDInes the Firstvame fiela ang the Last Name (and appropriate punctuation/spaces) field. 4 b. Sort alphabetically C. Create an expression called Locale that combines the City, State and Lip and appropriate on the LastName field 5 punctuation/spaces) fields. 6 7 8 LastName Address 9 Field Customers Customers 10 Table 11 Total 12 Sort 13 Show 14 Criteria 15 16 17
Expressions Expressions allow you to create new fields (in a query) that are calculated from data in other fields. The values of an expression are temporary – they are not “saved” anywhere, they only exist when the query is run.
Why Use Expressions? Modify Text Combine strings together See just the first few letters of a string Calculations: Commission Tax Quantity Price
To Tell me what you want to do File Home Create External Data Database Tools Help Design esert Columms f Insert Rows -Through Select Make Append Update Crosstab Delete Totals Param View Run Show Return ll Data Definition ABuilder Table able Resuts Query Type Query Setup Queryt All Access Obj… « Secrch Emplovee Orders Customers Tables O Tell me what you want to do Home Create File External Data Database Tools Help Design Customers Inset Rows KDetete Rows Delete Columns +I kUnion Pass-Through Select Make Append Update Crosstab DeletevDaa Definition “Insert Columns Employee Totals Param Orders View Run Chou Table Builder Retam All Table . Products Type Query Setup Queries commisions Summary All Access Obi. « Query rCustomer Type Purchases Customers Employee Orders Tabler Customers and Locations tls OrderD GmplayeeName Customers customers Mailing Labels Sert CommPercent CustomerD Employee rEmployee Commusion LastNamer Criteria Orders moiuatmal ProductiD Month Orders Address oir HireDater OrderPrice Predacts Forms Adive OrderDate Queries Commisions Sunmary Customer Type Purchaces eld FulName: FirstName) & LastNamel customers and Locations OrderPrice OrderDatel bels Tota Group t Group y aroup By Total row allows you to Shoc criteria group, sum, average, etc…
Tot eontan fuerv Employee mproye Customers Orders 9 OrderiD EmployeeName CustomeriD CommPercent CustomeriD FirstName EmployeelD EmployeePhone LastName EmployeeEmail In this query, we are telling Access to group by Employee, and sum the Prices. We’re also Address HireDate City Active filtering only for sales between the 1st and 5th Field: FullName: [FirstName] & [LastName] brderDate Orders Where OrderPrice Table: Orders Tota roup By Sum Sort Show: Between #1/1/2018# Query FullName Criteria: SumOfOrderl or: AfsoonYousefi $58.00 $20.00 DENNISBIDDLE $30.00 Karenfluetsch MIKEduran $40.00 $25.00 SondraDean
Home rea :mal Data Tell me what you want to do Database Tools File Help Design Insert Rows ” Insert Columns D Union ADelete Columns Pass-Through x Delete Rows Select Make Append Update Crosstab Delete Totals Parameters View Run Show bData Definition Builder Return: All Table Table Show Results Query Type Query Setup Query All Access Obj… « Searc.. Employee Customers Orders Tables 9 OrderiD EmployeeName CommPercent Customers CustomeriD CustomeriD Employee FirstName EmployeePhone EmployeelD LastName Orders Use the “Sort” row to specify ways to sort your data. This setting will save with your query for later use Address Products City Queries Commisions Summary Customer Type Purchases OrderDate Field: FirstName OrderPrice Customers and Locations Table: Orders Orders Customers Customers Mailing Labels Sort Show Employee Commusion Criteria: Month Orders or Use the “Criteria” row to specify which rows should stay. Try any combinaticn of:a#” and #4/10#

Expert Answer

---

Answer to I need help in Access Queries ( but fill in exel chart) This is Query1 is a example, I need help in Query 4 5 Query 4 Qu… . . .