Summary
1) Access 2010 user interface
2) Rework forms and tables
3) Mail merge functionality
- Must have ACCESS 2010 experience
- Fluent English
- Fast internet - Work on my desktop with Gotomypc
Elements to include
* Rebuild user interface with access 2010
* Rework activities table - task, appointments, Notes
* Add table "Projects" - one-to-many with activities
* Add stored filters - see sample Microsoft database "Tasks"
* Mail merge - send single letter or email - send mass mailings
* Contact form - rework - reprogram drop downs filters - add new sbuforms
* Add "activities" functionality - Task and appointments - sync to MS outlook (tasks, appointments, contacts)
* Use VBA or 2010 macros
## Deliverables
Summary
1) Access 2010 user interface
2) Rework forms and tables
3) Mail merge functionality
Requirements
- Must have ACCESS 2010 experience
- Fluent English
- Fast internet - Work on my desktop with Gotomypc
Background
* I have an access database that I developed over many years - It is a contacts database - Multiuser on peer to peer network
* I want you to get on the computer with me and help me design it
* Need to rebuild it using best practices - naming conventions - get rid of the unused queries - get reuseable code - Use of parameters
* Help me build this with "off the shelf" stuff in access - I don't want complex technology that I can't maintain in house
* Please show me example of your work
* You must be able to schedule some time to work in "remote assistance" on my computer. We will talk by phone as we are doing this. (I will call you and pay for the phone charges)
* You must be fluent in English to converse on the phone
* Communication and updates are important -You must be available at the same time every day for phone conference if need be
* Document the VBA using best standards - Use best standards and conventions for variable naming - queries and code
Elements to include
* Rebuild user interface with access 2010
* Rework activities table - task, appointments, Notes
* Add table "Projects" - one-to-many with activities
* Add stored filters - see sample Microsoft database "Tasks"
* Mail merge - send single letter or email - send mass mailings
* Contact form - rework - reprogram drop downs filters - add new sbuforms
* Add "activities" functionality - Task and appointments - sync to MS outlook (tasks, appointments, contacts)
* Use VBA or 2010 macros
System: Desktop Windows 7
Microsoft Access 2010