Closed

Create, Scan, Compare and Update QR Codes in an Access 2007 or 2010 Database

We are looking for a system in MS Access / VBA with the following functionality for the purpose of handling large volume conference registration, validation and management of records using QR codes.

1. A screen for us to create, edit, delete, copy (from existing) a new conference event

a. When a new conference event is created, the following information is requested:

- Event ID

- Name of event

- Maximum number of attendees

- Name Venue

- Venue Address

- Date & Time

- Dress Code

b. When an existing conference is edited the above fields can be changed except for the Event ID

c. Delete the event, to be able to delete the whole event from the database and all associated transactional records with that event if any

d. Copy the event, to be able to create a new Unique Event ID and copy the event details from an existing event

3. Master Attendee Database

(The following are fields required Unique Attendee Number, First Name, Last Name, Email Address, Designation, Mobile Number, Agency Name, Generated QR code for this attendee (based on Unique Attendee Number, First Name, Last Name, Mobile Number, Email Address, Agency Name) Graphic Assigned, Remarks

a. Allow for the creation, deletion, modification of each attendee record

b. Allow for the mass update of new attendees in CSV Format

(i) Upon import if the record exist based on the same Email Address, to replace the details in the current database record with that from the CSV File

while retaining the Unique Attendee Number

(ii) If record does not exist, to create the new record

Note that for the mass update, if there is an update or creation of new record, the QR code will need to be regenerated and stored in the database

c. Search function to be able to search for an attendee by First Name, Last Name, Mobile Number, Designation, Agency Name, Email Address

4. Conference Attendance Management

a. Select a current available conference, search and display the list of attendees by either Agency Name, Email Address, Mobile Number, First Name, Last Name and add to be able to add all or a marked attendees to that conference

b. Query a current conference and be able to add or delete current attendees tied to it

c. Generate a PDF copy of an E-Registration Invite with QR Code for a Single Attendee by First Name, Last Name, Mobile Number or Email Address

(1 entry only)

d. Generate a PDF copy of an E-Registration Invite with QR Codes for all attendees from a single agency name to be selected from a list

(Multiple entries for that agency in sheet)

5. Conference Check In

a. Allow for the registration of the attendee by scanning his E-Registration QR Code

(Once a QR Code is scanned and used to register captured in the system, it cannot be used again. for that event)

b. Allow for the manual registration of the attendee by being able to search using First Name, Last Name, Mobile Number, Email Address, and update the attendees record for that event that he is registered

c. Report on the attendance for a particular event in XLS

(i) Summary of attendees vs. registrations in XLS

(ii) List of all attendees column wise containing the attendee's information, and each attendee record by row in XLS

Skills: Microsoft Access

See more: access 2007 code, create code access, scanning codes access database, generate code database record, add access, code create database record, generate code access database, generate code access, create codes access, codes access 2007, scan code update database, add code access database, codes access, access 2007 code search, add code access vba, code access database, mass add email list, csv codes, conference attendee list pdf, vba codes, microsoft vba, ms access 2010, vba e, vba compare, time and attendance

About the Employer:
( 0 reviews ) Singapore

Project ID: #4821615

10 freelancers are bidding on average $319 for this job

MarlinSoftware

Hi, Thank you for your detailed specification, I am a developer with over 23 years experience building complex database systems, specialising in the development of applications in MS Access using VBA and WinAPI. I coul More

$750 USD in 20 days
(13 Reviews)
4.9
winnet21

Hi, I have experience with this project, I happily if work with you in this project. Best Regards

$250 USD in 13 days
(11 Reviews)
4.8
KellogITSolution

Hello Me an Ms-Access Expert working on MS-Access & VBA for the past 12 years. I am ready to do your work and could start right now. I have already done a no. of successful Access Projects and can provide u sample c More

$155 USD in 3 days
(25 Reviews)
4.4
toxicman

Hello, I can prepare solution

$147 USD in 3 days
(1 Review)
2.8
web2printexpert

1. We have big experience in MS Access, Excel, Word, Visual Basic, VBA, Visual [url removed, login to view], C# , Crystal Reports and MS SQL 2. We have developed pure MS Access applications, applications that uses MS SQL as DataBase a More

$277 USD in 3 days
(1 Review)
2.8
elboukharimu

I can help you please check your Inbox.

$263 USD in 12 days
(1 Review)
2.4
aerobace

Hello, I'm very keen on your project. Please PM for further information

$670 USD in 10 days
(1 Review)
1.0
sanskar

I am experienced software developer.I can give you best quality application as per your requirements.I have gone through your requirements ,I assure the project to be completed on time with good Quality. looking forwa More

$166 USD in 6 days
(0 Reviews)
0.0
pnjadhav

Dear Hiring Manager, I am working in IT sector for last 12 years starting from Junior Programmer-Senior Programmer-Tech Lead-System Analyst and [url removed, login to view] my technical skills and deliverable or technical sup More

$277 USD in 7 days
(0 Reviews)
0.0
MohanParamane

Hi, We are Pune (India) based firm developing softwares and websites since 1996. We will complete your project in time. We provide online support for softwares and websites and customer satisfaction is our goal. Read More

$222 USD in 3 days
(1 Review)
0.0
hbxfnzwpf

I am very familiar with Access and other office files, i am expert in VBA, please let me do this.

$157 USD in 6 days
(0 Reviews)
0.0