Course List - Access 102

Student Interaction: Microsoft Access 102

Richard on 1/1/2007: Field properties, searching, sorting, filtering, more query tricks, parameters, combo boxes, reports, compact, repair. 129 Minutes.

candy on 10/13/2007: i find access 101 very useful for me as a starter of using access.. i wanted to learn about the rest of the access tutorial for free but i can't afford to buy the cd. i hope that you'll provide free tutorials for the rest of the course. thank you.. and more power

Richard Rost on 10/13/2007: Candy, I understand your financial concerns. I've tried my best to keep my tutorials as inexpensive as possible (where else can you find an hour of Access training for six bucks?) I do try to provide a lot of free lessons - if you look through the Theater, you'll see that each course has a couple of free lessons on it. Plus, I try to post as many free Tips as I can every week. Obviously, I' [more...]

John �Casey on 12/2/2007: I can't get the contents of a list box to sort alpha. When I click on a name in the list box, I get a form with that person�s name which is what I want. The query is sorted ascending but the contents of the list box are sorted by auto number. Can you help?

Richard Rost on 12/9/2007: Yep. We get to this in Access 202 Lesson 3 - sorting the contents of a combo box or list box. A quick solution: design a query that sorts the way you want, and then use that query as the data source for your list box.

Judith�Koester on 12/12/2007: When I click on Combo Box and click on design view, I don't get the wizard, I get the label and box.

Judith Koester on 12/12/2007: On the Reports, Lesson 7, you titled the Report CustomersWithFullAddressQ. Was there a reason it didn't end with an R? Love these classes. Judith

Richard Rost on 1/5/2008: Make sure you have the WIZARDS set to ON on your toolbox. This is the button that looks like a magic wand. If it's not pushed down, none of the wizards will start.

Richard Rost on 1/5/2008: This was a mistake. While running the Wizard I accidentally typed in a "Q" instead of an "R". You're right. Thanks for pointing it out. For everyone else, it happens around time index 10:00. I just didn't catch it at the time.

israel �rivera on 1/14/2008: Hi. If I bought a course without the PDF handbook, but find that I may want to purchase the handbook after all, how may I do so?

Richard Rost on 1/17/2008: Just go to www.599cd.com/HandbooksOnly and you can purchase the handbook from there.

Angela on 4/2/2008: There is a section in this lesson that apparently got skipped. It's only a few seconds, but for beginners, every word can be vital. The time on the video where it omits something is right around 18:47. You are discussing the Yes/No field and then all of a sudden there is a formatting that is displayed on the screen for the phone number field. I did figure out what was omitted, but thought this should be brought to your attention.

Richard Rost on 4/2/2008: Angela, you are correct. Right around 18:47 there is about 10 seconds of video missing. I was showing you how to create an INPUT MASK for a phone number using the characters: @@@-@@@-@@@@. It's visible in the video, but the explanation somehow got cut off accidentally in editing. Next time I update the video, I'll have to make sure to fix that!

salvador�garcia on 4/15/2008: Hi Richard, I have some records in excel files. In order to work such data in Access is there a way to improt such data into an Access Table? tks in advance for you assistance.

Richard Rost on 4/16/2008: Salvador, you can go to FILE > GET EXTERNAL DATA > IMPORT to bring in the information from Excel into a table. I cover this in Access 308.

� on 4/28/2008: How do I find the Table for Access 102 for practice?

Richard Rost on 4/29/2008: All of the files for the Access classes have been moved to the Student Database Files web page.

salvador�garcia on 4/30/2008: Hello I finished Acess 102. I tried to presetn my test however I did not find in the list Acess 102. Is acess 220 the test to take for this level? it looks to me a higher degree. Pls comment. Tks Salvador

sony�cohen on 5/1/2008: I have a field named priceFOB (currency / 2 decimals / standard ) but the system rounds it 15.20 => 15.00 , do you know why ?? any idea where to look at ??

�Chris Morgan on 5/16/2008: When I right click on the picture box I don't get an "insert object" option. When I drag a pictire into the box, it won't show the picture, just the file name. If I click on the file name, I can see the picture in a separate window.

Kevin Dore on 5/18/2008: When I try to insert a picture as an OLE into a form, only the picture file name appears in the box and not the picture. How come ?

John D on 5/20/2008: How do you apply a sort criteria that contradicts another? I have a table of customers and only certain zip codes will be included in a mailing. However, some of these customers are marked VIP - which means, a separate text field includes these three characters. How do I have mail sent to these customers, even though the zip sort has excluded them? Thanks

Richard Rost on 5/24/2008: Salvador, the test for Access 102 is NOT available at this moment. I rebuilt the test-taking portion of the web site a little while back, and I haven't finished putting all of the tests back online yet. I'll post a note here when it's ready. Sorry for the confusion.

Richard Rost on 5/24/2008: Sony, if it's definitely a currency value at 2 decimals, it shouldn't be rounding it like that unless you have some other type of formatting established in your form... is this happening at a TABLE level too or just in your form?

Richard Rost on 5/24/2008: Chris, go to the properties for the box and make sure it's a BOUND OBJECT FRAME. I don't know why you don't see the "Insert Object" option. That should always be available. As far as the picture/filename problem goes, in the properties for the box, make sure that the DISPLAY TYPE property is set to CONTENT.

Richard Rost on 5/24/2008: Kevin, I was just researching this myself, and I found some interesting information about some changes in Access 2003. I don't know if Access 2007 behaves this way too, but here's what I found out: Microsoft used to distribute MS Photo Editor with previous versions of Office (97, 2000, and XP). Apparently, they don't include it with Office 2003. MS Photo Editor is the "OLE Server Application" for images inside of Access. So, basic [more...]

Richard Rost on 5/24/2008: John, your SORT won't exclude anyone - just display the records in a different order. What you want are TWO criteria where you say, "include all of these ZIP codes AND all of these VIP customers." I show you how to do something like this in the next lesson (Queries) where you see how to include all customers from NY and all Active customers. Same concept.

Meena�Goel on 6/24/2008: Hi, My PCResale.Net Customer dbs are read only? I got them from the student db files.

Richard Rost on 6/26/2008: If they're set to READ ONLY that's because I pulled them off the production CD. When you burn a CD, the files usually get set to read-only because you can't write back to a CD-ROM. Anyhow, all you have to do is right-click on the file and go to PROPERTIES. Look for the READ-ONLY attribute and check the box off.

Meena on 6/26/2008: Thanks, your courses are great! The specified process worked after I extracted the files. Thank you!

�Kyle on 7/9/2008: Richard, Do you know how I would do a report getting strickly email addresses (with commas after each one) and then export them to a file (like csv file) so that the secratary can cut and past to send many emails at once (like on microsoft outlook). Thanks!

Richard Rost on 7/22/2008: Kyle, at your stage of knowledge (Access 102) I would suggest just copying and pasting your list of email addresses from Access into a text editor like NOTEPAD. Then you could select them in groups of 20 or 30, copy and paste them right into Outlook. Yes, it's possible to come up with a fancier solution, but that would involve some programming.

Add Your Questions or Comments