How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Steve Herrod Your Own Question
Steve Herrod
Steve Herrod, Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 3315
Experience:  Trained in Microsoft Office from 2000 through to latest version 2010.
65126503
Type Your Microsoft Office Question Here...
Steve Herrod is online now
A new question is answered every 9 seconds

looking for help in design a basic microsoft access database

This answer was rated:

looking for help in design a basic microsoft access database for improcessing and outprocessing customers from an organization. Also would like to have the ability to add features on the database

Steve Herrod :

Hi, I'll be happy to help with this - can you let me know the full list of requirements?

Steve Herrod :

Cheers

Steve Herrod :

Steve

Customer:

First name, middle initial, last name, date of birth, social security number, address, date arrived on station, certification date and renewal date, and a requirement section where i can list items the member has to get done before leaving the organization. I want to be able to create additional tabs as i think of other things that we need. Also i want to be able to produce a report from the access product to review monthly of any member that is overdue on a requirement

Steve Herrod :

Thanks - and is there already data to go into the database in some form?

Customer: No sir starting from stratch so we can put a John Doe in there for now
Steve Herrod :

Ok - I'll start putting something together

Steve Herrod :

This would be the shell for some data - do you have any idea of the requirements? Could this be a set list of 5 for example that can then be selected once completeD?

Steve Herrod :

I've created a form as well to assist with data entry but it's all 100% modifiable

Steve Herrod :

Cheers

Steve Herrod :

Steve

Customer:

Steve,

Customer:

steve, i have a mac when i tried downloading the access database it didnt open. Is this database compatible with all operating systems? also these are the remaining fields i would like to add?

Customer:

Degree


Social Security #


NPI #


Specialty


Facility Arrival Date


Facility Departure Date


Credentialing Effective Date


BCBS Provider #


Special Notes/Comments


 

Steve Herrod :

I don't think Access is available on a Mac

Steve Herrod :

so it would probably need to be in another format

Steve Herrod :

difficult to think of a similar package which is available on the Mac as well

Steve Herrod :

unless you can run virtual Windows in some way?

Customer:

we are going to try it on a windows based machine i will let you know later

Steve Herrod :

no problem - let me know if you can view it, the other fields are easy enough to add

Customer:

didnt work can we try again?

Steve Herrod :

what happened - didn't it load in Microsoft Access on the windows PC?

Steve Herrod :

what version of office does it have?

Customer: We have office 11
Steve Herrod :

ok - that is Office 2003 so the file type will need to change

Steve Herrod :

will convert it and send in a couple of minutes

Steve Herrod :

try this version

Steve Herrod :

Cheers

Steve Herrod :

Steve

Steve Herrod and other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions