Question about Microsoft Office Access 2003 (077-02871) for PC
I am interested to learn MS Access 2003 and wnat to make Programme on MS Access
How to make simple program for school registration?
Posted on Nov 11, 2008
Converting numbers to text:
I assume you mean converting the contents of a numeric database field to printable text. Access will sometimes do this automatically if you use the numeric value in a context where a string is required - e.g. in an assignment to a string variable. When required, you can use the format() or str() functions. If you need to insert data from a numeric field into a report, use the Print method - look it up in the Access Help.
Personally, I have never found the MS documentation to be that wonderful - but then one size does not suit all :) different people use different teaching methods, even if the medium is the same. If you find you can't get along with one set of training materials - e.g. you find yourself constantly confused or not understanding what's going on - try a different author's work.
Posted on Jan 06, 2008
The easiest and fastest way to learn the basics of any of the main office programs is with multimedia tutorials. Ranging 5-10 times faster than text. More can be learned in this way in a shorter time.
In regards to VBA, if you only want to work with macros and scripts within an application, a minimal knowlege is all that is necessary. If you are wanting to use VBA across applications, you will need a little more depth of knowlege (at least in my case) is needed. May I suggest Microsoft's 'inside out' series of books. It looks intimidating but you only need the section you are studying.
There is something special about getting tutorials and learning information from the actual program manufacturer. They are the authority and free.
Okay, my suggestion is to first go to Microsofts website and view the tutorials available for your application: MS Office tutorials
Then, if you find your thirst for knowledge unquenched:
For the other users that have similiar problems, the real answer is to learn the above. But to convert numbers to words you need to redefine the field as text, and enter numbers.
And if you are setting up a search criteria for multiple text boxes using IF condition, it depends on what you are comparing. If you are comparing to a set quantity it would look something like this: IF field/text box = "Fixya" THEN performed action. Endif. If you are comparing two or more text boxes to each other it may look something like this: IF field/textboxA = fieldtextboxB or fieldtextboxC THEN action Else action. Endif
Hope this helps!
Posted on Dec 31, 2007
Tips for a great answer:
Sep 24, 2012 | Microsoft Access 2003 for PC
on Sep 09, 2010 | Microsoft Office Professional 2007 Full...
Jul 20, 2011 | Microsoft Office Professional 2007 Full...
Oct 26, 2010 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...
Jan 13, 2009 | Business & Productivity Software
Nov 19, 2008 | Microsoft Business & Productivity Software
Mar 09, 2008 | Business & Productivity Software
Feb 07, 2008 | Microsoft Office Professional 2007 Full...
Oct 15, 2012 | Microsoft Office Access 2003 (077-02871)...
181 people viewed this question
Usually answered in minutes!
Level 3 Expert
Level 3 Expert
Level 3 Expert
Step 2: Please assign your manual to a product: