Excel or Access

Hello all readers

 

I have developed a pricing spreadsheet on Excel. Although I've probably used overcomplicated formulae, it produces what I need to, so I'm relatively happy with it. The trouble is that the entry onto the spreadsheet isn't the most user friendly.

 

I was hoping to convert this into an Access Database, but basically want to maintain all the Excel formulae. Is the transition from Excel to Access that easy.

 

Basicaly, I want all the benefits of Excel's formulae, but with the benefits of the displays in Access and ease of entry that is Access. I want people to be able to enter on tables on Access but then calculations get done to the entries and calculated results shown on Access.

 

Am I being too greedy?

 

 

Comments
There are 8 comments. Login or register to view them.

Access

ShirleyM |
ShirleyM's picture

Sounds good!

jasonowsky |

Access programming

ShirleyM |
ShirleyM's picture

Formulae in Access

RichardWhight |
RichardWhight's picture

Staying with Excel

Andrew Burnett |
Andrew Burnett's picture

Why change

DerekChaplin |
DerekChaplin's picture

Access & Excel

Ashraf |

Variation on a theme

paulwakefield1 |