Recent content by doxiepup

Golom: Thank you so much! Of COURSE you are right. That makes perfect sense now. I'm trying to learn Access using the book Learning Microsoft Access 2002 from DDC Publishing. There were two different places in the book that indicated what was to be typed in the criteria row (incorrectly)...

Thanks for reading this question. I am using Access 2002. I have a table with customer addresses which includes a STATE field in which the entries are two letter abbreviations. In running a query I want to be able to supply a state abbreviation or just hit ENTER to see all the states. I've...

Perhaps the AutoText is in a different font that is not suppported by your printer? Just a thought. You might try making sure the AutoText is formatted the same as some other text that DOES print.

1) In my area (Pittsburgh PA)more and more businesses are requiring MOS before hiring an employee. 2) You receive a printed certificate in the mail about 2 weeks after passing an exam. 3) The certificate states that you are a Microsoft Office Specialist in (for example) Excel 2002. That...

also DSUM can be used to add a certain column based on criteria in another column.

SimonDavies: Thank you for your helpful post. Unfortunately, not all teachers follow your excellent techniques. I'll bet you have lots of success, and I also imagine I would enjoy anything you taught.

Could you please explain what you mean by "distinct"? =count(range) will count numbers =counta(range) will count words

ras 1040: The tests vary. Some tests have questions which might say "without using the menu,...." or "using the menu,..." I've even taken exams in which certain icons were disabled. The bottom line is, know more than one way to do everything! If the question doesn't specify a certain...

HBO5 I also teach at the local community college. Here nstructors must hold a Masters degree. As far as which track to concentrate on, what version of Office are you currently using? If you are familiar with one in particular I would go with that one. However, another consideration is the...

Chrismenzies: You can take any exam at any time. I would suggest, though, to first thoroughly acquaint yourself with the listed objectives at this site before taking any exam! http://www.microsoft.com/learning/mcp/officespecialist/requirements.asp They ARE timed, so you don't have much...

Chrismenzies: I have taken several of the Microsoft Office Specialist certification exams, and teach all four applications at a local community college. There are lots of experts here that can help you, plus loads of info in the FAQs if you have a specific question

Prinand: I too have experienced this problem from time to time. Although I don't know WHY it happens, I have discovered that if I click PRINT PREVIEW, then cancel the print preview, all is normal again.

daveask: Highlight the cells that have the format you want. Then click on the icon that looks like a paint brush. Then click on the top left corner of the range (group of cells) where you want the new formatting to be.

daveask: Have you tried using FORMAT PAINTER to copy just the formats?

Mbf2: Try moving your mouse pointer to just above the word FILE. It shoud change shape (to black arrows pointing up/down and left/right). When the mouse looks like this, you should be able to drag the menu around.