Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Many comments on this one if possible.
The place I work for is a large corporation; the licensing of the software has to be spot on. They are too tight to pay for Microsoft access on every machine and because of its synchronisation and replication system they choose to use Lotus Notes domino for communication and database purposes. I don't know Lotus Script. They use excel for on sheet data manipulation. Word is also licensed on the machines. I have been thinking that if I would like to come up to a solution to the problems in my area I need an Access database. I cannot have money to do this though. Could I set up excel as a database with combo boxes for selection and entry on one sheet and predefined cells for data on another. I could use word for reporting. I could write sql statements to run queries if the data was in a regular order. Am I right in what I am thinking? |