A relational database (Access) and spreadsheet (Excel) differs in the way that information can be connected to one another. I believe that Access is an easier way to manage order information compared to Excel.
In Access, "keys" are like the titles/headings of the various data. "Queries" are similar macros in that you can ask the database for a particular piece of data. "Database Relationships" connects information between tables that include a the same label. Forms can be created so that an order can be entered in a more efficient way.
We use queries and forms in Access to make data entry efficient and hopefully effective.
A relational database could be useful for my work in the Career Development Office because there are many students who make multiple times a year for different reasons. To keep track of all of the traffic and student information, a relational database would aid in the input of all of the student's information. Currently, their information is entered into Excel which can be very tedious. Using Access would help tremendously.
No comments:
Post a Comment