Developing A Design For A Fleet Truck Maintenance Database Creating an accurate database design is a critical aspect of developing a functional and effective fleet truck maintenance database. It is important to create tables that will store all of the data required to track expenses, budget and make projections regarding fleet maintenance. There are several steps involved, depending upon whether you are automating a manual system or building the maintenance database from scratch. Begin by analyzing the answers you are seeking and report information you desire from the database.Analyze and plan for the types of information you require, such as expense per vehicle, expense per driver,Cheap Ray Ban Wayfarer, expense per repair type, expense per month or quarter. Create report formats that provide the information you need for the fleet maintenance decisions you anticipate making. Create field names for each reporting criteria that you identify.Create your database tables first by categorizing and consolidating the field names you established into separate tables. Most database applications follow the "File," "New," "Table" procedure to create tables to define the database structure. Create separate tables for vehicles,Ray Ban Outlet, vendors,http://verysunglasses.weebly.com/, drivers and repair types. Create a common field that is shared between the tables such as "vehicle ID" or "VIN #" to relate the tables together. Create filters and sort options for key fields, such as vehicle, driver, mileage or repair type, so that you can query, sort and create reports as needed.Use the database application's form wizard to create data entry forms based upon the tables that you created. Create forms manually to automate a paper- or spreadsheet-based system that has worked well in the past.Form creation should take priority over table creation only when automating or upgrading an existing system with existing data. In this case, structure tables to record the data stored in your data forms.Create and test the reports you designed. Add additional supporting fields to your tables for advanced calculations and detailed information in the form of notes and comments as needed. Create search key fields and define sort parameters so that you can query your maintenance database to get the answers you need.