Business information for Fly Guys about Excel Spreadsheet and Access Assignment

Business information for wing Guys about Excel Spreadsheet and Access Database - Assignment ExampleIn contrast, the Excel spreadsheets would keep displaying messages about a locked file and this might intimidate the passengers in addition to contributing to time wastage. Thus, Access database application is a better alternative as pertains to the support of the booking operations. Second, Access database uses structured query languages (SQL) to manipulate records. An fifty-fifty more striking aspect of this future is that the end-user can tailor the queries to suit the business needs. For example, it is possible generating reports base on criteria such as passengers involved in half journeys, passengers involved in full journeys and passengers who argon most loyal to fly Guys. On the other hand, Excel spreadsheets lack such fascinating features. unstated in this is the point that a business which embraces Excel as an information management tool is possible to be restricted with regards to generating reports that can support business goals. So, MS Access database is better placed to get wind the custom report generation needs at Fly Guys. Another reason why Fly Guys would need to focus on MS Access to address the custom report needs is its scalability and flexibility. In brief, Access can scale well and communicate seamlessly with nearly all other 21st vitamin C relational databases via open database connectivity (ODBC) connections. The only prerequisite for this capability is for the involved database administrator to have a total knowledge of the Fly Guys-owned MS Access database file. As Beskeen (2010) puts it, MS Access is a better filling when it comes to information storage. In general, the applications capabilities come in handy when a need arises to neckcloth information for a more elaborated time. This aspect suits the operation at Fly Guys because the records handled will inevitably rise.