GO19_AC_CH03_GRADER_3A_HW - Students and Majors 1.0
GO19_AC_CH03_GRADER_3A_HW_Instructions.docx
Grader - Instructions Access 2019 Project
GO19_AC_CH03_GRADER_3A_HW - Students and Majors 1.0
Project Description:
This project will be completed by following the Activities in the Project 3A of your GO! textbook. You can use the print or eText version to locate and read the Activity instructions. For the purpose of grading the project you are required to perform the following tasks:
Steps to Perform:
|
Step |
Instructions |
Points Possible |
|
1 |
Start Access.Open the file Student_Access_3A_Majors.accdb downloaded with this project. Then, in your textbook, turn to Project 3A and complete all of the steps in Activities 3.01-3.15. |
0 |
|
2 |
Complete Activity 3.01 Opening and Saving an Existing Database, Renaming Tables, and Viewing a Table Relationship. |
0 |
|
3 |
Complete Activity 3.02 Creating a Form and Viewing Records. |
10 |
|
4 |
Complete Activity 3.03 Creating a Second Form. |
10 |
|
5 |
Complete Activity 3.04 Adding Records to a Table by Using a Form. |
15 |
|
6 |
Complete Activity 3.05 Deleting Records from a Table by Using a Form. |
5 |
|
7 |
Complete Activity 3.06 Filtering Data by Selection of One Field. |
0 |
|
8 |
Complete Activity 3.07 Using Filter by Form. |
0 |
|
9 |
Complete Activity 3.08 Using Advanced Filter/Sort. |
0 |
|
10 |
Complete Activity 3.09 Creating a Form by Using the Form Wizard. |
5 |
|
11 |
Complete Activity 3.10 Grouping Controls in Layout View. |
5 |
|
12 |
Complete Activity 3.11 Applying a Theme and Formatting a Form in Layout View. |
10 |
|
13 |
Complete Activity 3.12 Adding, Resizing, and Moving Controls in Layout View. |
10 |
|
14 |
Complete Activity 3.13 Formatting Controls in Layout View. |
15 |
|
15 |
Complete Activity 3.14 Modifying a Form in Design View. |
15 |
|
16 |
Save and close the database, and then submit for grading. |
0 |
|
Total Points |
100 |
Created On: 05/06/2020 1 GO19_AC_CH03_GRADER_3A_HW - Students and Majors 1.0
Singh_Access_3A_Students_Majors.accdb
| Major ID | Major Name |
|---|---|
| 105 | Diagnostic Medical Sonography |
| 158 | Emergency Medical Services |
| 158.100.07 | Emergency Medical Technician |
| 158.101.07 | Paramedic |
| 158.551.03 | Critical Care |
| 159 | Human Services |
| 160.330.33 | Financial Services |
| 200 | Automotive Technology |
| 213 | Business Administration |
| 215 | Nursing |
| 220.201.03 | Auto Parts Management |
| 220.233.05 | Automotive Brakes/Suspension/Inspections |
| 220.253.10 | Automotive Electrical and Electronics |
| 220.254.33 | Automotive Engine Diagnosis |
| 220.611.45 | Diesel and Industrial Machine Repair |
| 225.03.01 | American Sign Language |
| 298 | Horticulture |
| 298.05 | Greenhouse Production and Garden Center Management |
| 298.310.70 | Turfgrass Management |
| 298.67 | Landscape Design and Management |
| 300 | Accounting |
| 300.01 | Accounting Specialist |
| 300.302.01 | Accounting Technician |
| 303 | Administration of Justice |
| 320 | Paralegal Studies |
| 320.11 | Legal Assistant |
| 320.26 | General Practice Paralegal |
| 320.55 | Litigation Paralegal |
| 338.821.03 | Developmental Disabilities Specialist |
| 339 | Information Systems Technology |
| 339.123.78 | Database Specialist |
| 339.511.01 | Web Development Specialist |
| 339.781.23 | Network Engineer |
| 367 | Health Information Technology |
| 369 | Health Sciences |
| 400 | Administrative Support Technology |
| 400.01 | Medical Technology Support |
| 400.03 | Administrative Assistant |
| 415.01 | Graphic Design |
| 415.03 | Graphic Design for Advertising |
| 415.07 | Graphic Design for Multimedia |
| 421 | General Studies |
| 440.303.01 | Business Information Specialist |
| 551 | Civil Engineering |
| 551.003.55 | Civil Engineering Technician |
| 551.451.23 | Land Surveying |
| 551.887.62 | Laboratory Technology |
| 656 | Early Childhood Development |
| 656.01 | Early Childhood Instruction |
| 656.154.99 | Child Development |
| 656.332.23 | Youth Program Administration |
| 656.432.786 | Early Education Support Specialist |
| 700 | Computer Aided Drafting and Design |
| 729.03 | Architectural Drafting and Design |
| 729.33 | Mechanical Drafting and Design |
| 785 | Hospitality Management |
| 785.06 | Culinary Arts |
| 785.07 | Food Service Management |
| 785.070.87 | Catering |
| 785.45 | Lodging Management |
| 800 | Air Conditioning and Refrigeration |
| 800.03 | ACR Technician |
| 820 | Physical Therapist Assistant |
| 821 | Occupational Therapy Assistant |
| 900 | Electromechanical Controls Technology |
| 900.76 | Electrical Wiring |
| 900.78.65 | Electromechanical Controls |
| 951.03 | Electronics Technology |
| 951.06 | Electronics Engineering Technology |
| 965 | Welding |
| Student ID | First Name | Last Name | Address | City | State | Postal Code | Home Phone | College Email | Major ID |
|---|---|---|---|---|---|---|---|---|---|
| 1034823 | Jordan | Bass | 188 Rockwood Dr | Wimberley | TX | 78676 | (512) 555-2320 | [email protected] | 105 |
| 1102544 | Hugh | Goldstein | 925 Conway Dr | San Marcos | TX | 78666 | (512) 555-0300 | [email protected] | 785 |
| 1284354 | Katie | Eckert | 10305 Windstone Ct | Manor | TX | 78653 | (512) 555-9357 | [email protected] | 303 |
| 1284734 | Marianne | Berguin | 180 Snyder Trl | Liberty Hill | TX | 78642 | (512) 555-1006 | [email protected] | 320.55 |
| 1298345 | Shawn | Boulward | 5689 Wild Foxglove Rd | Spicewood | TX | 78669 | (512) 555-2321 | [email protected] | 200 |
| 1728193 | Jean | Zadro | 4345 Palacios Cir | Austin | TX | 78749 | (512) 555-2312 | [email protected] | 421 |
| 1846834 | Lan | Geng | 170 Goldenrod St | Kyle | TX | 78640 | (512) 555-1005 | [email protected] | 551 |
| 2034834 | Larry | Telfer | 162 Rattlesnake Ln | Red Rock | TX | 78662 | (512) 555-2017 | [email protected] | 303 |
| 2349535 | Ashwin | Vohra | 316 Lost Cove Dr | Spicewood | TX | 78669 | (512) 555-0302 | [email protected] | 215 |
| 2583697 | Cleta | McElaney | 132 Copperfield Dr | Austin | TX | 78753 | (512) 555-0305 | [email protected] | 421 |
| 2595304 | Joyce | Siegel | 2678 Pettytown Rd | Red Rock | TX | 78662 | (512) 555-0302 | [email protected] | 105 |
| 2738473 | Ahjamu | Ibtehal | 510 Buttonwood St | Bastrop | TX | 78602 | (512) 555-2020 | [email protected] | 551 |
| 2834850 | Ryan | Asfar | 1325 Drifting Wind Run | Dripping Springs | TX | 78620 | (512) 555-0308 | [email protected] | 200 |
| 2834953 | Chinonso | Austin | 123 Wild Buffalo Dr | Kyle | TX | 78640 | (512) 555-1012 | [email protected] | 320.55 |
| 2837490 | Caitlyn | Hardy | 359 Bentwood Dr | Leander | TX | 78646 | (512) 555-2310 | [email protected] | 700 |
| 2839403 | Nicole | Dutton | 122 Whispering Spring Ln | Georgetown | TX | 78633 | (512) 555-2315 | [email protected] | 215 |
| 2840583 | Oscar | Prince | 367 Encino St | San Marcos | TX | 78666 | (512) 555-1014 | [email protected] | 785 |
| 2845209 | Stephan | Elraheb | 351 Wild Senna Dr | Pflugerville | TX | 78660 | (512) 555-1011 | [email protected] | 415.03 |
| 2845721 | Dana | Larsen | 789 Bois Darc St | Lockhart | TX | 78644 | (512) 555-2314 | [email protected] | 551 |
| 2847194 | Ginetta | Gant | 100B W Mercer St | Dripping Springs | TX | 78620 | (512) 555-2321 | [email protected] | 400 |
| 2849201 | Lisa | Sharpe | 567 N Pecos St | Lockhart | TX | 78644 | (512) 555-2313 | [email protected] | 320.55 |
| 2849523 | Moises | Fernandez | 124 Woodland Ln | Round Rock | TX | 78665 | (512) 555-2320 | [email protected] | 700 |
| 2903485 | Jalpit | Matson | 3204 Bird Call Pass | Austin | TX | 78754 | (512) 555-2028 | [email protected] | 105 |
| 2934853 | Khrystyna | Tilson | 11520 Oaklynn Ct | Manor | TX | 78653 | (512) 555-2328 | [email protected] | 225.03.01 |
| 2938593 | Curtis | Dawson | 10344 Yellowstone Dr | Austin | TX | 78747 | (512) 555-2015 | [email protected] | 900 |
| 3128456 | WenLi | Wall | 14380 Ceylon Tea Cir | Pflugerville | TX | 78660 | (512) 555-2329 | [email protected] | 158 |
| 3458632 | Stephanie | Caputo | 1731 Primrose Tr | Round Rock | TX | 78665 | (512) 555-2330 | [email protected] | 900 |
| 3569325 | Carlis | Thomas | 28A 4th Ave | Smithville | TX | 78657 | (512) 555-0301 | [email protected] | 421 |
| 3572184 | Carla | Reid | 715 Pampas Ricas Dr | Leander | TX | 78641 | (512) 555-2026 | [email protected] | 160.330.33 |
| 3586943 | Joseph | Stavish | 660 Bayou Bend Dr | Buda | TX | 78610 | (512) 555-9360 | [email protected] | 158.101.07 |
| 3593653 | Anna | Hernandez | 2132 Mesquite Ln | Georgetown | TX | 78626 | (512) 555-0301 | [email protected] | 367 |
| 3768532 | Rebekah | Alexander | 218 Chapparal Trl | Dale | TX | 78616 | (512) 555-1017 | [email protected] | 339.123.78 |
| 3802483 | Maria | Alvarez | 3590 Longhorn Trl | Round Rock | TX | 78681 | (512) 555-2026 | [email protected] | 415.03 |
| 3802843 | Anthony | Scott | 65 Oakwood Dr | Dale | TX | 78616 | (512) 555-2326 | [email protected] | 369 |
| 3819375 | Jennifer | Locanda | 10543 Blake Manor Rd | Manor | TX | 78653 | (512) 555-2311 | [email protected] | 656 |
| 3824752 | Jaehee | Wang | 2508 Falcon Dr | Round Rock | TX | 78681 | (512) 555-1003 | [email protected] | 320.11 |
| 3829356 | Marcel | Enescu | 1900 White Oak Loop | Round Rock | TX | 78681 | (512) 555-1007 | [email protected] | 200 |
| 3829465 | Tony | Downey | 113 Zarogoza St | Elgin | TX | 78621 | (512) 555-1013 | [email protected] | 700 |
| 3829476 | Xifeng | Lau | 127 Bateman Rd | Red Rock | TX | 78662 | (512) 555-2317 | [email protected] | 160.330.33 |
| 3842958 | McCall | Cheney | 1053 Tumbleweed Dr | Dale | TX | 78616 | (512) 555-1023 | [email protected] | 225.03.01 |
| 3845724 | Mihir | Subramanian | 670 Mogonye Ln | Elgin | TX | 78621 | (512) 555-2029 | [email protected] | 320.11 |
| 3847563 | Andrew | Lee | 14010 Big Thicket Dr | Austin | TX | 78747 | (512) 555-1002 | [email protected] | 785.070.87 |
| 3847589 | Prince | Flitcroft | 7821 Winsted Ln | Austin | TX | 78703 | (512) 555-1021 | [email protected] | 900 |
| 3849234 | Donald | Hanby | 334 Blue Heron Run | Wimberley | TX | 78676 | (512) 555-2316 | [email protected] | 158 |
| 3852349 | Kirsten | Riccardi | 632 Ranchero Rd | Leander | TX | 78645 | (512) 555-9359 | [email protected] | 300 |
| 3852938 | Atonye | Morris | 1172 Buttonwood St | Bastrop | TX | 78602 | (512) 555-1018 | [email protected] | 160.330.33 |
| 3856930 | Cong | Nguyen | 444 E Alamo St | Elgin | TX | 78621 | (512) 555-1004 | [email protected] | 339 |
| 3856958 | Danila | Bennett | 808 Springbrook Ln | Leander | TX | 78641 | (512) 555-9364 | [email protected] | 159 |
| 3857493 | Sonia | Olson | 193 Middle Creek Dr | Buda | TX | 78610 | (512) 555-2024 | [email protected] | 200 |
| 3857684 | Michael | Stanton | 6732 Langhorn St | Austin | TX | 78741 | (512) 555-2327 | [email protected] | 367 |
| 3859305 | Mildred | Santangelo | 687 Horseback Hollow | Austin | TX | 78732 | (512) 555-0307 | [email protected] | 339.511.01 |
| 3859323 | Micah | Rosario | 376 Grange St | Liberty Hill | TX | 78642 | (512) 555-1015 | [email protected] | 225.03.01 |
| 3859375 | Nancy | Morrissey | 903 Alpine Rd | Austin | TX | 78704 | (512) 555-2061 | [email protected] | 105 |
| 3905345 | Oscar | Alvarado | 214B Bluff St | Buda | TX | 78610 | (512) 555-1022 | [email protected] | 421 |
| 3948506 | Kerry | Fleischer | 2984 Piping Rock Trl | Austin | TX | 78748 | (512) 555-0309 | [email protected] | 339 |
| 3957203 | Howard | Fishman | 1842 Sorghum Hill Dr | Austin | TX | 78754 | (512) 555-2062 | [email protected] | 785.070.87 |
| 4352863 | Christine | Bradley | 2708 Kickapoo Cavern Dr | Pflugerville | TX | 78660 | (512) 555-2013 | [email protected] | 215 |
| 4719238 | Avelina | DiAntonio | 1008 Sunset Canyon Dr | Dripping Springs | TX | 78620 | (512) 555-2319 | [email protected] | 339 |
| 4739502 | Eliza | Alvarez | 3590 Longhorn Trl | Round Rock | TX | 78681 | (512) 555-2025 | [email protected] | 298 |
| 4769304 | Jana | Furfy | 2107 Edenwood Dr | Austin | TX | 78745 | (512) 555-2064 | [email protected] | 821 |
| 4852384 | James | Parkhill | 105 E Myrtle St | Liberty Hill | TX | 78642 | (512) 555-2323 | [email protected] | 105 |
| 5720358 | Margot | Schneider | 628C Farm St | Bastrop | TX | 78602 | (512) 555-2101 | [email protected] | 421 |
| 5730483 | Clement | Forrester | 1506 Wilshire Blvd | Austin | TX | 78722 | (512) 555-2018 | [email protected] | 339 |
| 5738495 | Robert | Chun | 786 W Live Oak St | Lockhart | TX | 78644 | (512) 555-2331 | [email protected] | 369 |
| 5739437 | Eugene | Sotova | 130 Garwood St | Smithville | TX | 78657 | (512) 555-2030 | [email protected] | 339 |
| 5748392 | Renato | Cildaro | 334 Sand Hills Rd | Red Rock | TX | 78662 | (512) 555-2318 | [email protected] | 298.05 |
| 5820384 | Edward | Rose | 555 S Blanco St | Lockhart | TX | 78644 | (512) 555-2019 | [email protected] | 339.511.01 |
| 5834924 | Anastasia | Kakaulian | 4822 Turtle Mound Bnd | Austin | TX | 78748 | (512) 555-2031 | [email protected] | 821 |
| 5835035 | Laurence | Poon | 263 Caddis Cv | Kyle | TX | 78640 | (512) 555-0304 | [email protected] | 785.45 |
| 5849320 | Reza | Soltan | 5498 Wild Foxglove Rd | Spicewood | TX | 78669 | (512) 555-9362 | [email protected] | 339.511.01 |
| 5860300 | Daria | Campbell | 162 Rockwood Dr | Wimberley | TX | 78674 | (512) 555-1016 | [email protected] | 300.01 |
| 5867384 | Hashem | Avis | 532 Virginia St | San Marcos | TX | 78666 | (512) 555-9363 | [email protected] | 785.45 |
| 6738419 | Kevin | Leopoldo | 476 Beaukiss Ln | Elgin | TX | 78621 | (512) 555-1019 | [email protected] | 656 |
| 6739234 | Janie | Martinez | 840 Abbey Glen Castle Dr | Pflugerville | TX | 78660 | (512) 555-2027 | [email protected] | 785.07 |
| 6739256 | Katherine | Brown | 707 Walnut St | Bastrop | TX | 78602 | (512) 555-2012 | [email protected] | 339 |
| 6739319 | Zack | Rowe | 8728 Texas Bluebell Dr | Spicewood | TX | 78669 | (512) 555-1020 | [email protected] | 298.05 |
| 6753841 | Jill | Hutzell | 6462 Bisview Dr | Austin | TX | 78730 | (512) 555-9361 | [email protected] | 785.070.87 |
| 7348502 | Yianna | Mathis | 1187 Barilla Mountain Trl | Round Rock | TX | 78665 | (512) 555-0303 | [email protected] | 785.07 |
| 7384952 | Christopher | Darko | 240 Washington St | Smithville | TX | 78657 | (512) 555-1008 | [email protected] | 300 |
| 7481938 | Jamal | Hardy | 664 Carson Ave | Liberty Hill | TX | 78642 | (512) 555-2318 | [email protected] | 158 |
| 7583249 | Betty | Poon | 263 Caddis Cv | Kyle | TX | 78640 | (512) 555-1001 | [email protected] | 421 |
| 8247593 | Patrice | Martinez | 3632 Castle Path | Round Rock | TX | 78681 | (512) 555-2022 | [email protected] | 821 |
| 8273409 | Naomi | Henigson | 22568 Briarcliff Dr | Spicewood | TX | 78669 | (512) 555-2014 | [email protected] | 440.303.01 |
| 8273438 | Edgardo | Pabelonia | 894 Hidden Hills Dr | Dripping Springs | TX | 78620 | (512) 555-2322 | [email protected] | 298 |
| 8273485 | Pei | Tram | 3567 Vanderbilt Cir | Pflugerville | TX | 78660 | (512) 555-2027 | [email protected] | 440.303.01 |
| 8347568 | Yolanda | Tram | 3152 Homewood Cir | Round Rock | TX | 78665 | (512) 555-2025 | [email protected] | 298.67 |
| 8374853 | Hendrick | Themis | 2590 Mesquite Ln | Georgetown | TX | 78226 | (512) 555-1010 | [email protected] | 400 |
| 8394284 | Nora | Ramos | 234 Melody Way | Wimberley | TX | 78676 | (512) 555-2325 | [email protected] | 213 |
| 8473849 | Yuri | Lau | 367 1st Ave | Smithville | TX | 78657 | (512) 555-2021 | [email protected] | 213 |
| 8495034 | Jason | Harden | 9009 Bolton St | Austin | TX | 78739 | (512) 555-2319 | [email protected] | 213 |
| 8567302 | Daniel | Bean | 1433 Walpole Ln | Austin | TX | 78739 | (512) 555-2100 | [email protected] | 159 |
| 8572034 | Jonathan | Ninomiya | 632 Langston Dr | Austin | TX | 78723 | (512) 555-2023 | [email protected] | 339.123.78 |
| 8751243 | Fredric | Kerrison | 278 Chapparral Trl | Dale | TX | 78616 | (512) 555-9358 | [email protected] | 213 |
| 8938456 | Florence | Zimmerman | 98 San Jacinto Blvd | Austin | TX | 78701 | (512) 555-9356 | [email protected] | 213 |
| 9039453 | Carlito | Ramos | 6432 Old Harbor La | Austin | TX | 78739 | (512) 555-2324 | [email protected] | 298 |
| 9183467 | Martin | Paffenroth | 553 Silverado Dr | Kyle | TX | 78640 | (512) 555-2317 | [email protected] | 421 |
| 9340582 | Howard | Fouladi | 276 Bayou Bend Dr | Buda | TX | 78610 | (512) 555-0310 | [email protected] | 213 |
| 9348572 | Pablo | Brandozzi | 10006 Woodland Village Dr | Austin | TX | 78750 | (512) 555-1009 | [email protected] | 415.03 |
| 9375202 | Marilyn | Youson | 8723 Leisure Dr | Austin | TX | 78754 | (512) 555-2063 | [email protected] | 213 |
| 9385602 | Lloyd | Murphy | 657 Newfield Ln | Austin | TX | 78703 | (512) 555-0306 | [email protected] | 300.01 |
| 9583924 | Moniquin | Lett | 1121 Ascot St | Georgetown | TX | 78627 | (512) 555-2016 | [email protected] | 159 |
| ID | mSysRowId |
|---|---|
| 1 |