Question about Access

[Simon via AccessMonster.com]

Many questins about Microsaft Acess...

1st, I sthere a whay to put in the tables into the Microsoft Exsel
Spreadhseets?

2.) How many tables are in my Microsoft Access Database?

3.) Can I make a spreadsheet in Microsoft Access, as well as Microsoft Excel?


4.) When I want to put in the data in, how to I convert it over into Access?

5.) And, final, How many forms can go inside of a Microsoft Access Databases?


Thanks you,

Simon

 

[Guest]

Many questins about Microsaft Acess...

1st, I sthere a whay to put in the tables into the Microsoft Exsel
Spreadhseets?

See Help for TransferSpreadsheet or use File, Export to put Access data into
a spreadsheet

2.) How many tables are in my Microsoft Access Database?

As many as you create. There are some hidden system tables, but don't worry
about those for now.

3.) Can I make a spreadsheet in Microsoft Access, as well as Microsoft Excel?

No, Access is not a spreadsheet, it is a relational database. You can
create queries that will resemble speadsheets to some degree, but they don't
act the same way.

4.) When I want to put in the data in, how to I convert it over into Access?

Depends on where the data is coming from. Use File, Get External Data,
Import and follow the dialog from there.

5.) And, final, How many forms can go inside of a Microsoft Access Databases?

I don't know that there is a specific limit, but if you get anywhere near
filling up an mdb file with forms, you are doing something very wrong.

 

[Douglas J. Steele]

I don't know that there is a specific limit, but if you get anywhere near
filling up an mdb file with forms, you are doing something very wrong.

There's a limit of 37,268 objects in a database. You're right that
approaching that limit usually indicates something's wrong!

 

[Guest]

Thanks, Douglas. I thought there might be, but I was not aware what it could
be.