access verses excell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

what can access do that excell cant as far as formulas
also i deal with bill of materials alot of different bom's but they all use
allot of the simaler materials would access be somthing to use
 
tks93 said:
what can access do that excell cant as far as formulas
also i deal with bill of materials alot of different bom's but they
all use allot of the simaler materials would access be somthing to
use
Click to expand...

When you say 'formula' think code. Imagine if you could write your own
'formulas' for a moment. You can do just that with Microsoft Access. In
Excel, you are largely reliant on built-in formulas. However in Access you
can create your own.

Using Microsoft Access, you store data in 'tables' much like a spreadsheet.
However, a spreadsheet is a 'flat-file' database. When you use Microsoft
Access, you build spreadsheets (tables) that relate to eachother by creating
'relationships'--Microsoft Access is a 'relational database' programming
solutions. Using Microsoft Access it is entirely possible to build an entire
application.

Best regards,

Todd
 
Access is certainly the right tool for what you want! The learning curve
however is rather steep. If you need the database you describe up and
running soon, contact me at my email address below.
 
Back
Top