Quickly indent paragraphs and lists in Word 2000!
Although you can use the Paragraph dialog box or the Ruler,
using the Formatting toolbar's Increase Indent or Decrease
Indent buttons may be the quickest method to indent paragraphs
or lists.
Clicking the Increase Indent or Decrease Indent buttons
increases or decreases the indent from the left margin by one
tab stop. But this function isn't limited to the default
half-inch tab stops. To change the size of the indent used by
the Increase Indent and Decrease Indent buttons, simply change
the tab stops.
Word 2002 adds a drag-and-drop method for indenting numbered
or bulleted lists. To try this method, position your cursor
over a bullet or number in the list, and click and drag the
mouse. When you do, a vertical dotted line that extends the
length of the document window to the Ruler will appear. Drag
the mouse to the right or left until the dotted line reaches
the desired position on the Ruler. The entire list will be
indented to that position.
Hyperlink To A Specific Cell in Excel 2000!
Did you know that you can create a hyperlink from a Web page
on your intranet or the Internet to a particular sheet, range,
and cell in an Excel workbook? For example:
a href="http://yourwebserver/hyperlinktesting.xls#Sheet1!A1">Link
Test
This hyperlink will open your file called Hyperlinktesting.xls
and then select cell A1 on Sheet1.
Using this kind of linking, you can specify exactly where your
user will enter the workbook. Users' views of the workbook
won't be bound by the state at the last save.
This can be helpful if you insert the link to a Web page that
asks the user to enter data in a particular cell or area of a
sheet. You can select the cell for them when they click the
link.
Access 2000 Objects!
There are seven types of objects in an Access database. Here
are explanations in simple terms to help you to understand the
purpose of the objects.
Tables
Tables store the data. These are the most important objects in
your database. If these are not designed properly, then there
is no point in continuing to design other objects. Access
tables are very much like Excel worksheets. In Excel, however,
you'll have difficulty storing a client's name only once, and
having many invoices for that client. Instead, every client's
record would need to contain the clients name, address, etc.
In Access, you'd have one client record and many invoice
records that are related to that client. The Invoices table
would contain a field that is linked (related) to the Client
table.
Queries
Queries ask questions of your data. When you run a query,
Access provides you with a temporary view of the data that you
have requested. You can build many queries without increasing
the size of your database because only the criteria is saved,
not the data the data that is produced when the query is run.
In our example, you may want to retrieve the client's name and
address from the Client table, and the sum of that client's
invoices.
Forms
Forms are yet another way to view your data, usually one
record at a time. They are also created to allow an organized
manner of entering new data, and changing or deleting existing
data. Many people confuse forms with reports, because a form
used to be something we printed. You can create subforms too.
Again, in our example, we could have a form with the client's
information and a subform below it with a list of that
client's invoices. An invoices form may have a subform that
shows details of the items purchased under that invoice. The
Form Wizard is a great tool for creating forms. If you don't
like what is produced, you can always change it. It's very
helpful in learning to understand the design view of a form.
Reports
Reports are pretty much anything you want to print from your
database, whether it is a single record or an entire summary.
You may want to print individual invoices, end-of-month
statements for your clients, or summary sales reports. The
Report Wizard is a great tool for creating reports, which
includes labels. If you don't like what is produced, you can
always change it. It's very helpful in learning to understand
the design view of a form. Many of the built-in form designs
contain a lot of graphic elements, such as lines, that can be
removed.
Pages
These are Data Access Pages. You need them only if you're
putting your database on the web or an intranet. They are very
similar to Forms.
Macro
Access has many built-in macros. If you believe that you need
to know VBA for the simplest macro, then you may want to check
out all of the built-in macros first. Practically all you need
to do is pick a macro, tell it what you're using it on, and
sometimes give a file name or other information.
|
 |
