Dell Alienware Aurora - R2 Bedienungsanleitung PDF herunterladen (Seite 12)

(News from the Northwest - cont’d from page 10)

them. This is also an ideal avenue for the team to talk

about issues that are of interest to the Access com-

munity. You’ll learn about the people and some of the

factors that are helping to shape the future of Access.

Whether you’re a seasoned developer or just learn-

ing about Access, you’ll nd invaluable information

and techniques. From creating a database template

to getting help when you need it, The Access Blog

covers the gamut.

http://blogs.msdn.com/access/default.aspx

A couple of good sites to search for information

and programming assistance are www.mvps.org and

Ofce Developer Center on MSDN.

And, we’ve been mentioning the newsgroups. You

can search and drill through thousands of threads.

Check out http://www.microsoft.com/ofce/commu-

nity/en-us/FlyoutOverview.mspx for a comprehensive

display topics. You may also nd what you are look-

ing for by using http://groups.google.com or try www.

google.com/microsoft.html for Microsoft related pages

or by setting multiple search criteria at www.google.

com/advanced_search?hl=en.

Utter Access Discussion Forum

Touted as the number one Access community fo-

rum! This may be a great place to get answers to your

questions. And, you’ll see several familiar names as

some of our members are prolic posters. Hey, there

are even photos from the MVP Summit, so check it

out! www.utteraccess.com/forums/index.php

A compilation of links to Access Resources

This site provides an impressive array of links to a

variety of resources for Access developers and users.

www.cbel.com/ms_access/

Dynamic Link Library Article by Mark Liron,

MVP

Learning more about DLL’s is in ongoing theme, so

you might want to bookmark or download this page.

www.updatexp.com/dynamic-link-library.html

Access Developer Portal MSDN

Database samples and tutorials provided by Ac-

cess MVP and other experts.

http://msdn2.microsoft.com/en-us/office/

aa905400.aspx

Database Issue Checker

Access MVP, Allen Browne offer tips and utilities

for casual users through expert developers. The Is-

sue Checker can be used during development or to

trouble shoot legacy les. Allen’s site provides a host

of other tips and resources, including a compilation

of reserved words. http://allenbrowne.com/AppIs-

sueChecker.html.

Referring to ranges of cells is one of the very ba-

sic skills necessary to effectively use Excel. As you

start to create ever-more-complex formulas, you may

wonder if there is a way to refer, in a range reference,

to a “stack” of cells on multiple worksheets, the same

as you can refer to rows or columns on the current

worksheet. For instance, the following formula is a

way to refer to all cells in column B:

=SUM(B:B)

Note that you don’t have to provide a starting or

ending row; you just have to provide the column

name. You can likewise do the same thing for row

references. The following refers to the range of all

cells in row 3:

=SUM(3:3)

The problem with referencing all the cells in a set

position across a range of worksheets is that there

is no unique “collection name” to apply to cells in

that position. For instance, rows have numbers and

columns have letters. “Stacks” of cells across work-

sheets don’t have a comparable name.

The only way, then, that you can refer to the same

cell across a range of worksheets is the rather ex-

plicit way that Microsoft dictates. For instance, the

following refers to the range at cell D5 across three

sheets:

=SUM(Sheet1:Sheet3!D5)

Understanding that sheets must be named in the

range, you can include an ever-expanding range by

simply making sure that you only add new worksheets

between the beginning and ending sheets specied

in your formula.

As an example, let’s assume that you have a

template for an invoice, and that your workbook

contains all the invoices you have created this year.

Further, each invoice has a total at cell F15. If you

want a summary worksheet that shows a total for all

invoices, all you need to do is make sure that your

rst invoice is the rst worksheet in your workbook,

that your invoice template is the second to last, and

that your summary worksheet is the last one in the

workbook. In this way, your formula could be some-

thing like:

=SUM(Inv01001:InvTemplate!F15)

Whenever you need to add a new invoice, simply

make sure it is added immediately before the invoice

template. Your invoices remain in order, and your

formula always returns the correct total.

Associates, Inc. Reprinted by permission.

Totaling Across

Worksheets

1 2 ... 7 8 9 10 11 12 13

Kommentare zu diesen Handbüchern

Keine Kommentare

Dell Alienware Aurora - R2 Bedienungsanleitung Seite 12

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für PC / Workstation Barebones Dell Alienware Aurora - R2