+ Reply to Thread
Results 1 to 2 of 2

Quality Control Audit Access Database

  1. #1
    Registered User
    Join Date
    03-04-2013
    Location
    Colorado
    MS-Off Ver
    Excel 2019
    Posts
    26

    Quality Control Audit Access Database

    I have an Excel Spreadsheet of data and I have a group of auditors I need to validate data on the spreadsheet. I want to load the Excel Spreadsheet into the database and make each data point something the auditor will need to check each item as accurate or inaccurate.

    There is a mixture of numbers, names, addresses, dollar figures and auditors and a category.

    Loan Number Data Point 1 Name Data Point 2 Address Data Point 3 Address Data Point 4 Dollar Figure Data Point 5 Date Data Point 6 Date Data Point 7 Dollar Data Point 8 Dollar Data Point 9 Name Data Point 10 Name Data Point 11 Dollar Data Point 12 Date Data Point 13 Dollar Data Point 14 Name Data Point 15 Date Assigned to? Name Category Numeric and Alpha

    I need each auditor to be able to access the Database and select loans assigned to them if possible as well as the category. They will work the loans and record their results for each data point by verifying accurate or in accurate. I prefer check boxes for each data point over drop down boxes. Several people will be using the database at one time. There should be a small notes section. 250 characters should be enough. After they work an account they can hit next and the next loan will appear to work.

    I will need to be able to pull a report to show results and outstanding items.

    Make sense?
    Last edited by brandonmcg; 01-07-2020 at 01:45 AM. Reason: title change

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Quality Control Audit Access Database

    Just to be clear, are you asking someone to make this for you, ir are you asking for advice as to the best way of going about building it?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Quality Control Chart from CSV File
    By frankcase in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-21-2017, 09:20 PM
  2. Quality Control Charts
    By nooredein in forum Excel General
    Replies: 19
    Last Post: 06-20-2014, 10:28 AM
  3. [SOLVED] problem with =COUNTIF((OFFSET(INDIRECT(CONCATENATE(("'Quality Audit Criteria'!$f$",MATCH(
    By nadiac2402 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-13-2014, 08:22 AM
  4. Replies: 9
    Last Post: 02-12-2011, 10:04 PM
  5. Using VBA to control Duplex, Color Mode and Print Quality
    By mkvassh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2007, 12:50 PM
  6. quality control
    By himura137 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-28-2007, 11:28 AM
  7. [SOLVED] HOW DO I USE EXCEL FOR QUALITY CONTROL CHART SUCH AS TEMPERATURE .
    By GEE in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-30-2006, 09:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1