Excel look and function as access?

[hoachen]

Hi All experts out there,
Is there a way to use excel to create the function as ms access? The only option i have is use excel and i need a master sheet to update one table and will reflex other sheet. If i just using excel. I have to update separate sheet even same info. Your advice will be valuable and am appreciate

[noboffinme]

Hi hoachen,

What Access function are you talking about?

An Access table does much the same thing as an Excel Spreadsheet, hold information.

The difference with Access is that you can view your Table data using an Access Form.

Can you clarify what exactly Access can do that you need & can't be done by Excel for your purposes?