Create, Scan, Compare and Update QR Codes in an Access 2007 or 2010 Database
$30-250 USD
Fechado
Publicado há mais de 10 anos
$30-250 USD
Pago na entrega
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
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 could do this project to your specification in Access 2010 (plus runtime developer version of QR barcode driver). Please view my portfolio for some examples of my work.
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 copies if you so desire. U can expect quality work in time.
Thanks
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 forward to work with you! .....Thanks!!
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 private message below.
Thanks
Mohan Paramane