create a database in excel

Microsoft Excel 2010 - complete product...
July 30, 2013 at 13:47:24
Specs: Windows 7
i need to create a database in excel with a switchboard to other options. i need it so that multiple users can access and update at once.

See More: create a database in excel

Report •


#1
July 31, 2013 at 05:52:39
You have not provided very much information so there's not much help we can offer.

The only specific item that we can address is the "multiple user" item: Excel workbooks can be "Shared", allowing multiple users to access/edit them at the same time.

Under the Review tab, you will find a Share Workbook option.

Other than that, "i need to create a database in excel with a switchboard to other options" is too generic for us to work with.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
August 1, 2013 at 12:13:59
I'd recommend using Access if you need to create a database with Switchboards. I agree with DerbyDan. If you provide more details, we may be able to help you.

Report •

#3
August 1, 2013 at 12:30:26
Scenario. i need to be able to use a spreadsheet as a database due to not having MS access (works computers), i need it so that multi users can update in real time but still remain in control of the list that it will produce.
the spreadsheet has several columns that have drop down menu/lists and also 4 columns that auto complete from entering two different dates in two other columns, column 1 = date, column 2 = name, column 3 = Insurance number (2alpha+6numbers+1alpha), columns 4,5,6 and 7 auto complete in date format, column 8 = date 1, column 9 date 2. (these form the two dates that columns 4-7 use) column 10 = completed by and date.

date 1 minus date 2 = column 4+13 weeks
date 1 minus date 2 = column 5+26weeks
date 1 minus date 2 = column 6+39weeks
date 1 minus date 2 = column 7+52weeks


Report •

Related Solutions

#4
August 1, 2013 at 13:54:08
sorry i dont have access to MS Access on the works computer

Report •

#5
August 1, 2013 at 15:27:12
OK, so you've provided some detail about the spreadsheet layout, but I still don't know what you are asking for help with.

What is it that you do not know how to do?

I also don't know what you mean by this information:

date 1 minus date 2 = column 4+13 weeks
date 1 minus date 2 = column 5+26weeks

date 1 minus date 2 is going to return a specific value. How are you forcing it to equal column 4 + 13 weeks? Are you asking for a formula to calculate one of the dates?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

#6
August 5, 2013 at 13:39:46
Date Actioned Surname Customer Number Age Range Alpha Team 13 26 39 52 Leaving Reason Start Date End Date days
05/08/2013 Bloggs 1234 18-24 Team 3 31/05/2013 30/08/2013 29/11/2013 28/02/2014 Going to Work 02/03/2013 05/08/2013 156
18-24 Team 1 Holiday UK
25-49 Team 2 College
50+ Team 3 Holiday Abroad
Under 18 Team 4 Relocating
Team 5 Going to Work
Team 6 Spare
Team 7
the first line is a sample, the lines under are the drop down list . I do have an excel sheet set up with the above. i am wanting to change the spreadsheet into a database, mainly because its getting to be a monster of a sheet. i have about 14 spreadsheets that have to be collated into a single pivot table (no problems there) it would make it easier if work had MS Access but i only have Excel to work with

Team 8
Spare


Report •

#7
August 5, 2013 at 13:44:36
looking at it now all the data is not how i entered it but if it would help i could send an excel sheet. i have tried attaching one here but it does not work


Report •

#8
August 6, 2013 at 04:07:45
re: looking at it now all the data is not how i entered

Perhaps you somehow missed the blue line at the bottom of every one of my posts that clearly states:

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Had you followed the instructions found via that link, your data would have remained as you entered it.

re: i am wanting to change the spreadsheet into a database.

I don't know what that means. Excel is not a database application. You can't "change" a spreadsheet to a database.

What is your definition of a database vs. a spreadsheet as far as what you are trying to accomplish?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •


Ask Question