Completed

Build a database using Microsoft Access

I am a business owner who needs to process data using Microsoft Access. On a weekly basis, I receive a CSV file with approximately 250,000 rows of data that consists of about 15 columns of data that I would like to process.

I have created tables that can show you what information I want to work with. I need to be able to use forms to select parameters (such as zip/postal code, city, date of license, etc.) so that I can generate a report that will give me a listing of all individuals who fall within those parameters. Then I need to export that report to an excel spreadsheet.

I plan to use those spreadsheets as mailmerge listings when I use Microsoft Publisher to send out email flyers to potential customers.

I have built the tables in a way that I want the data to look, but I want to have Access be able to take the raw data and put it into the table format when I want to update my information.

I know this is possibly hard to follow but would welcome more detailed Q/A.

I have attached some screen shots of some tables that I've been working with but I don't have time to lean all that I need to learn in order to process the data the way I want it.

Summary:

I want to use Access or Excel to automatically produce a table or spreadsheet that I can dump into an Access database. The table will have to be the result of processing the raw CSV data so that it only uses the columns that I want to use and discard the columns that I do not need to see.

Then I want to use Access Forms to select parameters such as "Distance" or "Area", "LicYEAR" (which I want to be derived from the LicDate, "LicType", .... to become part of the criteria of the query in order to produce a result that can be output to a spreadsheet.

I would also like to be able to update the "email sent" field to checked when the spreadsheet has been generated.

I hope this makes sense. Thank you for your interest.

Skills: Microsoft Access, Excel, Visual Basic, Database Programming, Data Processing

See more: asp calendar using microsoft access, using microsoft access budgeting, money using microsoft access, database projects microsoft access doc, sample inventory system using microsoft access vbnet programming, build processing calendar microsoft access, statistical analysis using microsoft access, airline reservation system using microsoft access database, creating staff schedule calendar using microsoft access, using microsoft access reports create html page, using microsoft access adwords, visual basic simple login using microsoft access database, using microsoft access erp, develop form using microsoft access, sending email using microsoft access modules, rental system using microsoft access, database project using microsoft access 2007, inventory database samples using microsoft access, using microsoft access small business accounting, database system project using microsoft access

About the Employer:
( 0 reviews ) Garden Ridge, United States

Project ID: #31641245

Awarded to:

VladimirLilenko

Hello! I'm a Databases Developer, Access, Excel and VBA expert more than seven years. I have completed many complex projects in my practice and I am ready to carry out your project in the reasonable price and in the sh More

$150 USD in 3 days
(249 Reviews)
7.1

36 freelancers are bidding on average $156 for this job

(448 Reviews)
8.2
(474 Reviews)
8.4
(273 Reviews)
8.1
(68 Reviews)
6.5
(16 Reviews)
5.8
(39 Reviews)
5.7
(67 Reviews)
5.5
merinsinha

Senior Visual basic , Database Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are antic More

$150 USD in 2 days
(114 Reviews)
5.4
(4 Reviews)
5.6
(49 Reviews)
5.4
(25 Reviews)
5.0
KellogITSolution

Hello I am working with MS-Access database and VBA for the past 18 years. I have also developed many important application using MS-Access as both front-end and back-end tool and have completed a good number of Acce More

$111 USD in 3 days
(41 Reviews)
5.1
SergeyKyiv

Greetings! My name is Sergey, I'm from Kyiv, Ukraine. I have 25+ years experience with MS Excel/Access/VBA/SQL: databases, finance, statistics, accounting, CRM etc. Any code I provide is well structured and commente More

$150 USD in 7 days
(14 Reviews)
4.7
crypthne

I'm an experience .NET developer, have been in this field for more than 5 years and working with many .NET related project (using C#/VB/ASP.NET with Angularjs). I also a MS Access and VBA developer, I've been in this f More

$100 USD in 5 days
(36 Reviews)
4.7
(9 Reviews)
4.4
krishantha972

Dear Client; I have gone through your project description and as per analysis ready to give you complete work. I am working as senior software engineer with over 10 Years’ experience for software development using c#, More

$140 USD in 7 days
(6 Reviews)
3.6
vovakovalkov80

Hi, I am interested in your offer as a developer with 10 years of experience. I want to do my best to you with my experience and diligent efforts. For a cheap price, you'll get more than you want in a short period of More

$140 USD in 7 days
(2 Reviews)
3.0
(1 Review)
2.7
alokes

Hi, Microsoft Access / VBA Expert 23+ Years of Experience !!! I've understood your requirements and ready to develop a database in MS Access as per the project's scope. Snapshot of Access databases: [login to view URL] More

$125 USD in 3 days
(10 Reviews)
3.9
pegasus9529

Hello, introduce my name is Deddy. I am interested in participating in your project. I have long time used [login to view URL] as a tool to create custom database applications. I have included several applications in my portfoli More

$150 USD in 7 days
(1 Review)
3.2