GO19_AC_CH03_GRADER_3A_HW - Students and Majors 1.0

expmen
Singh_GO19_AC_CH03_GRADER_3A_HW.zip
Home>Computer Science homework help>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 jbass@tlcc.edu 105
1102544 Hugh Goldstein 925 Conway Dr San Marcos TX 78666 (512) 555-0300 hgoldstein@tlcc.edu 785
1284354 Katie Eckert 10305 Windstone Ct Manor TX 78653 (512) 555-9357 keckert@tlcc.edu 303
1284734 Marianne Berguin 180 Snyder Trl Liberty Hill TX 78642 (512) 555-1006 mberguin@tlcc.edu 320.55
1298345 Shawn Boulward 5689 Wild Foxglove Rd Spicewood TX 78669 (512) 555-2321 sboulward@tlcc.edu 200
1728193 Jean Zadro 4345 Palacios Cir Austin TX 78749 (512) 555-2312 jzadro@tlcc.edu 421
1846834 Lan Geng 170 Goldenrod St Kyle TX 78640 (512) 555-1005 lgeng@tlcc.edu 551
2034834 Larry Telfer 162 Rattlesnake Ln Red Rock TX 78662 (512) 555-2017 ltelfer@tlcc.edu 303
2349535 Ashwin Vohra 316 Lost Cove Dr Spicewood TX 78669 (512) 555-0302 avohra@tlcc.edu 215
2583697 Cleta McElaney 132 Copperfield Dr Austin TX 78753 (512) 555-0305 cmcelaney@tlcc.edu 421
2595304 Joyce Siegel 2678 Pettytown Rd Red Rock TX 78662 (512) 555-0302 jsiegel@tlcc.edu 105
2738473 Ahjamu Ibtehal 510 Buttonwood St Bastrop TX 78602 (512) 555-2020 aibtehal@tlcc.edu 551
2834850 Ryan Asfar 1325 Drifting Wind Run Dripping Springs TX 78620 (512) 555-0308 rasfar@tlcc.edu 200
2834953 Chinonso Austin 123 Wild Buffalo Dr Kyle TX 78640 (512) 555-1012 caustin@tlcc.edu 320.55
2837490 Caitlyn Hardy 359 Bentwood Dr Leander TX 78646 (512) 555-2310 chardy@tlcc.edu 700
2839403 Nicole Dutton 122 Whispering Spring Ln Georgetown TX 78633 (512) 555-2315 ndutton@tlcc.edu 215
2840583 Oscar Prince 367 Encino St San Marcos TX 78666 (512) 555-1014 oprince@tlcc.edu 785
2845209 Stephan Elraheb 351 Wild Senna Dr Pflugerville TX 78660 (512) 555-1011 selraheb@tlcc.edu 415.03
2845721 Dana Larsen 789 Bois Darc St Lockhart TX 78644 (512) 555-2314 dlarsen@tlcc.edu 551
2847194 Ginetta Gant 100B W Mercer St Dripping Springs TX 78620 (512) 555-2321 ggant@tlcc.edu 400
2849201 Lisa Sharpe 567 N Pecos St Lockhart TX 78644 (512) 555-2313 lsharpe@tlcc.edu 320.55
2849523 Moises Fernandez 124 Woodland Ln Round Rock TX 78665 (512) 555-2320 mfernandez@tlcc.edu 700
2903485 Jalpit Matson 3204 Bird Call Pass Austin TX 78754 (512) 555-2028 jmatson@tlcc.edu 105
2934853 Khrystyna Tilson 11520 Oaklynn Ct Manor TX 78653 (512) 555-2328 ktilson@tlcc.edu 225.03.01
2938593 Curtis Dawson 10344 Yellowstone Dr Austin TX 78747 (512) 555-2015 cdawson@tlcc.edu 900
3128456 WenLi Wall 14380 Ceylon Tea Cir Pflugerville TX 78660 (512) 555-2329 wwall@tlcc.edu 158
3458632 Stephanie Caputo 1731 Primrose Tr Round Rock TX 78665 (512) 555-2330 scaputo@tlcc.edu 900
3569325 Carlis Thomas 28A 4th Ave Smithville TX 78657 (512) 555-0301 cthomas@tlcc.edu 421
3572184 Carla Reid 715 Pampas Ricas Dr Leander TX 78641 (512) 555-2026 creid@tlcc.edu 160.330.33
3586943 Joseph Stavish 660 Bayou Bend Dr Buda TX 78610 (512) 555-9360 jstavish@tlcc.edu 158.101.07
3593653 Anna Hernandez 2132 Mesquite Ln Georgetown TX 78626 (512) 555-0301 ahernandez@tlcc.edu 367
3768532 Rebekah Alexander 218 Chapparal Trl Dale TX 78616 (512) 555-1017 ralexander@tlcc.edu 339.123.78
3802483 Maria Alvarez 3590 Longhorn Trl Round Rock TX 78681 (512) 555-2026 malvarez@tlcc.edu 415.03
3802843 Anthony Scott 65 Oakwood Dr Dale TX 78616 (512) 555-2326 ascott@tlcc.edu 369
3819375 Jennifer Locanda 10543 Blake Manor Rd Manor TX 78653 (512) 555-2311 jlocanda@tlcc.edu 656
3824752 Jaehee Wang 2508 Falcon Dr Round Rock TX 78681 (512) 555-1003 jwang@tlcc.edu 320.11
3829356 Marcel Enescu 1900 White Oak Loop Round Rock TX 78681 (512) 555-1007 menescu@tlcc.edu 200
3829465 Tony Downey 113 Zarogoza St Elgin TX 78621 (512) 555-1013 tdowney@tlcc.edu 700
3829476 Xifeng Lau 127 Bateman Rd Red Rock TX 78662 (512) 555-2317 xlau@tlcc.edu 160.330.33
3842958 McCall Cheney 1053 Tumbleweed Dr Dale TX 78616 (512) 555-1023 mcheney@tlcc.edu 225.03.01
3845724 Mihir Subramanian 670 Mogonye Ln Elgin TX 78621 (512) 555-2029 msubramanian@tlcc.edu 320.11
3847563 Andrew Lee 14010 Big Thicket Dr Austin TX 78747 (512) 555-1002 alee@tlcc.edu 785.070.87
3847589 Prince Flitcroft 7821 Winsted Ln Austin TX 78703 (512) 555-1021 pflitcroft@tlcc.edu 900
3849234 Donald Hanby 334 Blue Heron Run Wimberley TX 78676 (512) 555-2316 dhanby@tlcc.edu 158
3852349 Kirsten Riccardi 632 Ranchero Rd Leander TX 78645 (512) 555-9359 kriccardi@tlcc.edu 300
3852938 Atonye Morris 1172 Buttonwood St Bastrop TX 78602 (512) 555-1018 amorris@tlcc.edu 160.330.33
3856930 Cong Nguyen 444 E Alamo St Elgin TX 78621 (512) 555-1004 cnguyen@tlcc.edu 339
3856958 Danila Bennett 808 Springbrook Ln Leander TX 78641 (512) 555-9364 dbennett@tlcc.edu 159
3857493 Sonia Olson 193 Middle Creek Dr Buda TX 78610 (512) 555-2024 solson@tlcc.edu 200
3857684 Michael Stanton 6732 Langhorn St Austin TX 78741 (512) 555-2327 mstanton@tlcc.edu 367
3859305 Mildred Santangelo 687 Horseback Hollow Austin TX 78732 (512) 555-0307 msantangelo@tlcc.edu 339.511.01
3859323 Micah Rosario 376 Grange St Liberty Hill TX 78642 (512) 555-1015 mrosario@tlcc.edu 225.03.01
3859375 Nancy Morrissey 903 Alpine Rd Austin TX 78704 (512) 555-2061 nmorrissey@tlcc.edu 105
3905345 Oscar Alvarado 214B Bluff St Buda TX 78610 (512) 555-1022 oalvarado@tlcc.edu 421
3948506 Kerry Fleischer 2984 Piping Rock Trl Austin TX 78748 (512) 555-0309 kfleischer@tlcc.edu 339
3957203 Howard Fishman 1842 Sorghum Hill Dr Austin TX 78754 (512) 555-2062 hfishman@tlcc.edu 785.070.87
4352863 Christine Bradley 2708 Kickapoo Cavern Dr Pflugerville TX 78660 (512) 555-2013 cbradley@tlcc.edu 215
4719238 Avelina DiAntonio 1008 Sunset Canyon Dr Dripping Springs TX 78620 (512) 555-2319 adiantonio@tlcc.edu 339
4739502 Eliza Alvarez 3590 Longhorn Trl Round Rock TX 78681 (512) 555-2025 ealvarez@tlcc.edu 298
4769304 Jana Furfy 2107 Edenwood Dr Austin TX 78745 (512) 555-2064 jfurfy@tlcc.edu 821
4852384 James Parkhill 105 E Myrtle St Liberty Hill TX 78642 (512) 555-2323 jparkhill@tlcc.edu 105
5720358 Margot Schneider 628C Farm St Bastrop TX 78602 (512) 555-2101 mschneider@tlcc.edu 421
5730483 Clement Forrester 1506 Wilshire Blvd Austin TX 78722 (512) 555-2018 cforrester@tlcc.edu 339
5738495 Robert Chun 786 W Live Oak St Lockhart TX 78644 (512) 555-2331 rchun@tlcc.edu 369
5739437 Eugene Sotova 130 Garwood St Smithville TX 78657 (512) 555-2030 esotova@tlcc.edu 339
5748392 Renato Cildaro 334 Sand Hills Rd Red Rock TX 78662 (512) 555-2318 rcildaro@tlcc.edu 298.05
5820384 Edward Rose 555 S Blanco St Lockhart TX 78644 (512) 555-2019 erose@tlcc.edu 339.511.01
5834924 Anastasia Kakaulian 4822 Turtle Mound Bnd Austin TX 78748 (512) 555-2031 akakaulian@tlcc.edu 821
5835035 Laurence Poon 263 Caddis Cv Kyle TX 78640 (512) 555-0304 lpoon@tlcc.edu 785.45
5849320 Reza Soltan 5498 Wild Foxglove Rd Spicewood TX 78669 (512) 555-9362 rsoltan@tlcc.edu 339.511.01
5860300 Daria Campbell 162 Rockwood Dr Wimberley TX 78674 (512) 555-1016 dcampbell@tlcc.edu 300.01
5867384 Hashem Avis 532 Virginia St San Marcos TX 78666 (512) 555-9363 havis@tlcc.edu 785.45
6738419 Kevin Leopoldo 476 Beaukiss Ln Elgin TX 78621 (512) 555-1019 kleopoldo@tlcc.edu 656
6739234 Janie Martinez 840 Abbey Glen Castle Dr Pflugerville TX 78660 (512) 555-2027 jmartinez@tlcc.edu 785.07
6739256 Katherine Brown 707 Walnut St Bastrop TX 78602 (512) 555-2012 kbrown@tlcc.edu 339
6739319 Zack Rowe 8728 Texas Bluebell Dr Spicewood TX 78669 (512) 555-1020 zrowe@tlcc.edu 298.05
6753841 Jill Hutzell 6462 Bisview Dr Austin TX 78730 (512) 555-9361 jhutzell@tlcc.edu 785.070.87
7348502 Yianna Mathis 1187 Barilla Mountain Trl Round Rock TX 78665 (512) 555-0303 ymathis@tlcc.edu 785.07
7384952 Christopher Darko 240 Washington St Smithville TX 78657 (512) 555-1008 cdarko@tlcc.edu 300
7481938 Jamal Hardy 664 Carson Ave Liberty Hill TX 78642 (512) 555-2318 jhardy@tlcc.edu 158
7583249 Betty Poon 263 Caddis Cv Kyle TX 78640 (512) 555-1001 bpoon@tlcc.edu 421
8247593 Patrice Martinez 3632 Castle Path Round Rock TX 78681 (512) 555-2022 pmartinez@tlcc.edu 821
8273409 Naomi Henigson 22568 Briarcliff Dr Spicewood TX 78669 (512) 555-2014 nhenigson@tlcc.edu 440.303.01
8273438 Edgardo Pabelonia 894 Hidden Hills Dr Dripping Springs TX 78620 (512) 555-2322 epabelonia@tlcc.edu 298
8273485 Pei Tram 3567 Vanderbilt Cir Pflugerville TX 78660 (512) 555-2027 ptram@tlcc.edu 440.303.01
8347568 Yolanda Tram 3152 Homewood Cir Round Rock TX 78665 (512) 555-2025 ytram@tlcc.edu 298.67
8374853 Hendrick Themis 2590 Mesquite Ln Georgetown TX 78226 (512) 555-1010 hthemis@tlcc.edu 400
8394284 Nora Ramos 234 Melody Way Wimberley TX 78676 (512) 555-2325 nraramos@tlcc.edu 213
8473849 Yuri Lau 367 1st Ave Smithville TX 78657 (512) 555-2021 ylau@tlcc.edu 213
8495034 Jason Harden 9009 Bolton St Austin TX 78739 (512) 555-2319 jharden@tlcc.edu 213
8567302 Daniel Bean 1433 Walpole Ln Austin TX 78739 (512) 555-2100 dbean@tlcc.edu 159
8572034 Jonathan Ninomiya 632 Langston Dr Austin TX 78723 (512) 555-2023 jninomiya@tlcc.edu 339.123.78
8751243 Fredric Kerrison 278 Chapparral Trl Dale TX 78616 (512) 555-9358 fkerrison@tlcc.edu 213
8938456 Florence Zimmerman 98 San Jacinto Blvd Austin TX 78701 (512) 555-9356 fzimmerman@tlcc.edu 213
9039453 Carlito Ramos 6432 Old Harbor La Austin TX 78739 (512) 555-2324 cramos@tlcc.edu 298
9183467 Martin Paffenroth 553 Silverado Dr Kyle TX 78640 (512) 555-2317 mpaffenroth@tlcc.edu 421
9340582 Howard Fouladi 276 Bayou Bend Dr Buda TX 78610 (512) 555-0310 hfouladi@tlcc.edu 213
9348572 Pablo Brandozzi 10006 Woodland Village Dr Austin TX 78750 (512) 555-1009 pbrandozzi@tlcc.edu 415.03
9375202 Marilyn Youson 8723 Leisure Dr Austin TX 78754 (512) 555-2063 myouson@tlcc.edu 213
9385602 Lloyd Murphy 657 Newfield Ln Austin TX 78703 (512) 555-0306 lmurphy@tlcc.edu 300.01
9583924 Moniquin Lett 1121 Ascot St Georgetown TX 78627 (512) 555-2016 mlett@tlcc.edu 159
ID mSysRowId
1