Hi i'm starting to learn VB 6 in my campus, but i still don't undestand how to create database using Access or Excell.

Anybody have a step by step tutorial for this? Just for simple progaming for showing name, age, etc.  

If you open access, you have to enter a db name before you can create tables (that creates the database)... then there's a create table in design view, you just enter the field names and type (default text)

then you save the table, open it, and enter data...

in excell, you just enter data, but put a field header at the top (if you want)... you could save it as a database I believe... but that's just "Save As" and altering the file type.

But since you added "VB" to this... I'm confused, as to create a database in VB doesn't require either of the other two programs...

____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

Yes i know with just using excel i can show it. But i want to use excell as my database, usually access is used.

And for access i also don;t know the steps, could you describe it or show me the code? Thx

The steps for access were listed:
Open Access
New DAtabase
Create Table design view
Enter names for fields & field type
Save table
Open table
Enter info


____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

hi hopenk,
I think there is some confusion here. Access is a Database, Excell is NOT - it is a Spreadsheet application. Database Design is a VAST subject which really cannot be answered in a simple forum post. I would suggest that the first thing you need to understand is exactly what a database is, and how it works. If you open MS Access and click on "Help", then look in "Contents", you will find a section headed "Getting Started". This will give you a good understanding of the basics, as will the rest of the Help sections that are provided with Access.



____________________________
multi-tasking - the ability to hang more than one app. at the same time.

guys, I think what Hopenk meant is how to use excel to handle the database in VB application... to store, retrieve, and display... with the database in excel format instead of access.