Windows 10 
Access 2003
Using Access 2000 here. I am attempting to create a database to manage a worldwide list of employees, phone numbers, address, building number, and city/state/country. I was given this data in the form of 3 different spreadsheets, each having a small part of the data.
One sheet has a list of all the buildings, with address, city, state, etc.
Another sheet lists all the phone numbers and the end user. This sheet also lists unused phone numbers on the corporate network.
A third sheet lists building, street address, user name (last and first in 2 fields), phone number, room number, and other pertinent data. This is the most comprehensive list of all data, but it is not complete.
Here is the constant info that never changes:
Building, room, cable number, address, city, state, state, country.
What does change is the phone number, user name
Formerly, people were entering data in some sheets, but not crossing over to tie everything together. And they info entered was inconsistent in the spelling. One record could have a building named Harrisburg1, and another record could have the same building referred to as hrsbrg1, or Hburg1. I want to use drop down lists to ensure the consistent accuracy of these fields.
Sometimes a user will be a telecommuter and not have an office, just a phone number with voice mail.
And also included in this are room numbers, names, and phone numbers for fax machines, modems, conference rooms, etc.
How should I start this new database from these spreadsheets? I have already imported each sheet into a separate table in the database. But I am now stuck with developing input forms and linking data from these various tables.
I need the ability to delete a phone number and user name when that user is terminated.
I need to move a user from one room or building or even country to another, sometimes taking their phone number with them (if on the same business campus) and if not then being assigned a new number.
I need to be able to create a new user, assigning them to a new room and phone number.
Does anyone have a recommendation as to where I can find tutorials/instruction on how to accomplish this?
Reply With Quote
