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

[June7]

Like this:



CreditFirstName: [FirstName]

CreditLastName: [LastName]

Make sure tblCreditCard is on the Table row under those two fields.

[k14ton]

Hey June7, sorry for not getting back to you from last night so I could post my finished lab 9. Can you check it to see if everything is correct? Here is the instructions again
http://books.google.com/books?id=udW...rtland&f=false

I will post the lab below, try to get back to me as soon as possible, thanks.

[k14ton]

Also here is the next assignment that I need to work on: http://www.cengagesites.com/academic...tutorial10.pdf Just scroll down to page 565 and Case Problem 1 will be the assignment I need to do (if you want, you could work out the assignment yourself so when I'm working on it, you and I could show each other how we both did this assignment and I can view what mistakes I may have made and correct them).

[June7]

The query from lab 9 is built properly but the constructed field names are not showing in Datasheet view because of the Caption property settings in tblCreditCard. Remove them and the fields in query will display properly. I never set Caption property or Lookup in tables.

Not going to do the exercise. Continue as you are - post question if you have specific issue.

I don't use macros.

[k14ton]

Ok, if you don't use macros then I'll just skip to lab 11 which is still using the same database as Lab 9. Here is the link of the assignment, it is Case Problem 1 http://books.google.com/books?id=udW...onvert&f=false

I'm a bit confused on this section, how do I create a procedure for the frmTeachersAndContracts form to convert School field values to proper case-capitalize the first letter of each word, and convert all other letters to lowercase?

[June7]

I don't use macros but I understand them. I wouldn't do the exercise even if it didn't involve macros.

Google: Access title case

http://support.microsoft.com/kb/815282

[k14ton]

Hey June7, thats fine, here is a question I have for lab 10. I created a list box with a name property value of lsQueryList. however, how do I get it to display all the query names contained in the Portland database, excluding those queries that start with a "~" character? I will post the lab in a moment so you could see where I'm at.

[k14ton]

Here is the lab below, I'm currently on frmQueries. Try to get back to me as soon as possible June7 because I'm going to try to finish both lab 10 and 11 tonight and I will have some questions for that too.

[June7]

Page AC552 of lab 10 tutorial shows that query.

[k14ton]

Ok I got that part finished, I will post what I got so far shortly so you could see if I'm doing it correct, I'm currently working on adding command buttons.

[k14ton]

Ok June7, here is what I got so far for the frmQueries (check the lab below). Also how do I disable the form's shortcut menu, record selectors, and navigation buttons for frmQueries? Aside from that, does frmQueries look correct so far? Now I'mgoing to work on frmNavigation, I will post that up later on tonight so you can check that too. Thanks.

[June7]

Disable those properties on the form Properties Sheet. Explore the Properties Sheet. Find the stated properties, change setting as appropriate.

Tell me if the listbox query is not showing what you expect. Does it list all the queries you expect to see?

[k14ton]

Yeah, it list all the queries. I'm working on the navigation form so I'll post it shortly so you could review it to see if its correct, thanks.

[k14ton]

Ok, I finished the frmNavigation so you could check it if everything seems correct. Also, in the beginning of the lab where it first talks about creating frmQueries, it talks about use the text Portland Queries on the form's tab. How do I do that (if I even have to do it)? Now I'm going to start lab 11 so I'll definitely have some more questions for you haha, thanks for all the help you have been giving me, I appreciate it! P.S. I will post the latest update of lab 10 down below for you to check it out.

[k14ton]

Ok, in Lab 11, since I have to create a procedure for the frmTeachersAndContracts form to convert School field values to proper case, I opened up the frmTeachersAndContracts form in Design view, and then I clicked on the School textbox. I went to the property sheet and I went to the Event tab and clicked the After Update boox and clicked the build button and clicked Code builder. then the code window opens in the Visual Basic window. Then I entered this code in Option Compare Database

Private Sub School_AfterUpdate()
SELECT testText, STRCONV(testText,3) as TestText_in_Proper_Case FROM MyTestTextList
End Sub

However, it didn't work. What is the correct way to do the procedure if this is incorrect?