Page 1 of 6 123456 LastLast
Results 1 to 15 of 88
  1. #1
    k14ton is offline Advanced Beginner
    Windows 7 32bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    55

    Does anyone have completed assignments for New Perspectives on Microsoft Access 2010?


    Hello everyone, I'm new to this forum. Does anyone have all the completed assignments for this book because I need to compare my work to someone else's work to see if I did my assignments properly. I especially need these ones: Case Problem 1 pgs. 351-353, Case , Problem 1 pgs. 409-410, Case Problem 1 pgs. 465, Case Problem 1 pgs. 513-514, Case Problem 1 pgs. 565, Case Problem 1 pgs. 606, Case Problem 1 pgs. 661-662. I need this as soon as possible so if you guys can post these completed assignments in your postings I would really appreciate it. Thank you!!!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Why don't you post one of the problems and your solution and we'll see if we agree with it?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    k14ton is offline Advanced Beginner
    Windows 7 32bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    55
    Here is one of the assignments I need help with. If you guys could check through the whole assignment to see if there are any errors, please let me know. I know I was having trouble with when I click on Select Contract and choose a number the Student ID and Teacher ID do not change accordingly. However, if there any problems that you could point out to me I would really appreciate it. Thanks.
    Attached Files Attached Files

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    The Select Contract combobox should be UNBOUND. This control is used to input search criteria. If BOUND you will change the value in record. Controls for input of search criteria should be UNBOUND.

    There are two orphan labels on frmLessonsByTeacherSplitForm
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    k14ton is offline Advanced Beginner
    Windows 7 32bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    55
    Another question I have is with Case Problem 1, pgs. 513-514. When I created a make table query based on the qryLessonsByTeacher query, how would I enter the LessonType field values correctly so I could see the correct results when I run the query? Thanks.


    Portland1.zip

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    You can't really "cascade" anything in a 1-1 relationship nor set ref int because it's not logical to do so. Which is the master and which is the detail? Logically, there is no definition.

    I don't understand your question about the LessonType field. Do you want to have filter criteria for this field as well as the LessonLength?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    k14ton is offline Advanced Beginner
    Windows 7 32bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    55
    Hey, if anyone has both Case Problem 1,Pages 206-207 and Case Problem 1, Pages 513-514 completed, may you please post it because I want to see where I may have went wrong in my assignments. I will post post both of my assignments as well. Thanks.


    Portland1.zip Contract.zip

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    In qryLessonsByTeacher the LessonType criteria is under the LessonLength field.

    Do you have any other specific questions?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    k14ton is offline Advanced Beginner
    Windows 7 32bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    55
    For Lab 6 after I created frmContract, I'm having trouble with number 7. Even though I have the Student ID and Teacher ID combo boxes, how would I select the LastName, FirstName, and Student/Teacher ID from the tblStudent and tblTeacher table, and sort in ascending order by the LastName field and then by the FirstName field? Here is my lab below.



    Contract_2013-04-18.zip

  10. #10
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Use a query for the combobox RowSource. Try:

    SELECT StudentID, LastName & ", " & First Name AS StudName FROM tblStudent ORDER BY LastName, First Name;
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  11. #11
    k14ton is offline Advanced Beginner
    Windows 7 32bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    55
    Hey, thanks for responding. I went to the property sheet and for the Row Source Type I have Table/Query. In the Row Source part I entered SELECT StudentID, LastName & ", " & First Name AS StudName FROM tblStudent ORDER BY LastName, First Name;. However it did not work for me for both the empty box for StudentID and TeacherID combo boxes. I'm not sure what I did wrong. I'm a little confused in this part.

  12. #12
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Sorry, looks like I left a space in the FirstName field name.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  13. #13
    k14ton is offline Advanced Beginner
    Windows 7 32bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    55
    Ok now its working. Now its saying add a calculated control that displays the ttal of the MonthlyLessonCost and MonthlyRentalCost fields. Set the calculated controls Tab Stop property to No and format the values as currency with no decimal places. I need help with this part as well.

  14. #14
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I guess you need to add those two fields. Textbox ControlSource property would be a simple expression.

    =MonthlyLessonCost + MonthlyRentalCost

    Set the other properties as instructed.

    This is all elementary functionality and should have already been explained in lesson lecture or reading.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  15. #15
    k14ton is offline Advanced Beginner
    Windows 7 32bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    55
    Yeah, I already fixed that issue already.

Page 1 of 6 123456 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 03-09-2012, 04:21 PM
  2. Replies: 0
    Last Post: 02-23-2012, 10:42 AM
  3. Microsoft Access 2010 - Filtered report?
    By keaccesshelp in forum Reports
    Replies: 1
    Last Post: 02-21-2012, 03:36 PM
  4. Replies: 1
    Last Post: 09-13-2011, 01:52 PM
  5. Microsoft Access 2007 - 2010 Compatibility
    By AccessFreak in forum Forms
    Replies: 4
    Last Post: 01-05-2011, 07:57 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums