Ms access I want to know basic knowledge of ms access

In order to use MS Access or any other SQL database you need to learn the SQL language -- or at least have a basic understanding of it..

You might try the "Compact and Repair" database option first before working on the database. Click on the "Office Button", then click on "Manage", then select "Compact and Repair Database". The usage dialog from there is straightforward. One that'srun, try opening the database again and opening the table as well.

SLA consultants in India. The training program is intelligently designed by industry experts to provide hands on experience and in-depth knowledge to the participant regarding MA Access database and Visual Basic for application programming. The training will use real time practical sessions and live projects and assignments to offer you a better understanding of both the tools. https://www.slaconsultantsindia.com/vba-macros-programming.aspx

Microsoft Access uses the Jet Engine. In VB 6, you can create a data connection using ODBC or OLE DB. Here is an example of OLE DB:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\YourAccessDB.mdb;User Id=;Password=;" Good luck

Crystal Reports comes bundles with VB6 and is a good choice fro reports. Regards -- Joe

you need to study the basics of database programming. take short courses for database programming.

Read the MSDN articles on the MS Access in question, paying attention to the version of Visual Basic recommended also.  Not a lot to do with Yahoo! 4D Soft Scroll Mice, is it!?

I do not know the pogramme in MS access I know the simple course of MS Access.Please kindly send me full verson of MS Access programme course in my mail Id
[email protected]

log on to e-panoroma...

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