SEOClerks

Microsoft Access Database Development for $20

Level 1
Attention: The owner of this service has not logged into SEOClerks for more than 30 days. It is highly recommend that you contact them before ordering this service. Last Login: 4112 days ago

Microsoft Access Database Development

Developing offline databases in Microsoft Access is my passion. I look forward to new challenges and concepts. I strive to develop well-coded, powerful and easy to use MS Access databases and am capable of completing most tasks in Access.

I will not develop/edit online databases, templates, homework or any versions older than 2007

Please message me first with the following information so I can give you an accurate price:

Detailed description of what you need (fields/forms/queries/reports/functions)
MS Access version
✓ Files or examples (please attach to the message)


I am available/online Mon-Fri from 10am to 5pm PST.


Important Details:

  • 5 fields are included in the base price, extras can be added on below.
  • I charge a flat fee of $4 per one visible, simple field (listed below). *A report and form with two visible fields on each would be $16 (4 visible fields).
  • Complex fields are extra.
  • Forms, reports and queries are included.
  • Table fields are free as long as a form, report or query is needed.


☀This is an incredible discount as developers normally charge 5x as much with a $1000 minimum. I only require a 5 field minimum and am happy to work on both large and small projects☀
​​

  • Revisions requested within 5 days after delivery incur no extra charge and are usually completed the same day.
  • After 5 days, revisions will be completed at my discretion and subject to my availability.
  • Additional fields and/or functionality will cost extra.
  • Orders/extras will be completed in the order they are purchased.
  • Copyright not included.


Simple Fields:

o AutoNumber
o Text
o Number
o Currency
o Date
o Hyperlink
o Basic Calculated Field (complex formulas cost extra depending on complexity)
o Basic Combo Box/Drop Down
o Check Box
o Option Button
o Column, as in a datasheet sheet column used in either a form or query
o Memo

Advanced Functionality:

o Search Box
o Find by Drop Down
o Lock/Unlock Fields or Forms
o View Address on Map
o Headings and Titles that use data in the database and are not static
o Email from Database (with/without attachments) *Requires Outlook
o Open Folder
o Create Folder
o Login/Users
o Custom Import (xls, xlsx, csv, etc…)
o Custom Export (xls, xlsx, csv, pdf, etc…)
o Custom File Attachments
o Open File(s)
o Skype Calling
o Editable Email Templates
o Field Formatting
o Form Events
o Custom VBA Coding


Tags

Access Database Microsoft Ms

0.0

0 reviews

Rating breakdown


Extras
I will add 10 visible fields 2 days $40
I will add 20 visible fields 3 days $80
I will add 40 visible fields 4 days $160

Other services by AccessGirl

$20 - In stock
Order Now
Process Time: 0.018801212310791

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM posts WHERE PID=2360101SELECT *, author_bookmarktip AS service_author_bookmarktip FROM posts WHERE PID=236010

/opt/clerks-staging/docroot/include/functions/includes/service.php 479 getAllServiceDetails() ()

SELECT * FROM categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

SELECT * FROM seoclerks.members WHERE USERID='204549'1SELECT * FROM seoclerks.members WHERE USERID='204549'

/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

SELECT * FROM ratings A, seoclerks.members B WHERE A.PID='236010' AND A.RATER=B.USERID1SELECT COUNT(A.RID) as total, SUM(bad) as badTotal, SUM(good) as goodTotal FROM ratings A, seoclerks.members B WHERE A.PID='236010' AND A.RATER=B.USERID

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM orders WHERE PID='236010' AND status in (1, 4, 6)1SELECT OID, stime, extradays1, extradays2, extradays3, extra1ordered, extra2ordered, extra3ordered, days, status, quantity, extras_data FROM orders WHERE PID='236010' AND status in (1, 4, 6)

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

UPDATE posts SET viewcount = viewcount + 1 WHERE PID='236010'1UPDATE posts SET viewcount = viewcount + 1 WHERE PID='236010'

/opt/clerks-staging/docroot/include/functions/main.php 1717 update_viewcount() ()

SELECT * FROM seoclerks.ratings WHERE USERID='204549' AND PID != 01SELECT good, bad FROM seoclerks.ratings WHERE USERID='204549' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

SELECT * FROM codeclerks.ratings WHERE USERID='204549' AND PID != 01SELECT good, bad FROM codeclerks.ratings WHERE USERID='204549' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

SELECT * FROM listingdock.ratings WHERE USERID='204549' AND PID != 01SELECT good, bad FROM listingdock.ratings WHERE USERID='204549' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

SELECT * FROM pixelclerks.ratings WHERE USERID='204549' AND PID != 01SELECT good, bad FROM pixelclerks.ratings WHERE USERID='204549' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

SELECT * FROM wordclerks.ratings WHERE USERID='204549' AND PID != 01SELECT good, bad FROM wordclerks.ratings WHERE USERID='204549' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

select * from categories_software order by name asc1select * from categories_software order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()

select * from categories_wanttobuy order by name asc1select * from categories_wanttobuy order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()

select * from categories_wanttotrade order by name asc1select * from categories_wanttotrade order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()

SELECT * FROM categories WHERE parentid = 0 1SELECT * FROM categories WHERE parentid = 0

/opt/clerks-staging/docroot/include/functions/main.php 21555 getNotParentCategories() include()

SELECT * FROM seoclerks.members WHERE USERID=? 1SELECT usergroup FROM seoclerks.members WHERE USERID=?

/opt/clerks-staging/docroot/include/functions/includes/member.php 2553 isStaffMember() include()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin
5.4714281SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (29,73,74,75,76,104,105) AND gtags like'%MVP%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 405.4714285.471428
0.4617611SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (74) AND gtags like'%VA%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4617610.461761
0.4447561SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (74) AND gtags like'%Avada%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4447560.444756
0.2374521SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (74) AND gtags like'%Dedicated%' AND type !=99 0.2374520.237452
0.1523171SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (29,73,74,75,76,104,105) AND gtags like'%shopify%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.1523170.152317
0.0901801SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (29,73,74,75,76,104,105) AND gtags like'%Webtraffic%' AND type !=99 0.0901800.090180