I have to develop a database for a small agent (for 5-10 users). I am
thinking to use MS Access and VB.net. Could you please tell me how many
records (max) an Access database can handle. Should I choose MS Access,  MS
SQL  or mySQL (and why?)

Is there a keyboard shortcut to move the cursor from any cell in an excel
workbook up to the formula bar?

Newbie question - sorry.  I have an Access 2000 database on an old computer
and I want to transfer the database and all the records to a new computer.  I
don't see an easy way to do this.  Would appreciate any guidance.
Thanks.

I am a beginner with some questions about best practices re: data
validation.
Currently, I am handling all absolutely required information validation at
the Table design level for certain "must-have" fields, using Is Not Null,

I have a field  that i imput a starting number and would like the next field
to be the number I input plus 1 what is the expression I need to use
Thank you

Hi - I am comfortable using Access to run basic queries, but have had a lot of
trouble getting equivalent functionality in Access to match what I do every
day in Excel.  Here is the scenario:
I have a dataset with the following attributes:

I have two tables - both contain information about people, with initials,
surname, address etc.
First - I want to set up a query to show ALL the people who are on the
second table who do NOT also appear on the first table (with all the other

I have a couple of issues.  
The first is I need to know the record count of a record set.  I looked in
the help and found this
"RecordCount Property

Hello,
I hope somone can help me solve this problem!
I need to fill an array with Data from a Report!
For i = 1 To Report_UpdateReport.Count

I want to generate a form, to be used as a data entry tool, to enter the
company/client information without having to enter through each table.  When
I created the form and chose the tables for the query.  I get an error.  When
I check the relationships I now have duplicate ...

I have a table of 66 records.  I have a form letter which I have to send to
only 20 of those records.  How do I select just the 20 records I need to
merge?

I have a table that records each person's customerID, name, address,
donation...How do I set up a query or form that when I type in the customerID
or the person's name, all other information will show up? Thanks

i have a access application
i can minimze it
but
how i can fix it that the show symbol cannot be closed, means that the

I have created a two table MS Access 2003 database.
One table contains transaction data while the other table contains ledger
account information.
While entering a transaction into a form, I'd like to be able to select the

I downloaded the above and it is on my desktop but when I clidk on it, it
doesn't do anything.  How do I install it?