Build Access database to store contacts and workshop attendance data

$250-750 AUD

Selesai

Dibuat

lebih dari 9 tahun yang lalu

$250-750 AUD

Dibayar ketika dikirim

Job Description: We're looking for a Database expert to help us create an access database from an excel database. Your responsibilities: Using data in an existing excel spreadsheet you will develop an access database to: - Store contact details - Store records of workshop attendance, and link contacts to workshop attendance - Provide a mechanism to input new workshop attendance records which searches existing contact database and either (1) link to an existing contact or (2) build a new contact record for new attendees - As workshop attendance data is entered the access database will search for each name, phone number or email (whichever is available) in existing contacts and auto-fill contact details (name, email, phone, address etc) based on a searc match - Build auto reports to display number of individuals attending workshops each financial year (one individual may attend several workshops) - build auto report function to display total number of attendees at workshops each financial year - build auto report function to display number of new contacts attending events each financial year - build auto report function to display number of workshops in each category each financial year

Microsoft Access

Software Architecture

ID Proyek: 6790161

Tentang proyek

22 proposal

Proyek remot

Aktif 9 tahun yang lalu

Ingin menghasilkan uang?

Alamat email

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda

Dapatkan bayaran atas pekerjaan Anda

Uraikan proposal Anda

Gratis mendaftar dan menawar pekerjaan

Diberikan kepada:

@Premshanks

This is my proposal I will provide you an MS Access application (forms/reports) which will do the following 1) Customer master (add/edit/delete) 2) Workshop master (add/edit/delete workshops) 3) Workshop attendance (in this form - you can either link existing customers & it would autofill certain details, or it would help you to add a new customer and link it) 4) Provide you metrics wanted as per the project description Note that I shall use your EXCEL file just as a reference. In future all the data will be stored in the mS Access only. In case you have existing excel files - then for a smaller fee I can migrate the data to the new ms access database. In case you insist to have the data in excel file - then also I can do the same functionality as explained but the data would be stored in excel. Timeline - 3 days Regards Prem CATsys

$250 AUD dalam 10 hari

4,8

(284 ulasan)

6,4

22 freelancer menawar dengan rata-rata $390 AUD untuk pekerjaan ini

@shikhamehta

Hey, I am an expert in creating database systems as you would see in my work history here on freelancer. I reviewed the spreadsheet you attached and read through the requirements description. I can create an Access database which will: 1. Allow you to import historical data (if any) 2. Facilitate the entry of new data for workshops through user forms (we may discuss the layout of such forms later in the project). Also, facility to pre-fill some information 3. Have linked tables to enter contact information and link them to workshop attendance 4. Have some pre-defined reports that could be generated on demand and also have some queries ready for you to analyze important data easily Do let me know if you would like me to work on this project for you and we may discuss the details and next steps. Look forward to hear from you. Thanks and Regards, Shikha (Automyze Consulting)

$388 AUD dalam 7 hari

5,0

(227 ulasan)

7,0

@ngscoder

Hi To qualify myself, I am Microsoft Certified Professional in databases. I have performed database architect & database owner role in the past while working at medium to large enterprises. I have seen your attached excel sheet which gives lot of details. However, there are few things which I need to ask and have some suggestions to make as well. Please get in touch to discuss them. Looking ahead to your reply. Regards AZ

$526 AUD dalam 10 hari

4,9

(96 ulasan)

6,9

@alekscoder

Hi, I can do this job for you. As I understand you need Microsoft Access database with: 1. Tables: 1.1 Customer (with contact details) 1.2 Workshop (with workshop details) 1.3 Workshop categories 1.4 Workshop attendance data 2. Forms: 2.1 Customer (with contact details) 2.2 Workshop (with workshop details) 2.3 Workshop categories 2.4 Workshop attendance data with additional calculated fields: 1) number of individuals attending workshops each financial year (one individual may attend several workshops) 2) total number of attendees at workshops each financial year 3) number of new contacts attending events each financial year 4) number of workshops in each category each financial year I am waiting for your decision. Regards, programmer Aleks

$277 AUD dalam 7 hari

5,0

(161 ulasan)

6,2

@paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.

$250 AUD dalam 8 hari

4,8

(103 ulasan)

6,6

@dipakmoliya

Hello! I have been in this industry for 6 years and such jobs are my daily practice. I can assure you that if you work with me once, you will always work with me for these kind of projects. I have been read your Project description throughout. I have been made this type of work many times. You can see my PROFILE for more details . See some screenshots of my previous work in my PORTFOLIO. Let's discuss for even more details before you award me the project. Thank you in anticipation. Have a nice day...

$266 AUD dalam 10 hari

4,9

(74 ulasan)

6,1

@abdellatif81

Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around Microsoft database (Access ,Sql Server) development and administration on several projects . My last job was database consultant within Accenture ,for more than 4 years .I worked for several projects relating with SQL Server and access databases on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in MS Access development and Visual Basic to develop all types of requirements related (Forms ,Queries ,Reports ,Database conception and enhancements) ,and given my experience, i am persuaded to give you High quality of work delivery withing budget and time Best regards,

$266 AUD dalam 10 hari

5,0

(10 ulasan)

4,9

@valentinnovakov

Hello Apanie, I have developed Access databases with similar functionality and I can help you with your database. I can make a form with auto-filling details of existing attendees. All entered details will be added to corresponding tables in database. As I understand you need following reports: 1. number of individuals attending workshops each financial year - if someone have attended several workshops he/she will be counted only once 2. total number of attendees at workshops each financial year - attendees will be counted for each workshop they have attended 3. number of new contacts attending events each financial year 4. number of workshops in each category each financial year Is it correct? Best regards, Valentin Novakov

$750 AUD dalam 15 hari

5,0

(8 ulasan)

4,9

@sunsoftpro

Hi Employer, I have read your description and been interested in your project. Let me help you develop the access database you require. I'm ready to discuss and start to work on it now. ==================================== Please discuss before awarding the project.

$480 AUD dalam 7 hari

4,8

(13 ulasan)

4,9

@bspanovic

Hello Similar projects have already been implemented, and I have experience with them. For example, for US based training company. I'm Microsoft Certified Database Developer & Administrator. I work with Microsoft Access since it first version. C#, ASP.NET, Microsoft SQL, Javascript, HTML 5, CSS 3 and Bootstrap are my preferred web technologies which I using the most of time. My working standard always include technical documentations and user manuals (I attach one sample). I could show working applications which clearly demonstrate my knowledge and skills. The work can begin immediately. My working hours will adjust your time zone if necessary. RGD's Borut Spanovic

$250 AUD dalam 10 hari

5,0

(6 ulasan)

4,8

@Pharoa

I hereby submit my offer to develop and supply the Ms Access database described in your tender document. I will bring over 20 years programming experience plus very strong Ms Access skills to bear on this role. Please contact me if you have questions on any or all aspects of my offer.

$750 AUD dalam 10 hari

5,0

(2 ulasan)

3,0

@tandonshailendra

Understand you need Access 2007/2010/2013 based offline solution. About Myself Good Day!. Let me introduce myself for building your confidence in me. Worked at Sr. position with experience of marketing, Service, Production and IT Excel Expert Group Member Access Expert Group Member Worked on Macro, VB, Pivot, User Form Proficiency in Office tools ,SAP, AutoCAD, 3DMax, Coral, Qualification- Mechanical Engineer Available on Skype Some Projects: Developed complete ERP system for Marketing in DB4 (earlier to Access) SAP implementation as Key Coordinator Community Survey (Near 10 Million Data compilation) in Excel Industrial Project Report in Excel Multilingual Kazien Sheet in Excel with VB Offer Preparation in Access Project Planner in Excel Very Large Database Analysis For Details of my Work 1. Please see my profile 2. Please see Services offered by me. If you initiate dialog, I can submit samples of my work. It will be pleasure working for you. I believe in Customer Delight.

$400 AUD dalam 7 hari

4,8

(5 ulasan)

2,6

@driverahz

Hello, I can develop your application. I'm a Freelance With 10 Years of Experience In Developing Applications On Ms Access For Small, Medium And Large Companies For Public And Private Sector.

$250 AUD dalam 5 hari

5,0

(1 ulasan)

2,3

@sreejithakaz

I have over 8 years of experience in Excel and Access VBA. I have developed several Tools, Automation, Dashboard and Online Tools using VBA. I have done a similar project in Access for a Mechanical Company using VBA and Excel.

$250 AUD dalam 10 hari

4,8

(2 ulasan)

1,0

@studio17

I already developed this kind of software, I am currently working here in Philippine General Hospital Manila, you may contact me at 09062040563 Philippines

$333 AUD dalam 10 hari

0,0

(0 ulasan)

0,0

@faitalsam

A proposal has not yet been provided

$554 AUD dalam 15 hari

0,0

(0 ulasan)

0,0

@minalouisfidodid

i have a very long experience in Access and did some kind of the same database you want in my home country for some business people.

$250 AUD dalam 10 hari

0,0

(0 ulasan)

0,0

@tdhmale007

Hello, Although you provide quite a detailed description of the type of database you're looking for, and having looked at the freelancers spreadsheet, I don't completely understand what freelancers has to do with workshops? So bearing this in mind, I would need to get a much better overall understanding of this project, after which my bid price and timeframe may change. As far as the overall structure of the database you propose, I don't see this as personally being a major issue to complete, as I have several years experience with developing database systems.

$388 AUD dalam 7 hari