Access Database or Similar Built

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

Gig

WAGE / SALARY

$700

HOURS PER WEEK

TBD

DATE UPDATED

May 28, 2026

JOB OVERVIEW

To build a database off an Excel spreadsheet I have that will allow for easy scalability of content and data. The spreadsheet would need to pull information from Multiple tables, allow for customized pricing and have a overview page that will give me information on total used products/services by customers and total expected costs by products/services.

Database needs to be able to be added to in the future as more customers, products & services are added.

SKILL REQUIREMENT
Database Management
VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0008
Controller Execution Time ( Jobseekers / Job )  0.0544
Total Execution Time  0.0558
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,479,768 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/Access-Database-or-Similar-Built-1656559
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0485 seconds)  (Hide)
0.0004   SELECT *
                                FROM exrates
                                WHERE rate_name = 'USD-PHP' 
0.0013   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1656559
 LIMIT 1 
0.0009   SELECT *
FROM `employers`
WHERE `employer_id` = 939292
 LIMIT 1 
0.0399   SELECT COUNT(DISTINCT t.id) as cnt
FROM `t_thread` `t`
INNER JOIN `t_message` `m` ON `t`.`id` = `m`.`thread_id`
INNER JOIN `t_message_employer` `e` ON `m`.`id` = `e`.`message_id`
LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1656559
AND `misc`.`id` IS NULL 
0.0007   SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-06-20',ej.date_added) duration_days, DATEDIFF('2026-06-20',e.rebill_date) duration_rebill, ej.*, e.deactivate FROM employers e, employer_jobs ej WHERE e.employer_id = ej.employer_id AND
                                   ((e.user_level >= '500' AND ej.date_added <= e.rebill_date)
                                   OR e.employer_id = '' OR (ej.date_approved <> '2000-01-01' and DATEDIFF('2026-06-20',ej.date_added) <= 14 ))
                                   AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '1656559' 
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1656559 
0.0018   UPDATE employer_jobs SET hit_counts = '***May-28-2026=462***May-29-2026=20***May-30-2026=21***May-31-2026=10***Jun-01-2026=3***Jun-02-2026=5***Jun-03-2026=4***Jun-04-2026=3***Jun-05-2026=3***Jun-06-2026=2***Jun-08-2026=2***Jun-09-2026=1***Jun-10-2026=4***Jun-11-2026=4***Jun-12-2026=1***Jun-13-2026=2***Jun-20-2026=1' WHERE job_id= '1656559'  
0.0007   UPDATE employer_jobs SET monthly_hits = '***May-2026=512***Jun-2026=35' WHERE job_id= '1656559'  
0.0008   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '1656559' AND status LIKE 'sent%' ORDER BY id DESC  
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1656559 
0.0007   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '939292'
AND `date_added` >= '2022-06-08' 
0.0003   select * from teasers 
0.0004   SELECT * FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)