| What is the
difference between a form and a report?
|
In Access, a form can be used to display data, as well as enter it. A
report, however, can only be used to display data.
|
| Why is my calculated
control blank?
|
When you have a calculation that contains a Null value, the result of the
calculation will also be Null. A Null value is not the same as zero; instead,
it can be thought of as an unknown value. The result of adding an unknown
value to a number is unknown. When you have fields that contain Null values,
you can create an expression that converts the Nulls to zero. You might
do this if you want the records containing Null values to be included in
an aggregate (totals) calculation, or if you want to prevent an expression
from resulting in a Null value when a field that is referenced in the expression
contains Nulls. To convert Null values to zero, use the Nz() function.
For example: Nz([Subtotal])+Nz([Freight])
|
| When you open a
table, a query, a form, or a report, you may see any of the following error
values: |
#Error
#Num!
#Name?
#Div/0!
#Deleted
#Locked
The #Error error value means that Microsoft Access cannot
evaluate an expression. For example, you may have supplied incorrect or
too few arguments for an aggregate (totals) function, you may have used
a parameter query as the domain for an aggregate function, or you may
have made a circular reference in the expression.
The #Num! error value means that the value in the field
is too large (either positively or negatively) to be stored in the field,
based on the field's DataType or FieldSize property setting.
The #Name? error value means that the name that you entered
as the source of the value in the field is not valid. You may have misspelled
the name, you may have omitted the equal sign (=) before the expression,
or the source itself may have been deleted.
The #Div/0! error value means that you are trying to
divide a number by zero (0), either directly in an expression (for example,
8/0), or by using a value from a field whose value is zero.
The #Deleted error value means that the record being
referred to has been deleted.
The #Locked error value can be caused by any of the following
situations:
a. The record has been locked by another user and Microsoft Access cannot
read the data.
b. There are two or more instances of Microsoft Access running on the
same computer. Microsoft Access treats each open copy of the database
as a separate user.
c. Your code has opened a recordset and has a lock on a record.
|
| Can I run a
Microsoft Access 2000 Database in earlier versions?
|
The database file format in Microsoft Access 2000 is different from the
file format in earlier versions. However Access 2003 and Access XP generally
create a new file in Access 2000 format automatically to ensure cross-version
compatibility.
|
| Where can I
find Microsoft Access?
|
There are two ways run Access XP. One way is through the NAL (Novell Application
Launcher) under the Spreadsheet and Database folder. It can also be found
under the Start Menu by clicking on Programs, Microsoft Office, Microsoft
Access.
|
| I click on
the Access icon from the Novell Application Launcher (NAL) and nothing
happens, what's wrong?
|
It’s possible that this is your first time launching Access, so
you may want to right click on the icon and choose verify to install the
program.
|
| Is Access available
for home use?
|
Yes it is. Faculty, staff and administrators can download the Microsoft
Office suite (which includes Access) from the My Hofstra Portal. Faculty,
staff and administrators can also borrow a copy of the application from
the Help Desk by bringing their Hofstra ID card to 108 McEwen Hall.
|
| How do I remove
duplicate records from a table?
|
A fast way to remove duplicate records from a small table is to select
the table in the Database window, click Copy on the Edit menu, and then
click Paste on the Edit menu. In the Paste Table As dialog box, type the
name of the table created in Step 1 in the Table Name box, and select
the Append Data To Existing Table button. When you click OK, the records
will be appended from the original table, without the duplicate records.
|
