• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating a searchable database

K

Khanzaki

New Member
Hi to all,


I have browsed this site a lot and found many useful things one of it was "using

excel as database" spreadsheet . I wanted my worksheet to be same like that ...as I am completely novice when it comes to writing vba or macro Is there any one who could modify the codes of the workbook according to mine In my worksheet there are column A to G

which contains Companies name , Date ,Invoice number, Amount ,Dues on, Due date passed ,and no. of days past due.

I need drop down (which will be basis of sorting out data ) of Companies name ,Due date passed(Y/N).
 
Good Khanzaki


On the Forum home page there are the Green Sticky's you say you have browsed the site a lot but seemed to have missed them, try this one. :)


http://chandoo.org/forums/topic/posting-a-sample-workbook
 
bobhc said:
Good Khanzaki


On the Forum home page there are the Green Sticky's you say you have browsed the site a lot but seemed to have missed them, try this one. :)


http://chandoo.org/forums/topic/posting-a-sample-workbook
Click to expand...

Hi Bobhc,

I have gone through this forum and have seen your useful responses and contributions.
As a follow up to Khanzaki's questions, I have similar challenge. I am trying to build a cost database where all cost information on projects, equipment, labour rate, man-hour, other price, lists etc. can be stored and accessed easily by my team members.

I down loaded the 'searchable database' demo and need to modify the user interface form and fields but I dont know how to go about it. Specifically, I need to change 'Product', ' Region', 'Customer type' to say Job Titile, Job Value, 'Date'.

Kindly advise.

Dan
 
Excel is good, very good, but people seem to think it is the be all and end all of data manipulation, it is not, nothing to stop you going down the excel road, but if I was in your shoes I would use a relationship data such as Access. Far more secure and users do not have access to the data tables.
 
bobhc said:
Excel is good, very good, but people seem to think it is the be all and end all of data manipulation, it is not, nothing to stop you going down the excel road, but if I was in your shoes I would use a relationship data such as Access. Far more secure and users do not have access to the data tables.
Click to expand...

Bobhc,

I agree with you but I feel the easiest way to meet my present requirement is to be able to amend the sample template.

Nonetheless, will access allow multiiple users to use the database cocurrently and can it be deployed as enterprise application?

In any case, I will appreciate any solution.

Cheers!
 
The beauty about Access is that it is a relationship database unlike Excel which is a flat data sheet, unable to collect and deal with data as Access can and present it as a report to whoever when ever.
The data is split with the tables on a server (the backend ) and the form ( the front-end ) on individual desktops, by being the designer of the form you can restrict what they can input, but more importantly, what they cannot delete ( nothing, keep all input data for future reference, to delete data is a sin, and one day you will curse yourself if you have deleted that bit of data some numb nut middle manager wants ). All they see is the form not a full worksheet, you can design the reports and queries to run and display any data need, for more robust that Excel in this way.
You can if you so wish to have users enter data into Excel and then import it into Access.
 
As with any software there is a learning curve, but Access is one of the most widely used databases so finding materials to help out there.

http://office.microsoft.com/en-us/a...ucture-of-an-access-database-HA001213954.aspx

http://599cd.com/site/courselist/access2010/

http://databases.about.com/od/tutorials/ss/splitaccessdb.htm

This link MUST be read if you are going to use a true database, normalization is crucial to the smooth running of a database

http://db.grussell.org.uk/section008.html

http://support.microsoft.com/kb/304932

http://www.gcflearnfree.org/

Chandoo is in the process of developing an Access forum, but I am not sure when this is done to go live.
 
You must log in or register to reply here.
Back
Top