Microsoft Office Access 2003  for PC
Problem for Microsoft Office Access 2003 (077-02871) for PC

Eager To Learning MS Access




By bpal on Dec 30, 2007

" "
I am interested to learn MS Access 2003 and wnat to make Programme on MS Access

Same Problem

May 30, 2008

-   how to use MS Access to manipulate data in Excel worksheets to get refined data/tables effectively-   Guest

May 27, 2008

-   i don't have any basic knowledge of ms access-   Guest

Dec 31, 2007

-   Sir,
I want to convert numbers to word text in access-   Guest

Dec 31, 2007

-   about if condition for multple tex boxes-   Guest

Best Solution

posted on Jan 06, 2008
Very Helpful)

daverh

Rank: Wiz 
Rating: 83%, 86 votes
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.

Was this helpful?
Yes
No

Solution #2

posted on Dec 31, 2007
Very Helpful)

1PyroTech

Rank: Master 
Rating: 81%, 25 votes
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:

  • Third party online tutorials are often quite good. But often the depth knowledge like VBA will turn into a 'tips and tricks' rather than the foundation needed.
  • Get some of the multimedia learning, all it takes is a few 20 minute segments. Titles like Mastering Access 2003 by Magic Media, includes VBA.
Learning some of these applications can be very daunting. It is estimated that your typical user will use only around 10% of the programs capabilities. And they keep adding capabilities! Anyway start easy and work your way up to the complexity you want.
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!
Ted

Was this helpful?
Yes
No

Solution #3

posted on Nov 11, 2008
Not Rated)

dadim11

Rank: Apprentice 
Rating: 0%, 0 votes
How to make simple program for school registration?


Was this helpful?
Yes
No

Solution #4

posted on Dec 31, 2007
Not Rated)

panji

Rank: Wiz 
Rating: 73%, 27 votes
Was this helpful?
Yes
No

Popular Solutions for Microsoft Office Access 2003


Questions and Unsolved Problems for Microsoft Office Access 2003


Do you recommend Microsoft Office Access 2003 (077-02871) for PC?
Answer

Answer
Hey everyone. Can anyone help me come up with a script that will allow me to import a text file... (More)

Answer
I am getting the message "Module not found" after deleting a form that I no longer use... (More)


Didn't find what you were looking for?

Describe your problem:

Select a Category:







Ask our Experts

 

Solve Your Problem Now!
Chat Live with an Expert
Chat Now
Browse popular Problems
More Common Problems
Most Common Problems for:
For Microsoft Office Access 2003 ...:

Top Business and Pro... Experts

Rank: Guru Guru  

Solutions: 1349
Member Since: July 2009

Experience: I have owned a computer networking sales and service company.

Ask Me
Find more Business and Pro... Experts

Top Computer & Laptop Repair

(877) 934-6198
Send your laptop to us and we will diagnose the...
A+ Rated Oceanside Computer Sales & Service, LLC

(952) 890-7770
Zkarlo.com provides discount and used laptop parts...
Zkarlo.com


       
Solve Your Problem Now!
Chat Live with an Expert
Chat Now

X
Continue
When the original poster rates a solution that was given to his own problem, that rating is locked!
X

Are you sure the solution content is Inappropriate?
   
Tech buddies can communicate directly to answer questions. Become a Tech Buddy and have direct access to your favorite expert for FREE!
Insert Link
Insert Image
Insert You-Tube clip
Insert List
Insert List
Spell Check

What is this?



Select