Cancel Submit. The huge trap to avoid is to create fields with names that describe an inspection point. These are data values that belong in tables, not in names of fields. You should be able to add different inspections and categories without editing any tables, forms, queries, or reports. When I have created solutions like this in the past, I basically have one table with only a few fields that contains all inspection detail results. This table would have fields like: tblInspectionDetailResults idrIDRDID autonumber primary key idrInEID field that links to a table of inspection events like a particular worksite on a particular day idrInsID field that links to what specifically was inspected like an entrance idrScore a numeric field that stores 0 - 10 maybe to rate the item idrComments field to store comments You could add more fields to store if you need to do a followup or whatever.
As you see, you will need to have an Inspection Events table that has a record for each worksite visit. Another table would store the "what was inspected" list. Think of an inspection like a survey. It is quite a download, but I like what I have seen and used so far. Thanks for the link I have an MS Access database I used while performing 3rd party inspections. It may be something you can use with some modification. Red Flag This Post Please let us know here why this post is inappropriate.
Learn methods and guidelines for using stereolithography SLA 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now. This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. Close Box. Log In Come Join Us! Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Looking for Incoming Inspection Database Looking for Incoming Inspection Database I am looking for a database that I can record and track incoming material inspection reports and supplier non-conformances. Create a project tracking database to track multiple projects, including time-sensitive deliverables, owners, and budgets, using this popular Access template.
Navigate by projects, tasks, and employees, keep an eye on costs, priorities, and status. Create a personal account transaction database to track income and payments across domestic categories from groceries to healthcare to charitable donations using this Access template. Search and view income and expenses by category and view tax reports. A field for memos helps you remember handy details for every transaction. Create a customer service database to manage multiple issues tracking assignments, priority, status, customer, and resolution using this Access template.
Navigate by open cases using multiple criteria, create and manage knowledge base articles, and manage customer details while producing useful reports such as Open Cases by Assigned To and Overdue Cases. Create and maintain an up-to-the-minute database of your business contacts and call history using this simple yet effective Access template. In addition to maintaining details on company, job title, and contact information, you can navigate and search by contacts, calls by contact or subject, as well as add contacts from Outlook.
Assign and track status of customer calls using this dynamic Access template. Navigate by customers, employees, and calls, as well as track by priority, status, and assignment. And you can generate useful reports in real time such as Open Calls by Assigned To that can give you the extra edge you need when things get busy.
Create and manage a home inventory database to retain and manage vital data on your personal belongings using this Access template. Search by item name, category, or location, while retaining important details for insurance purposes, such as condition, acquired date, and value. Attach photos of items to each entry to help ensure reimbursement in the case of loss or damage.
Manage your organization's client cases and projects, including billing, invoices and balance sheets using this robust Project time and billing Access template. Fields for owner, workcode, and status help you track progress, time worked, and costs while you generate instant reports on everything from Billing by Workcode to Employee Time. Manage your accounting books with this business account ledger template.
This database can track income and expenses by category and generate financial reports. Manage your entire workforce's hours worked using this robust time card Access database template. Fields for workcode and description help you keep track of costs and work areas while you generate instant reports on everything from Billable hours by Employee to Billable Hours by Project. Manage your project's open issues with this popular Access database template. Maintain details about issues and issue assignments, as well as track opened dates and deadlines.
Fields for status, category, and priority help keep things moving forward and powerful navigation allows you to instantly get a handle on what's happening and continuously up your game. Create and manage a vehicle maintenance database for your organization's fleet, tracking servicing, shops, dates, and mileage, as well as costs, using this popular Access template. You can create reports on estimates of future expenses on each vehicle and for the entire fleet and attach invoices and image files to each record, documenting vehicle appearance and condition.
Manage all your organization's fundraising campaigns, maintaining current data on contributors, donations, events, and tasks across multiple campaigns using this robust Access database template. Track fundraising goals, generate reports on ongoing campaigns, and maintain details on contributors while instantly being able to see the extent of unpaid pledges, and view pending tasks as well as upcoming events.
Create and maintain a lending library database to track all assets, instantly know who has what checked out, as well as maintain important asset details such as title, owner, and type.
0コメント