Skip to main content

Worksheet Database – Powerful spreadsheet program to manage lists, projects etc

Worksheet Database is a free program that lets you to use spreadsheets in ways you never thought possible. The program allows you to create spreadsheets that has check boxes, drop down menus and date calendar, which you can use to create any kind of lists, manage projects, organize information, track inventories, etc.

Worksheet Database is built upon Microsoft Office Access and uses the Access database to store information, but on the front end what you get is a Excel like spreadsheet.

Worksheet Database comes with a number of pre-made templates which are easy to redesign. You can also create your own custom template within minutes. To see how the program works let’s use it to create a simple To-Do list.

1. Open the program and click on New.

1

2. You can see 6 different kind of data input boxes that you add to your worksheet.

2

Lets create a to-do list that has 4 fields:

  1. Task that needs to be completed
  2. Priority of the task
  3. Due date before which it needs to be completed
  4. Checkbox to mark task done

3. Click on the Checkboxes tab and type “Done” under Column Label against Check1

3

4. Move to Textboxes and type “Task” under Column Label against Text1

4

5. Next move to Dropdowns and type “Priority” under Column Label against Drop Down1

5

6. Finally move to Date and type “Due date” under Column Label against Date 1

6

7. Name your worksheet, say Todo, and click OK. This is how the worksheet looks initially.

7 

8. Now you can start adding items to the list. The textboxes function as normal Excel cells. The dropdown menus too allow addition of any values, but whatever you add gets added to the menu so that further addition of the same values becomes a matter of selecting it from the drop down.

8

The date boxes give access to a small calendar for adding dates.

9

You can add filters to your list to watch for specific inputs, sort your lists by name and even print them out on paper.

Try Worksheet Database yourself. You can use it in a lot of different ways. Here are the templates included with the program.

10

Comments

Popular posts from this blog

How to Record CPU and Memory Usage Over Time in Windows?

Whenever the computer is lagging or some application is taking too long to respond, we usually fire up task manager and look under the Performance tab or under Processes to check on processor utilization or the amount of free memory available. The task manager is ideal for real-time analysis of CPU and memory utilization. It even displays a short history of CPU utilization in the form of a graph. You get a small time-window, about 30 seconds or so, depending on how large the viewing area is.

How to Schedule Changes to Your Facebook Page Cover Photo

Facebook’s current layout, the so called Timeline, features a prominent, large cover photo that some people are using in a lot of different creative ways. Timeline is also available for Facebook Pages that people can use to promote their website or business or event. Although you can change the cover photo as often as you like, it’s meant to be static – something which you design and leave it for at least a few weeks or months like a redesigned website. However, there are times when you may want to change the cover photo frequently and periodically to match event dates or some special promotion that you are running or plan to run. So, here is how you can do that.

69 alternatives to the default Facebook profile picture

If you have changed the default Facebook profile picture and uploaded your own, it’s fine. But if not, then why not replace that boring picture of the guy with a wisp of hair sticking out of his head with something different and funny?