MS Access database testing and feedback (re-post).
Required skills: Database Administration, Microsoft Access
This is a re-post of a project from last month that was never completed. I have invited some previous bidders to bid again, but all bids are welcome.
I have just completed an Access database for a friend's business, despite being a novice in Access and having to teach myself along the way. I am pretty experienced in Excel and have some knowledge of relational databases from a previous job working on SAS as an end user, but involved in the implementation. I have no VBA experience outside this last couple of weeks.
The database comprises of three main tables...:
- Contacts: Containing personal details of both public and trade customers.
- Membership Cards: Containing customer's membership details.
- Renewals: Narrow table containing renewal status, dates and amounts.
...and several smaller tables (combo box sources, etc), as well as their corresponding forms, the various underlying queries and one report. It includes macros (mostly embedded), some VBA (mostly found on forums and adapted) and probably some bad working practice and mistakes. I'll populate the database with dummy data prior to uploading it.
Through word of mouth, two other similar businesses are interested in my database and before I distribute this thing I'd like for a professional to give it a once over and offer some constructive criticism and pointers. I would also like some advice on how to go about some upgrades I have in mind. Specifically how to populate email templates with data for the purposes of customer service (single mail) and marketing and notifications (mail merge). Populating and sending an HTML email template within Access and via a Gmail account is my ideal result (Can Access handle POP/IMAP in that way?). I have experience managing mail campaigns in SAS.
I realise I'm not on a huge budget, so I'm not asking for you to rebuild the database. I expect it will probably take you a few hours to check it over and produce a document with your feedback, followed by an email exchange over the course of a few days for any clarification or questions.
I have just completed an Access database for a friend's business, despite being a novice in Access and having to teach myself along the way. I am pretty experienced in Excel and have some knowledge of relational databases from a previous job working on SAS as an end user, but involved in the implementation. I have no VBA experience outside this last couple of weeks.
The database comprises of three main tables...:
- Contacts: Containing personal details of both public and trade customers.
- Membership Cards: Containing customer's membership details.
- Renewals: Narrow table containing renewal status, dates and amounts.
...and several smaller tables (combo box sources, etc), as well as their corresponding forms, the various underlying queries and one report. It includes macros (mostly embedded), some VBA (mostly found on forums and adapted) and probably some bad working practice and mistakes. I'll populate the database with dummy data prior to uploading it.
Through word of mouth, two other similar businesses are interested in my database and before I distribute this thing I'd like for a professional to give it a once over and offer some constructive criticism and pointers. I would also like some advice on how to go about some upgrades I have in mind. Specifically how to populate email templates with data for the purposes of customer service (single mail) and marketing and notifications (mail merge). Populating and sending an HTML email template within Access and via a Gmail account is my ideal result (Can Access handle POP/IMAP in that way?). I have experience managing mail campaigns in SAS.
I realise I'm not on a huge budget, so I'm not asking for you to rebuild the database. I expect it will probably take you a few hours to check it over and produce a document with your feedback, followed by an email exchange over the course of a few days for any clarification or questions.
Posted In: |
Related projects:
MS Access database testing and feedback.
eting and notifications (mail merge). Populating and sending an HTML email template within Access and via a Gmail account is my ideal result.
I realise I'm not on a huge budget, so I'm not asking for you to rebuild the database. I expect it will probably take you a few hours to check it over and produce a document with your feedback, followed by an email exchange over the course of a few days for any clarification or questions.
I realise I'm not on a huge budget, so I'm not asking for you to rebuild the database. I expect it will probably take you a few hours to check it over and produce a document with your feedback, followed by an email exchange over the course of a few days for any clarification or questions.
Ms Access Database 2
I want to create a new database for my personal use...
Additional Info (Added 3/21/2011 at 0:58 EST)...System Message: This is a reposting of project MS Access Database (1299369860).
Additional Info (Added 3/21/2011 at 0:58 EST)...System Message: This is a reposting of project MS Access Database (1299369860).
Ms Access System
Build MS Access Database, 3 Data entry forms and 3 reports.
We want the reports to be web-based reports accessing the MS Access Database.
The Access Database will have 3 tables to start with. The data entry forms must keep the integrity in those three tables.
Please present your bid, and any example of user interface for data entry and reports.
We want the reports to be web-based reports accessing the MS Access Database.
The Access Database will have 3 tables to start with. The data entry forms must keep the integrity in those three tables.
Please present your bid, and any example of user interface for data entry and reports.
Ms Access Database
manager email address
developer name
developer email address
Manager name
Manager email address
once tables are created
We'll create (quesry)reports for distribution to the email address of the project manager, manager, customer or developer
Create and save a query that pulls all the company names from the project number and customer name and project manager fields
other reports or queires may be required in the future.
developer name
developer email address
Manager name
Manager email address
once tables are created
We'll create (quesry)reports for distribution to the email address of the project manager, manager, customer or developer
Create and save a query that pulls all the company names from the project number and customer name and project manager fields
other reports or queires may be required in the future.
Ms Access Database For Website
We want the same function but for a another customer. Database will have admin login and customer login with secure passwords. Also a copy and paste responses.
Please quote only if you have sample Ms Access Databases we can view of your work. If you do not have working site with access bid will not be considered.
Link to site with database (customer login only)
http://www.compliance-inspection.com/apptesting/login.asp
username: cisi2007cl password: slb
Please quote only if you have sample Ms Access Databases we can view of your work. If you do not have working site with access bid will not be considered.
Link to site with database (customer login only)
http://www.compliance-inspection.com/apptesting/login.asp
username: cisi2007cl password: slb
Publish An Ms Access Database
I need to somehow publish an MS access database so that it can be accessed via the internet. I want the menu to be a page and then the data to be entered right from the page.
The problem is I do not have a .ASP or MS compatible server.
So i am open to ideas!
The problem is I do not have a .ASP or MS compatible server.
So i am open to ideas!
Ms Access Database
rts
- Filtered lead data reports (requires lookup in data, vendor and product tables)
- Filtered sales data reports (requires lookup in data, vendor and product tables)
Features
- Import lead data CSV files (must dedup new imports based on unique ID)
- Import sales data CSV files (must dedup based on unique ID)
- Export filtered CSV file for leads/sales
- Attached filtered reports to Outlook email as CSV file
Good luck in bidding.
- Filtered lead data reports (requires lookup in data, vendor and product tables)
- Filtered sales data reports (requires lookup in data, vendor and product tables)
Features
- Import lead data CSV files (must dedup new imports based on unique ID)
- Import sales data CSV files (must dedup based on unique ID)
- Export filtered CSV file for leads/sales
- Attached filtered reports to Outlook email as CSV file
Good luck in bidding.
Access Database Debugging And
s made as follows:
1)add a section where I can make notes in point form
2)add a section where I can make a list of clients that I can print out
3)add a formula that will be able to calculate labor% I will be providing the formula
4) have the ability to print the entire database in a way the is economical in terms of the amount of paper
Please find the attached database. Also I am open to suggestions on how to get a more efficient database.
1)add a section where I can make notes in point form
2)add a section where I can make a list of clients that I can print out
3)add a formula that will be able to calculate labor% I will be providing the formula
4) have the ability to print the entire database in a way the is economical in terms of the amount of paper
Please find the attached database. Also I am open to suggestions on how to get a more efficient database.
Extract Data From Ms Access And Outlook Backup 2 2
Simple Work: You need you extract data from MS Access database and MS outlook backup (pst file)
I'll need the backups according to certain criteria like creation date, tags etc.
Easy work: $ 50
Please do not ask me unrealistic questions like the size of backup (though its 20 MB around), and other details etc. Just for your information, I need to import them into Gmail.
Thanks
I'll need the backups according to certain criteria like creation date, tags etc.
Easy work: $ 50
Please do not ask me unrealistic questions like the size of backup (though its 20 MB around), and other details etc. Just for your information, I need to import them into Gmail.
Thanks
Extract Data From Ms Access And Outlook Backup
Simple Work: You need you extract data from MS Access database and MS outlook backup (pst file)
I'll need the backups according to certain criteria like creation date, tags etc.
Easy work: $ 50
Please do not ask me unrealistic questions like the size of backup (though its 20 MB around), and other details etc. Just for your information, I need to import them into Gmail.
Thanks
I'll need the backups according to certain criteria like creation date, tags etc.
Easy work: $ 50
Please do not ask me unrealistic questions like the size of backup (though its 20 MB around), and other details etc. Just for your information, I need to import them into Gmail.
Thanks
Convert MS Access Database to MySQL Tables
ust have a few tables to go so need somebody who can do this work today.
I also need help with the tables that have been imported. They were imported as duplicate tables like if i had students table originally in mysql then we made another called students2 for the new imported ms access data.
Now I want to copy the data from students2 to students which is pretty easy.. just need to match the fields i want to bring across.
I also need help with the tables that have been imported. They were imported as duplicate tables like if i had students table originally in mysql then we made another called students2 for the new imported ms access data.
Now I want to copy the data from students2 to students which is pretty easy.. just need to match the fields i want to bring across.
Ms Access Database
I want someone to create a tool on MS Access.
Following is desired out of that tool:
Upload current month's and previous month's data and generate few reports out of that (Approx 9 reports)
One of the criterias of one of the reports will be to derive data of current month (hence that has to be taken care of in the coding.
This is urgent, contact me ASAP.
Following is desired out of that tool:
Upload current month's and previous month's data and generate few reports out of that (Approx 9 reports)
One of the criterias of one of the reports will be to derive data of current month (hence that has to be taken care of in the coding.
This is urgent, contact me ASAP.
Payroll Program In C# With Ms Access Database
is entered into tblTimeSheet.
When the next Monday comes- Vija enters his name and password and a blank form opens for him to start entering hours for the week again.
I need the process above accomplished- if you have another way of doing it - I will look at it- I just need it to work like I have explained.
If you can provide this- I need to see an example to let you know that this is what I am looking for
password for access database is 123abc
thank you
When the next Monday comes- Vija enters his name and password and a blank form opens for him to start entering hours for the week again.
I need the process above accomplished- if you have another way of doing it - I will look at it- I just need it to work like I have explained.
If you can provide this- I need to see an example to let you know that this is what I am looking for
password for access database is 123abc
thank you
Form In Ms Access Database
suggestions to improve this or correct any problem you see?
The database to download is on wikisend-at:
http://wikisend.com/download/949030/twoforms database.accdb
( i will check back in about 8 hours)
thank you,
The database to download is on wikisend-at:
http://wikisend.com/download/949030/twoforms database.accdb
( i will check back in about 8 hours)
thank you,
Access Database Graphs Reports
sary fields. I have attached a word document explaining the layout of the first part with projections regarding the amount of work. I will supply all the data step by step using the same format as the word document to build the program. I will pay escrow half way through the project and not sooner as I had a bad experience with escrow paid in the beginning of the project. I hope we can achieve this project within a week and testing for no longer than 2 to 3 days after wards. Thank you.
Ms Access Database Creation
er day, so its a small system. It must have a good interface and front end, containing our company logo etc... and be approved by me first before progressing.
Must have printable report for giving total new inquiries/sales per week/month/year etc...
Additional Info (Added 9/10/2008 at 13:09 EST)...Details of all current customers from 2008, approx 270 peoples name, email address, ph no. and comments must be entered in to the database when complete
Must have printable report for giving total new inquiries/sales per week/month/year etc...
Additional Info (Added 9/10/2008 at 13:09 EST)...Details of all current customers from 2008, approx 270 peoples name, email address, ph no. and comments must be entered in to the database when complete
MS Access database editing
individual clients invoices, save these individual invoices as a pdf, and then email to clients. Way too cumbersome.
We are willing to speak with a Access programmer on possible solutions if editing in not possible, ie. a complete overhaul of the database to make it more efficient and user friendly. If we are happy with the work, future modifications and maintenance will be arranged.
Look forward to hearing some options!
We are willing to speak with a Access programmer on possible solutions if editing in not possible, ie. a complete overhaul of the database to make it more efficient and user friendly. If we are happy with the work, future modifications and maintenance will be arranged.
Look forward to hearing some options!
Joomla Website with data gathering for MS access database Featured Projects, i
nd by user) into an MS Access database. The information includes name, location, department, photo etc. The database will be used to generate namecards, event schedules etc
I can provide more infomration and am also open to suggestions if you have other ideas of how to complete this task.
I can provide more infomration and am also open to suggestions if you have other ideas of how to complete this task.
MS Access database with linking to MS Word templates 2
s project might require some visual basic programing.
I will provide a list with all data fields to be used and the predefined Word-templates. I will also show what data fields each template should contain.
Bidders should explain about similar projects performed in this area and also give a brief description of the proposed solution.
I will provide a list with all data fields to be used and the predefined Word-templates. I will also show what data fields each template should contain.
Bidders should explain about similar projects performed in this area and also give a brief description of the proposed solution.
MS Access database with linking to MS Word templates
r>This project might require some visual basic programing.
I will provide a list with all data fields to be used and the predefined Word-templates. I will also show what data fields each template should contain.
Bidders should explain about similar projects performed in this area and also give a brief description of the proposed solution.
I will provide a list with all data fields to be used and the predefined Word-templates. I will also show what data fields each template should contain.
Bidders should explain about similar projects performed in this area and also give a brief description of the proposed solution.
