Hello and happy Monday
I'm posting a question as part of an assignment for an Access class I'm enrolled in this semester. While the reason for this post may be for an assignment, I do have a legitimate question that I'm interested in finding an answer for. I know that Access often hold an edge over Excel because you can store a lot more data with Access in a highly-organized format. Part of this advantage is due to the fact that Access databases can consist of multiple tables, each linked to each other in various relationships. But what about simple one-table databases?
I'm taking an inventory of company computers at work this week and I've already organized all of my data into an Excel spreadsheet. The data displays nicely from an Excel spreadsheet and is sufficiently organized, but I was wondering what other advantages an Access database might hold over my simple Excel spreadsheet. I don't think I'd be able to take advantage of multiple tables or relationships, given the simplicity and straightforward nature of the data, but I was wondering what kinds of data-lookup, sorting, and form-entry features an Access database would enable.
I know this is probably a very easy question, but I'm interested in hearing opinions.
Thanks, and enjoy your week!