GO19_AC_CH03_GRADER_3A_HW - Students and Majors 1.0

profileexpmen
Singh_GO19_AC_CH03_GRADER_3A_HW.zip

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