Access 2007 Upgrade to 2010
Required skills: Microsoft Access, Sharepoint, Visual Basic
I am a teacher, so I have very little money and I have to pay for this myself. I have a 2007 MS Access template called Lending Library. I have added several new tables. No new relationships have been created, but I may have messed up some relationships from the original template. That's why I'm calling YOU ! !
The purpose of this database is to track kits that will be loaned out to public school classrooms and returned.
1. I need the database normalized and a couple of new forms or reports added.
2. I need this database to work on a sharepoint 2010 server. Upgrading to Access 2010 is desireable but not required.
3. This database will be posted short term on FPweb sharepoint MOSS 2010 server (or a Sharepoint 2010 test server of your choice) for 6 months. Then it will be migrated to our in-house sharepoint server.
4. The forms need to be available online for multiple users. I will be the admin.
Here is what I am trying to accomplish. I am using terms in the Access 2007 file which I will supply.
I need to keep track of 200 kits that are lent to other teachers.
A teacher gets on a website where Form:User Details appears.
1.After entering name, the teacher first selects which Division {Division ID, "Chesterfield" is first choice]. Upon selection of division, TchSchool ID box is populated with a dropdown list of all schools in that division. Selections of division and specific school are of course posted to userdetails table.
2. Cellphone should be a textnumber or hyphenated number...I don't know how to format that
3. There is another function that I have not developed yet, and that is to create a lesson name that is associated with the period that the kit is on loan for. This is called a Session. Each lesson will have multiple sessions, but the sessions don't have anything to do with the kits being loaned out. They are loaned or checked out by date, and that is already in the template. But we can talk about that later.
The user needs to register for a class and a specific session of that class. Select a box that says "I need a Tech Kit." There should be a function where the database or a form or something automatically assigns the user a kit. The kit will be sent to the user a specific number of days before the session. This "lead time" is set when the admin creates the lesson and session times. The db creates a form which shows on a given day which kits need to be sent out and to whom. There is a form for which kits are overdue. Emails are sent as notices and reminders, and the admin selects email texts
When you solve my issue, I will try to look at the code and understand what you did. If I cannot, I will need you to explain what you did. When this project is over, I need to be able to troubleshoot it myself.
I created an Excel sheet that gives a forecast of inventory levels, and would like to add this function to this database, but that would be a separate price or bid.
of course, of course, this project was handed to me yesterday to accomplish immediately. of course.
Additional information submitted: 09/24/2010 at 17:59 EDT:
Please disregard attached Database4 file. it is too large for Freelancer.com I apologize.
For more details about this project, please inspect attached files. Begin with Production Goals Document. Then see attached images. All tables are also included.
This project is to work in Access for one user. I will migrate it to Sharepoint 2010 test server.
Project is to begin with normalization of all tables and to modify or create new forms as seen in attached production goals document.
Thank you for your continued interest !!
Additional files submitted: (Files are only available for logged in users)
Database4.accdb
Contacts.xlsx
Contact+Details.jpg
assets_by_owner.jpg
assets.xlsx
asset+list.jpg
allschools.xlsx
Production+goals.docx
reports.jpg
overdue+assets.jpg
LessonName.xlsx
JobType.xlsx
Grades.xlsx
Division.xls
databases.jpg
UserInfo.xlsx
The purpose of this database is to track kits that will be loaned out to public school classrooms and returned.
1. I need the database normalized and a couple of new forms or reports added.
2. I need this database to work on a sharepoint 2010 server. Upgrading to Access 2010 is desireable but not required.
3. This database will be posted short term on FPweb sharepoint MOSS 2010 server (or a Sharepoint 2010 test server of your choice) for 6 months. Then it will be migrated to our in-house sharepoint server.
4. The forms need to be available online for multiple users. I will be the admin.
Here is what I am trying to accomplish. I am using terms in the Access 2007 file which I will supply.
I need to keep track of 200 kits that are lent to other teachers.
A teacher gets on a website where Form:User Details appears.
1.After entering name, the teacher first selects which Division {Division ID, "Chesterfield" is first choice]. Upon selection of division, TchSchool ID box is populated with a dropdown list of all schools in that division. Selections of division and specific school are of course posted to userdetails table.
2. Cellphone should be a textnumber or hyphenated number...I don't know how to format that
3. There is another function that I have not developed yet, and that is to create a lesson name that is associated with the period that the kit is on loan for. This is called a Session. Each lesson will have multiple sessions, but the sessions don't have anything to do with the kits being loaned out. They are loaned or checked out by date, and that is already in the template. But we can talk about that later.
The user needs to register for a class and a specific session of that class. Select a box that says "I need a Tech Kit." There should be a function where the database or a form or something automatically assigns the user a kit. The kit will be sent to the user a specific number of days before the session. This "lead time" is set when the admin creates the lesson and session times. The db creates a form which shows on a given day which kits need to be sent out and to whom. There is a form for which kits are overdue. Emails are sent as notices and reminders, and the admin selects email texts
When you solve my issue, I will try to look at the code and understand what you did. If I cannot, I will need you to explain what you did. When this project is over, I need to be able to troubleshoot it myself.
I created an Excel sheet that gives a forecast of inventory levels, and would like to add this function to this database, but that would be a separate price or bid.
of course, of course, this project was handed to me yesterday to accomplish immediately. of course.
Additional information submitted: 09/24/2010 at 17:59 EDT:
Please disregard attached Database4 file. it is too large for Freelancer.com I apologize.
For more details about this project, please inspect attached files. Begin with Production Goals Document. Then see attached images. All tables are also included.
This project is to work in Access for one user. I will migrate it to Sharepoint 2010 test server.
Project is to begin with normalization of all tables and to modify or create new forms as seen in attached production goals document.
Thank you for your continued interest !!
Additional files submitted: (Files are only available for logged in users)
Database4.accdb
Contacts.xlsx
Contact+Details.jpg
assets_by_owner.jpg
assets.xlsx
asset+list.jpg
allschools.xlsx
Production+goals.docx
reports.jpg
overdue+assets.jpg
LessonName.xlsx
JobType.xlsx
Grades.xlsx
Division.xls
databases.jpg
UserInfo.xlsx
Posted In:SharepointVisual Basic |
Related projects:
Create MS Access 2007 Database to track client appointments
of their appointments and the amount spend.
A report where I can specify dates to view all client appointments in a particular range, and the amount spent.
A report where I can see how many of a particular duration have been entered.
And I need the whole database to be user-friendly and smart-looking :-)
If you have any other features you think I might need, please don't hesitate to make suggestions!
A report where I can specify dates to view all client appointments in a particular range, and the amount spent.
A report where I can see how many of a particular duration have been entered.
And I need the whole database to be user-friendly and smart-looking :-)
If you have any other features you think I might need, please don't hesitate to make suggestions!
Convert Access 2007 Database to Online Equiv MYSQL PHP
td align=right style="padding-left: 20px; width: 320px">
Additional files submitted: (Files are only available for logged in users)
Database.zip
Additional files submitted: (Files are only available for logged in users)
Database.zip
converting access 2007 database to mysql
i need a database created in access 2007 to be converted to mysql based database and need it urgently. It requires some skills related to using php with ODBC connectivity. I need this urgent.
Basic utilities access 2007 & sql 2008
I am looking for a programmer to write a simple access 2007 form, to add, edit, veiw and delete BLOB data files on an sql server 2008 database using filestream.
Access 2007 Programming
one of the tabs, it creates new blank records in the database. So I wind up with a lot of empty school records. I'd like to not have it create new records except when "Save" is pressed on the detail view.
I'm looking to select someone quickly to work with, so please respond with at least one sample of Access 2007 code that you have developed, preferable code rather than macros.
I'm looking to select someone quickly to work with, so please respond with at least one sample of Access 2007 code that you have developed, preferable code rather than macros.
Ms Access 2007 Lighthouse
We are an investment company. We would like to build a MS Access 2007 application to manage our contacts. We need to be able to store information about our investors, retrieve info and use it for (e)mailings of newsletters.
Convert Microsoft Access 97 Application to Access 2010 (2)
ust be created to export any selected data records and/or fields in excel, csv, quickbooks, and 5 other formats.
n. Modify all existing interfaces to be user friendly (user friendly so that no Access experience is necessary)
o. Add user friendly Reports creation module to enable users to create their own reports
p. Includes all source code and rights of ownership.
q. Includes 5 more features to be determined
n. Modify all existing interfaces to be user friendly (user friendly so that no Access experience is necessary)
o. Add user friendly Reports creation module to enable users to create their own reports
p. Includes all source code and rights of ownership.
q. Includes 5 more features to be determined
14 DAY Deadline! Convert Access 2007 database to MYSQL
he forms, queries and reports. I want the web one to behave in much the same way. The user interface does not need to have much time spent on it, just to be functional as this is likely to change at a future time. When quoting please include what programming languages you believe is going to be best to use and what platform hosting package would be required to run the site.
Please contact us if you require anymore information.
Please contact us if you require anymore information.
Worksheets/Reports in MS Access 2007
/>
Additional information submitted: 11/11/2010 at 20:02 EST:
Bid above $ 50 will not be accepted.
"Please add $ 50 so that I should know its not a fake bid"
Additional information submitted: 11/11/2010 at 20:02 EST:
Bid above $ 50 will not be accepted.
"Please add $ 50 so that I should know its not a fake bid"
MS Access 2007 - to WEB App
FlightRegister.png
ContactForm.png
WorldAirportDatabase.png
TrainingRecordSample.pdf
TimeReport.png
ScheduleInfo.png
StudentLogbook.png
ContactForm.png
WorldAirportDatabase.png
TrainingRecordSample.pdf
TimeReport.png
ScheduleInfo.png
StudentLogbook.png
Create Access 2007 Database with Sharepoint as Backend
.
Thanks heaps
Additional files submitted: (Files are only available for logged in users)
sample_form_database.xls
Thanks heaps
Additional files submitted: (Files are only available for logged in users)
sample_form_database.xls
Convert Access 97 Database to 2007
es with dependencies for DAO2535.tlb. This is an issue where the code is using Access 1.0 objects in the code. This will need to be fixed, as I do not want additional libraries installed at the site.
There are 23 total tables, 70 forms, and about 30 reports. The vast majority convert automatically. There is very little "real" code, most of it defines searches and how buttons work.
There are 23 total tables, 70 forms, and about 30 reports. The vast majority convert automatically. There is very little "real" code, most of it defines searches and how buttons work.
MS Access 2007 DB Upgrade
1. Integrate Existing MS Access 2007 Database Templates [Faculty, Class, Student] into One
2. Create Deploument using MS Access Runtime Engine [2007]
3. Upgrade this database to SQL 2008 Server Database Version
2. Create Deploument using MS Access Runtime Engine [2007]
3. Upgrade this database to SQL 2008 Server Database Version
Upgrade to SharePoint 2010
This project is is for Mahinthan86. No one else should bother bidding.
Upgrade our SharePoint 2008 to 2010
Task
SharePoint 2010 Setup + Backup + Migration
Upgrade our SharePoint 2008 to 2010
Task
SharePoint 2010 Setup + Backup + Migration
MS Access 2007 Database
acked individually in excel . Excel sheets will be provided for reference and for data import. Also would like it to be expandable if the need comes in the future. Ability to search full database for different information. Switchboard for each of the following. Front page personalized with my information and password protected.
Full details in attachment as well as some screenshots of some of the worksheets that will be provided
Full details in attachment as well as some screenshots of some of the worksheets that will be provided
MS Access 2007 odbc reconnect and rename Featured Projects, identified by a l
erver-in-ms-access-not-remembering-user-name-and-pa
Notice the option 3 parameter in the post above is also mentioned in link below (about 2/3 way down) so it may be a good idea to keep in mind.
http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-configuration-connection-parameters.html
Notice the option 3 parameter in the post above is also mentioned in link below (about 2/3 way down) so it may be a good idea to keep in mind.
http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-configuration-connection-parameters.html
Securing Access 2007 Database
ot secured. It seems some user is bypassing access and getting control over the navigation pane database over the LAN
Should we migrate to SQL? Is there any good solution to keep access secure enough, to avoid such a migration?
Thanks in advance for your replies to this matter.
Luis Flores
Teleguia Publications
General Operations Manager
Should we migrate to SQL? Is there any good solution to keep access secure enough, to avoid such a migration?
Thanks in advance for your replies to this matter.
Luis Flores
Teleguia Publications
General Operations Manager
Complete work on MS Access 2007 Database
cess 2007 and have a proven history of work (and references) in this area. You must be willing to start immediately (as in tonight or early tomorrow) and hopefully be able to turn this around in 24 hours or by this weekend. Ideally you would provide us with an hourly rate, the estimated time it would take to complete the work, and total estimated cost. ***
Secure MS Access 2007 for Commercial Sales
'm completing an MS Access 2007 database that I want secured so I can sale it based on a license that is restricted to the customers computer.
I need to see a demo where you've done that and know the process a customer purchases the database and gets an unlock code that is restricted to their computer so it can't be distributed easily.
Thanks.
I need to see a demo where you've done that and know the process a customer purchases the database and gets an unlock code that is restricted to their computer so it can't be distributed easily.
Thanks.
Wordpress Upgrade To Latest
When upgrading automatically to latest Wordpress-version, an error occurred.
An error-message is shown now on front-page.
I need upgrade to newest Wordpress installed.
cPanel and FTP-access available.
I can show you in pmb the error message.
An error-message is shown now on front-page.
I need upgrade to newest Wordpress installed.
cPanel and FTP-access available.
I can show you in pmb the error message.
