[solved]-Tell Want Totals O Replace Spelling Go Find Select Arial Biu Size Switch Fit Form Windo Q39072347

PLEASE WRITE SQL CODE TO ANSWER AND PLEASE PROVIDESCREENSHOTS!!

Tell me what you want to do Totals O Replace Spelling → Go To Find Select More Arial BIU A. . . Size to Switch Fit Form Windows Find Window Text Formatting – O X File Home Create External Data Database Tools Help Fields Table Cut | Ascending Y Selection = New Copy View Filter Al Descending Advanced Paste Save Refresh Format Painter 4 Remove Sort y Toggle Filter All- XDelete – Views Clipboard Sort & Filter Records Tables * CATALOG E CATALOG 3 SCALE Car Make Mextol . Scal. Price – Click to Add- Chevrolet 1914 Impala SS Hard $3199 2 Chemie 1955 Convertible 1942 13 3 Chevrolet 1970 Camaro 1 $31.99 4 Chevrolet 1970 Camaro 228 1933.21 5 Chevrolet 1987 Corvette Coupe 1 $34 11 6 Ford 1949 Fed Coupe + $3328 1940 Ford Sleel Rod 1 $31.62 9 Ford 1934 Street Rod 1 $39.99 9 ord 1967 Mustang GT 1 $31.99 10 Ford 1969 Mustang Mach 1 1 $3199 11 Porsche 998 Coupe 1 $20 25 12 Ferrari 512BB 1 $52.31 13 Porsche 993 Coupe 1 $26.83 14 Porsche 922 G12 1 $32.18 15 Dodge 1957 Pick-up 2 $2099 16 Chevrolet Sloot Rod 2 $23.11 17 Jaguar E-Type Roadster 3 $21.99 18 Mercedes CLK GTR 3 $19.28 19 Ford 1932 Street Rod 3 S12 15 20 Plymouth 1971 Barracuda 3 S13 42 21 Lamborghini Diablo SV 1 $48.28 22 Ferrari F355 Berlinetta 1 $26.31 23 Ferrari 250 GTO 2 $2137 3 SD DD * (New) S000 7 Fond 24 4. Scale Classic Cars Johnny Krol, introduced in Plug-In T7, runs a body shop that specializes in restoring classic cars. Johnny owns three classics and began collecting scale models when his wife put her foot down and said no to building more garage space for his cars. Johnny has decided that he needs a form and a few reports created to help in identifying the buying habits of his cus- tomers. Johnny has provided you with an updated database file, T8_Classic Cars_Data.mdb. Specifically, Johnny wants you to: 1. Create a form that will allow Johnny to enter new classic cars and update existing records. The form should use a Columnar format and the Sandstone style. Save the form as Catalog. 2. Create a report listing classic cars grouped by their make. The report should display all fields from the CATALOG table, sort by model name, and calculate the average price for each make. Use the formal style. Save the report as Cars By Model. Show transcribed image text Tell me what you want to do Totals O Replace Spelling → Go To Find Select More Arial BIU A. . . Size to Switch Fit Form Windows Find Window Text Formatting – O X File Home Create External Data Database Tools Help Fields Table Cut | Ascending Y Selection = New Copy View Filter Al Descending Advanced Paste Save Refresh Format Painter 4 Remove Sort y Toggle Filter All- XDelete – Views Clipboard Sort & Filter Records Tables * CATALOG E CATALOG 3 SCALE Car Make Mextol . Scal. Price – Click to Add- Chevrolet 1914 Impala SS Hard $3199 2 Chemie 1955 Convertible 1942 13 3 Chevrolet 1970 Camaro 1 $31.99 4 Chevrolet 1970 Camaro 228 1933.21 5 Chevrolet 1987 Corvette Coupe 1 $34 11 6 Ford 1949 Fed Coupe + $3328 1940 Ford Sleel Rod 1 $31.62 9 Ford 1934 Street Rod 1 $39.99 9 ord 1967 Mustang GT 1 $31.99 10 Ford 1969 Mustang Mach 1 1 $3199 11 Porsche 998 Coupe 1 $20 25 12 Ferrari 512BB 1 $52.31 13 Porsche 993 Coupe 1 $26.83 14 Porsche 922 G12 1 $32.18 15 Dodge 1957 Pick-up 2 $2099 16 Chevrolet Sloot Rod 2 $23.11 17 Jaguar E-Type Roadster 3 $21.99 18 Mercedes CLK GTR 3 $19.28 19 Ford 1932 Street Rod 3 S12 15 20 Plymouth 1971 Barracuda 3 S13 42 21 Lamborghini Diablo SV 1 $48.28 22 Ferrari F355 Berlinetta 1 $26.31 23 Ferrari 250 GTO 2 $2137 3 SD DD * (New) S000 7 Fond 24
4. Scale Classic Cars Johnny Krol, introduced in Plug-In T7, runs a body shop that specializes in restoring classic cars. Johnny owns three classics and began collecting scale models when his wife put her foot down and said no to building more garage space for his cars. Johnny has decided that he needs a form and a few reports created to help in identifying the buying habits of his cus- tomers. Johnny has provided you with an updated database file, T8_Classic Cars_Data.mdb. Specifically, Johnny wants you to: 1. Create a form that will allow Johnny to enter new classic cars and update existing records. The form should use a Columnar format and the Sandstone style. Save the form as Catalog. 2. Create a report listing classic cars grouped by their make. The report should display all fields from the CATALOG table, sort by model name, and calculate the average price for each make. Use the formal style. Save the report as Cars By Model.

Expert Answer

---

Answer to Tell me what you want to do Totals O Replace Spelling → Go To Find Select More Arial BIU A. . . Size to Switch Fit For… . . .