-
Can I use my Access 97 database in Access 2000?
A. The first time you open an Access 97 database in Access 2000, you
will be given the opportunity to convert the database from Access 97
to Access 2000. Here are some thoughts to help you decide which route
to take:
-
If you will be using the database in Access 2000 from now on, convert.
-
If you will be sharing this database with someone using Access 97
and you only need to change data and do not need to change the design
of any database objects, you don't need to convert the database.
-
If you convert to Access 2000, you can still save as Access 97.
However if you do and you are using features available in Access
2000 and not Access 97, you may lose data.
-
I want to save my Access database to a floppy disk so that I have a
backup copy but I can't find Save As on the File menu. Where is it?
A. Save As does not exist in Access 97/2000. In order to save a backup
copy to a floppy (or any other drive or folder), use either Windows
Explorer or My Computer to copy the file as you would any other file.
-
How can I locate records with blanks in a field?
A. When you sort a Table by a field that may contain blanks, all of
the records with blanks in that field will be together. If you prefer,
you can use the Find feature.
-
STEPS:
-
Step 1: Click in the field in question.
-
Step 2: Click on the Find button on the toolbar. It is the one with
binoculars.
-
Step 3: In the "Find what" window, type Is Null.
-
Step 4: Be sure that Whole Field is selected in the "Match" window.
-
Step 5: Each time you click on the Find Next button, Access will
stop at each record with a blank in that field.
-
What the purpose of having a field indexed?
A. An indexed field is similar to the index of a book. You will be able
to retrieve information more efficiently if your search field is an
indexed field. Therefore, you should index any fields that you will
be using regularly in searches.
-
Last week I deleted a record with an ID number of 15. Access won't let
me reenter 15 as the ID number. How can I get number 15 back?
A. My guess is that your field called ID is an autonumber type field.
You cannot get back or reuse an ID number that was defined as an autonumber
type of field.
|