Need Access 2000 2010 script expert

I need a few scripts written that will automate some work that I do on several databases.

Please tell me if any of these scripts are not possible.

You will be given a access 2000 database to work with. All scripts must also work in Access 2010

Scripts should be done in a module that can be run. One script per module.

I already have a script that will build a table that has the all table names, fields and field types. I will include it.


1. Script to build duplicate tables of all tables that exists. When this is run it will create a duplicate (structure only) of all tables in the database with Final_%TABLE_NAME% as the name of the table

2. Script to create insert quires (actual physical queries on the Queries Page) for all original tables that when run will transfer all data from the original table to the FINAL_ tables

3. Script that will execute all the queries that were created in #2

4. Script that will create a table that has one of all the fields in all the other tables. Table must have a ID autonumber field that has the primary index on it.

5. Script that will transfer all data from FINAL_ tables to the corresponding field in the combine table. There will be one row for each row in each table. (Yes there will be a lot of empty fields)

You can not hardcode field or table names. Every database I run this one will be different. So it will need to read the structure of each table.

If you can not do all of these scripts please bid on the ones that you can an specify which you can do and which you can not do.

I need to have this done within the next few days


Habilidades: Microsoft Access

Veja mais: tables in data structure, index data structure, expert microsoft access, different types of data structure, different types data structure, access database module, access database expert, $5 script, hardcode, access 2000 database, need access 2010 expert, access 2000 access 2013, script automate, access create database, combine access database, microsoft access 2010 expert, build database access 2010, microsoft access 2010, transfer data access, access 2010 access, microsoft access expert, access access 2010, table create script, script expert, empty access

Acerca do Empregador:
( 23 comentários ) Nazire, United States

ID do Projeto: #5098361

Concedido a:


Hi.. I have gone through your requirements of creating 5 scripts of different requirements to automate work on Access Database. I will able to provide all 5 scripts/module as per your requirement. Please share databas Mais

$30 USD em 2 dias
(2 Comentários)

2 freelancers estão ofertando em média $30 para esse trabalho


Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc.. I have more than 10 years of experience to my credit. I have also worked on advanced VB features li Mais

$30 USD in 3 dias
(50 Comentários)