| Jeff Boyce 2005-11-30, 7:24 am |
| Nancy
From my perspective, Excel provides strong "calculator" functions, as you
describe it, while Access, as a relational database, offers strong database
functionality. These represent two different tools.
What about "Database Management" (whatever you mean by that) is it that
Excel isn't doing for you -- a way of checking to see if you need to migrate
to Access?
What kinds of "calculations" are you anticipating needing to do -- a way of
checking if Access built-in functions or additional coding could do what you
are trying to do (which isn't clear yet).
Have you considered keeping your data in Access, but exporting data sets to
Excel for analysis (?i.e., "calculator functions")?
Please bear in mind that Access is NOT a "big spreadsheet". To get the best
use of the capabilities Access offers, you may need to review your data
design and normalize it.
JOPO (Just one person's opinion)
Jeff Boyce
<Office/Access MVP>
"Nancy" <nancyr@markdavidny.com> wrote in message
news:1133300291.926487.35030@g44g2000cwa.googlegroups.com...
> I work in a Real Estate Brokerage Firm. We need to transfer our
> current excel based spreadsheet into Access. Our goal is to utilize
> Access for superior Database Management while maintaining Excel's
> calculator functions. Is that feasible and if so, how?
> Also can this be done in an HTML environment? Thanks.
>
|