Access Queries and Bulk Linking Tables

Hello, I have a fairly simple database used for converting inbound orders from our clients into outbound orders for our sellers. Sellers each have their own format requirements. I estimate this work to be about 5 hours but in truth I dont know exactly what is required. Most of this is very elementary for an experienced SQL coder. 1: New Query to identify duplicate orders before processing. We receive thousands of orders at a time and errors are made. I need to catch them before we forward them on. 2. Existing Outstanding Order query has 2 fields: Requester and Requester ID. In the query we prefer to have the Requester field but when none is available I need it to fill in the Requester ID in that same spot. 3. New Query that will find duplicates, triplicates, quadruplicates, etc. based on 4 fields. Each of the orders had a request date. Everything except the most recent to be marked as canceled. 4. Existing query for a particular seller requires that requires multiple line items combined into as few lines as possible. So for instance my table will have a line item to order CHERRIES, another line item to order APPLES, and a third to order GRAPES. Their query has columns for BANANAS, APPLES, CHERRIES, and GRAPES and needs a value of "YES" in each of the corresponding fields. 5. Bulk linking files. I'd like to be able to link the first (or only if need be) sheet in a group of excel workbooks to the database. Default name of the linked table should be the sheet name. they always have a header row. 6. Bulk run queries. I'd like to be able to run certain queries in a batch. The macro, SQL, app, whatever, needs to run a query, export to excel, update two date fields with the current date or a date that I enter, then move on to the next query in the batch. Order of operations is essential. There are 3 very similar databases. Each will need the same thing. Most of the query design from the first one can be reused on the second two with some adjustments. Access to the second and third databases will only be granted after successful completion of the first one. I look forward to your quote. I cant promise that I have a ton of future work but I do stick with one coder so long as they remain available and deliver quality work. Thank you, Seth