NP_Access2010_T3_CP1a_AndrewYeo_2
1 Page

NP_Access2010_T3_CP1a_AndrewYeo_2

Course: BUSN 161, Spring 2013

School: Richard Stockton...

Word Count: 438

Rating:

Document Preview

SAM Projects 2010 Andrew Yeo, NP Access Case T3_CP1A Submission #1 Score is 100 out of 100 1. Verify that your name appears in the first record in the _SAMProjects table. 2. In the Teacher table, change the following information for the record with TeacherID 555310: Degree is BM and Hire Date is 3/12/2012. Close the table. 3. In the Student table, find the record with the Student ID HAV7535, and...

Unformatted Document Excerpt
Coursehero >> New Jersey >> Richard Stockton College of NJ >> BUSN 161

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Projects SAM 2010 Andrew Yeo, NP Access Case T3_CP1A Submission #1 Score is 100 out of 100 1. Verify that your name appears in the first record in the _SAMProjects table. 2. In the Teacher table, change the following information for the record with TeacherID 555310: Degree is BM and Hire Date is 3/12/2012. Close the table. 3. In the Student table, find the record with the Student ID HAV7535, and then delete the related record in the subdatasheet for this student. Delete the record for Student ID HAV7535, and then close the Student table. 4. Create a query based on the Student table that includes the LastName, FirstName, and MobilePhone fields, in that order. Save the query as StudentPhoneList, and run the query to confirm it works. 5. In the results of the StudentPhoneList query, change the phone number for Andrea Barreau to 503-579-2277. Close the query. 6. Use Design view to create a query based on the Teacher and Contract tables. Display the LastName field from the Teacher table, and the StudentID, EndDate, LessonType, LessonLength, and LessonCost fields, in that order, from the Contract table. Sort in ascending order first on the teacher's last name, and then in ascending order by the StudentID. Save the query as LessonsByTeacher, and run the query to confirm it works. 7. Display view, Backstage and then save the LessonsByTeacher query as CurrentLessons. Modify the CurrentLessons query to only display contracts that end on or after 7/1/2013. This should be done by adding a single criteria using the >= operator. Save your changes to the CurrentLessons query, and then run the query to confirm it works. 8. Display Backstage view, and then save the CurrentLessons query as CurrentGuitarLessons. Modify the CurrentGuitarLessons query criteria to display only those records for Guitar lesson contracts that end on or after 7/1/2013. (Note: Since it is based on the CurrentLessons query, the CurrentGuitarLessons query should already display contracts that end on or after 7/1/2013.) Run the query to confirm it works, and then save the query. 9. Modify the CurrentGuitarLessons query so that it does not show the lesson type. 10. In the CurrentGuitarLessons query datasheet, display the Total row and show the total amount for the lesson monthly cost. 11. Change the alternate row color in the CurrentGuitarLessons query datasheet to the Theme Color named Purple, Accent 4, Lighter 60% (third row, eighth column), and change the font size to 12. Save and close the query. SAM Projects COPYRIGHT 2010 PGS Systems Ref: 0E074BCB0B20056A -- Inference Engine version: IE1.1.80, KB version KB1.1.80

Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

SMU - CSE - 2341-H
bloodied\bloodier\bloodiest\bloodily\bloodless\bloods\bloodshed\bloodshedding\bloodstained\bloody\bloom\blooms\blossom\blossoming\blossoms\blot\blots\blotted\blotting\blount\blow\blowed\blowers\blowest\blowing\blown\blows\
Cornell - AEP - 4900
199534696006702E-5 -1.7828054502123396E-4 -1.7461452464114116E-5 3.5811256541869305E-7-1.0234964504313491E-7i -3.545152343116347E-7+8.334788303852308E-8i 2.3381082704927625E-6-5.879041361350748E-7i6.502237374118893E-5 -1.736
Atma Jaya University, Yogyakarta - ECONOMIC - 1
n.c. Saya lebih menyukai produk (jawaban pilihan di atas) dibandingkan denganproduk merek lain.3. Kualitas Produka. Saya memilih ponsel Android merek (jawaban pilihan di atas) karenamerupakan produk yang inovatif dibandingkan dengan produk yan
Richard Stockton College of NJ - BUSN - 161
Altac BicyclesIncome Statement*For the Years Ended December 31, 2011 through December 31, 2013YearSales20132012201113,5204,1409,38010,9813,9607,0219,0343,0116,0231,6322,6315215015,2851,4812,1124104044,4071,3921,8403752813,88
Richard Stockton College of NJ - BUSN - 161
SAM Projects 2010Andrew Yeo, NP Excel Case T1_CP1ASubmission #3Score is 100 out of 1001. Verify that your name appears in cell B4 of the Documentation sheet.2. Switch to the Sheet1 worksheet, then enter the following text on two lines within cell A1:
Richard Stockton College of NJ - BUSN - 161
SAM Projects Office 2010NP EXCEL 2010 T2 CP1a - FrostiWearAuthorDO NOT DELETE-> %(64F58BE3E4E9C2B6-0310844C73AA66C1)%Andrew YeoNote: Do not edit this sheet. If your name does not appear in cell B4,please download a new copy of the start file from th
Richard Stockton College of NJ - BUSN - 161
SAM Projects 2010Andrew Yeo, NP Excel Case T2_CP1ASubmission #3Score is 100 out of 1001. Verify that your name appears in cell B4 of the Documentation sheet.2. In the Information sheet, set the background color for all the cells in the worksheet to s
Richard Stockton College of NJ - BUSN - 161
SAM Projects Office 2010NP EXCEL 2010 T3 CP1a - Chemistry 303AuthorDO NOT DELETE-> %(64F58BE3E4E9C2B6-1B537D0D627EF37D)%Andrew YeoNote: Do not edit this sheet. If your name does not appear in cell B4, pleasedownload a new copy of the start file from
Richard Stockton College of NJ - BUSN - 161
SAM Projects 2010Andrew Yeo, NP Excel Case T3_CP1ASubmission #4Score is 90 out of 100101. Verify that your name appears in cell B4 of the Documentation sheet.2. In the First Semester Scores worksheet, in cell F17, enter a formula to calculate the we
Richard Stockton College of NJ - BUSN - 161
SAM Projects 2010Andrew Yeo, NP Excel Case T4_CP1ASubmission #1Score is 100 out of 1001. Verify that your name appears in cell B4 of the Documentation sheet.2. In the Park Usage Data worksheet, select the range A3:D15, and then insert the 3-D Column
Richard Stockton College of NJ - BUSN - 161
SAM Projects Office 2010NP EXCEL 2010 T4 CP1a - Kenai Fjords National ParkAuthorAndrew YeoNote: Do not edit this sheet. If your name does not appear in cell B4, pleasedownload a new copy of the start file from the SAM web site.DO NOT DELETE-> %(64F5
Richard Stockton College of NJ - BUSN - 161
SAM Projects 2010Andrew Yeo, NP Excel Case T4_CP1ASubmission #1Score is 100 out of 1001. Verify that your name appears in cell B4 of the Documentation sheet.2. In the Park Usage Data worksheet, select the range A3:D15, and then insert the 3-D Column
Richard Stockton College of NJ - BUSN - 161
*VolunteerServiceatYosemiteRegionalHospital*DanDruff*Menandwomenfromallwalksoflife*Currentlyabout400volunteers*Averageofabout2400volunteerhoursperweek*Volunteersworkinalmostalldepartmentswithinthehospital.*OurVolunteersVolunteeringatYosemiteRe
Richard Stockton College of NJ - BUSN - 161
Look on last slide for Summary PageSlide Comments:Slide should not have Pan transition (see step 13)*VolunteerServiceatYosemiteRegionalHospital*DanDruff*Menandwomenfromallwalksoflife*Currentlyabout400volunteers*Averageofabout2400volunteerhoursper
Richard Stockton College of NJ - BUSN - 161
Castles of ScotlandMoyra TorphinsGo to Home PageScottish Castles1Successful PromotionalPackageThe Intersection ofSuccessScottish Castles2Scottish PromotionalPackageFly from NewYork, throughLondon, toEdinburghStay in five-starhotel at bas
Richard Stockton College of NJ - BUSN - 161
Look on last slide for Summary PageCastles of ScotlandMoyra TorphinsGo to Home PageScottish Castles1Slide Comments:Width of shape should be changed so that "The Intersection" is on one line and "of Success" on another for required font size and fon
Richard Stockton College of NJ - BUSN - 161
PeachTreeSchooloftheArtsSummerScheduleChangesBecause of an increased demand, we have scheduled additional drawing, acrylic painting, andjazz dance and recorder classes. Note that these are all advanced classes for students aged ten tothirteen. Classes
Richard Stockton College of NJ - BUSN - 161
SAM Projects 2010Andrew Yeo, NP Word Case T2_CP1ASubmission #2Score is 90 out of 100101. Verify that your name appears in the footer of the document.2. Apply the Title style to the title "Peach Tree School of the Arts."Paragraph should have "Title"
Richard Stockton College of NJ - BUSN - 161
IntroductionNoblewoodTextiles,Inc.,withNoblewoodTextiles,SanPietro,California,asitssole outlet,wasfoundedOctober19,1993bySelinaMartinezandMarielaPimuela.CompanyPhilosophyTheNoblewoodTextilesphilosophyissummarizedintwowords:finequality.This philosophy
Richard Stockton College of NJ - BUSN - 161
SAM Projects 2010Andrew Yeo, NP Word Case T3_CP1ASubmission #4Score is 100 out of 1001. Verify that your name appears in the footer of the document.2. Use the Navigation pane to promote the heading "Children's Knitting Hour" to Heading2 text, and th
Richard Stockton College of NJ - BUSN - 161
But if you are more interested in living in your house than decorating it, pick a style for a roomand stick with it.For most people, decorating a home involves a series of purchases and improvements over time.To maximize your design statement, consider
Richard Stockton College of NJ - BUSN - 161
Referrals for Home Care Services by Agency-June 2011 through May 2012Top Five Providers# of referralsLifestyles Home Care, Inc.2747Eastern Massachusetts Home Care Corporation 1534South Suburban Elder Care1075Elder Services of Eastern Mass, Inc.82
Richard Stockton College of NJ - BUSN - 161
Serviceaccompany to hair dresserassistance with health insurance formsbill paymentcompanionshipcounseling recommendationscrisis interventionemergency response systemerrandsescort to medical appointmentsestate planningfoot caregrocery shopping
Richard Stockton College of NJ - BUSN - 161
RipCity Digital Customer OrdersAuthorDatePurposeAndrew YeoTo record orders from RipCity Digital customersRipCity DigitalCustomer Orders3/31/2013LastFirstFerrisAndrewGarciaSusanTorbetDr. LilaRhodenTonyAddress135 College AvenueBar Harbo
Richard Stockton College of NJ - BUSN - 161
3870 West BearLake RoadShare-My-Toys,Montpelier, IDInc.83220208-555-3870You want to enjoy greatoutdoors, but you cant afford a Boat Ski boat Canoe Kayak Waverunner Snowmobile RV ATVHow would you like to have allthose toys and more?It do
Richard Stockton College of NJ - BUSN - 161
Share-My-ToysAndrew YeoWhat is Share-My-Toys? A timeshare for recreational equipment co-op Shared ownership of: Snowmobiles Boats Waverunners ATVs RVs Camping gearHow do I join?
Richard Stockton College of NJ - BUSN - 161
OverviewPeople want to stay homeState income eligibility guidelines are very lowPeople are willing to pay for servicesHome care services cost significantly less than nursing homesLifestyles BeginningsClients frequently asked employees about addition
Richard Stockton College of NJ - BUSN - 161
Sonar TechnicianCheck in ProcessAndrew YeoService RecordTurn-in0600- Turn in service record to Bld. 145Receive a check in sheet from STG3Murphy at the front deskFollow instructions on check out sheet INORDERBarracks RoomsPermanent Barracks room
Richard Stockton College of NJ - BUSN - 161
ContractID310031023103310531073108311031133114311731193121312231253126312831303133313631373139314131443145314631473148315031523153315631573158316231643165316631673168316931703171317231743175StudentIDCAR7534M
Richard Stockton College of NJ - BUSN - 161
"BOL7533","Eddie","Bolton","320 Main St","Gresham","OR","97236","503-760-5326","503-760-1045",6/12/1997 0:00:00,"M""BRA7545","Lindsay","Brandenburg","78 Calaveras Ct","Beaverton","OR","97007","503-672-4409","503-579-4932",8/20/2000 0:00:00,"F""BUR7500",
Richard Stockton College of NJ - BUSN - 161
Use your course materials or the Internet to research information on employment. Use the following to guide yourresearch:Information regarding unemployment ratesJob creation statisticsFirst-time unemployment claim reportsStep 2: Address the following
Richard Stockton College of NJ - BUSN - 161
What trade-offs does the Federal Reserve consider when deciding how rapidly or how slowly to increase themoney supply of the U.S.?What are the dangers of increasing the money supply too slowly? Too rapidly?What factors make it difficult to predict the
FSU - ECO - 4713
FSU - ECO - 4713
FSU - ECO - 4713
FSU - ECO - 4713
FSU - ECO - 4713
FSU - EUH - 4331
FSU - EUH - 4331
FSU - EUH - 4331
FSU - EUH - 4331
FSU - EUH - 4331
FSU - EUH - 4331
FSU - EUH - 4331
FSU - EUH - 4331
FSU - EUH - 4331
FSU - EUH - 4331
Republic ofBulgariaBulFounded in 681 A.D. by KhanBulgaria in EuropeBulgariaCapital-SofiaCapital-SofiaSofia became part of the First BulgarianEmpire during the reign of Khan Krum in809. From the 12th to the 14th century,Sofia was a center of tra
Penn State - MATH017 - 017
MATH 17 - Finite MathematicsFinite Mathematics, 10th Edition; Lial, Greenwell, Ritchey; Pearson.Suggested Practice Problems:Students please note that instructors may add additional problems at their discretion.6.1 - # 1 - 89 (odd)6.2 - # 1 - 51 (odd)
Penn State - MATH017 - 017
Welcome Students!MyMathLab is an interactive website where you can: Self-test & work through practice exercises with step-by-step help to improve your math skills. Study more efficiently with a personalized study plan and exercises that match your book
Penn State - MATH017 - 017
MATH 0171. Which of the following is NOT a statement? a) You did not study for the math exam. b) My calculator is broken. c) But calculators are not permitted.FINAL EXAMSAMPLE C6. Which of the following is equivalent to the converse of `If I pass this
Penn State - MATH017 - 017
MATH 017FINAL EXAMSAMPLE B1. What truth values of p, q and r make the statement p ( q r) true? a) p = T , q = T , r = F b) p = F , q = T , r = T c) p = F , q = T , r = F d) p = T , q = F , r = F7. Let U = cfw_1, 2, 3, 4, 5, 6, 7, 8, 9, A = cfw_1, 2, 3
Penn State - MATH017 - 017
MATH 0171. Which of the following is NOT a statement? a) 2 + 3 = 17. b) Who is your daddy and what does he do? c) If it bleeds, we can kill it. d) I'll be back.FINAL EXAMSAMPLE A6. Determine (if possible) whether the following argument is valid or inv
Penn State - MATH017 - 017
MATH 017EXAM II, SAMPLE D1. Let U = cfw_2, 4, 6, 8, 10, 12, 14, A = cfw_2, 4, 6, 8, 10, and B = cfw_2, 6, 10, 14. A chili cook-o was held and judged by 3 judges (Steve, Mike, and6.Which of the following is A B ?Jill). There were 4 chilis which no jud
Penn State - MATH017 - 017
MATH 017EXAM II, SAMPLE C1. Consider the sets A = cfw_1, 2, 3, B = cfw_3, 4, 5, and C = cfw_1, 3, 5.Which one of the following is equal to the set cfw_1, 2, 3, 5?6. Out of 50 dogs at an obedience contest, 30 can shake hands, 45 canplay dead, and 28 c
Penn State - MATH017 - 017
MATH 017EXAM IISAMPLE B1. If U = cfw_0, 1, 2, 3, 4, 5, 6, 7, 8, 9, A = cfw_2, 4, 6, 7, and B = cfw_1, 2, 4, 5, 9, 6. Suppose 87 computer companies are releasing software. 21 of them have office software, 21 have game software, 19 have programming which
Penn State - MATH017 - 017
MATH 0171. How many subsets does the set cfw_1, 2, 3, 4, 5 have? a) 8 b) 16 c) 24 d) 32EXAM IISAMPLE A6. Suppose that 100 students joined at least one of three organizations: A, B and C. Suppose 37 joined club A, 46 joined club B, 56 joined club C, 14
Penn State - MATH017 - 017
MATH 017EXAM I, SAMPLE D1. Which of the following is NOT a statement?6. Which of the following is equivalent to the negation of the statementSarah owns a dog and Mike does not like cats? (Hint: use DeMorgans Laws).a) If x = 11, then x 3.b) Johnny m
Penn State - MATH017 - 017
MATH 0171. Which of the following is not a statement: a) 1 + 1 = 2. b) Earthquakes do not happen in California. c) Knock three time on the ceiling if you want me.EXAM I6. In the following truth table, find x and y. p T T F F a) x = T, y = T b) x = T, y
Penn State - MATH017 - 017
MATH 0171. Which one of the following is not a statement? a) x2 + 1 = 0. b) Today is Wednesday. c) Open the window if you want some fresh air. d) When it rains, John takes a bus home.EXAM I6. Which of the following is NOT correct? a) (p q) p q. b) ( p
Penn State - MATH017 - 017
MATH 0171. Which of the following is not a statement? a) If you're ready to leave, you can take the bus. b) 4 0. c) Jane's car is green. d) Put your notebooks under your desk.EXAM ISAMPLE A6. What is the negation of the following statement? "You shoul
Penn State - MATH018 - 018
Math 018Exam II1. The matrices below represent the augmentedmatrix of a system of 3 linear equations with3 variables x, y, z which has been row reduced.As usual the rst column corresponds to x, thesecond column corresponds to y , and the thirdcolum