Desktop

Ask something
Discussion Locked

Excel as a database

0 helpful
2 replies

by stevehill

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
My client is using MS Excel as a database at multiple locations. What is the best alternative to store and pass data between locations, besides Access? What is the easiest way to teach non-technical users?

2 replies

by tbragsda

For small DBs, and users with limited knowledge, Access is great. If you have a good reason for not useing it, let me know.

by l_lk

For more easy to manage the data from diff. files, you need to ensure all "header row" of those files are same, then you can use the function icon from the toolsbar to sum up the data(only for num.)you can choose the function key : shortcut icon (D)-> (N) and then follow the instruction of the criteria request, you can get the summary for each items
Or, you can build up a database, 1st step, you need input the "header row", and then choose from toolsbar, (D)->(O), it also can help you filter the table and speed get data which you want.
(because I only have Chinese version excel, so I don't know the English desciption of each icon, but I know the shortcut name is same)
If there have diff. feature of files, you can use hyperlink to link up all files, and use some formula to get the data, such as "vlookup","sumif", "index", "match", "if". you can read the explain from function icon "fx" to know how to use it.
Excel is not provide for technician to use, everybody can use it after readthe "help" function icon.

This discussion is closed to new replies.