Jump to content

Stargazers Lounge Uses Cookies

Like most websites, SGL uses cookies in order to deliver a secure, personalised service, to provide social media functions and to analyse our traffic. Continued use of SGL indicates your acceptance of our cookie policy.

Jkulin

Acquisition and Target Database

Recommended Posts

I have tried looking and can't find a commercial database for storing my acquisitions and planned targets, I currently use a multi tabbed Excel Spreadsheet, but hate the scrolling and format layouts.

Now I'm sure that many well versed people on here could do far better than me, but over the Christmas period I sat down and created an Access database, it's nothing special but seems to suit my needs, I'm not brilliant at this but if anyone wants a copy of the blank database then would be happy to let you have a copy.

image.png.a8a2d1c14ec2f8fcca0101be7925b125.png

image.png.7675cb4d35709604705cc9fc1e6e1e2f.png

I wanted to create a database where I didn't have to scroll all over the place and would fit on my laptop screens as well when out in the field.

If anybody wants to add anything to the database then feel free and share on here so others can see.

As I say, it's just a very simple database that you might find useful.

  • Like 4

Share this post


Link to post
Share on other sites

Well, if you can put the data into Access, you could try importing it into SQL Server Express 2017 (https://go.microsoft.com/fwlink/?linkid=853017), its free & can support databases up to 4GB. You could then keep your Access and or Excel sheets as application windows into the data, or if your feeling very brave, you could write a simple Web front end....

Share this post


Link to post
Share on other sites

Hi Julian, I'm just a simple soul, and just did something basic and practical for my needs, I can write web basic sites, but I'm not anywhere in the league of your good self.

Share this post


Link to post
Share on other sites

Nice job that, John.

I put together our main business database in our office using Filemaker, which is just a standard relational database, and I found the hardest part to actually be the GUI.  I'm not a particularly artistic person, so it took ages to come up with a layout which would work across all the sheets.  Looks like you've done well on that front with a simply but inviting interface.

Share this post


Link to post
Share on other sites

Cheers Ray, I'm far from artistic, just wanted to get a simple doorway to storing my info. The GUI wasn't complicated.

I'm just surprised that there wan't anything written out there that could have done something so much better.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.