Office Space Rentals

[JudithJubilee]

Hello there,

I have 5 sites around the UK each containing office space units of various
sizes and controlled by a different team.
I need to design a database(s) to include all tenant/space/rental details.
This will eventually be secured with different permissions.

2 questions:

1. Does anyone know of any examples online that I could have a butchers at?
2. More specifically would people create 1 big database with all the sites
and then allow certain people access through permissions. OR would you split
it up into a database each - 1 per the 5 sites?

Thankyou in advanced for your help and suggestions

Judith

 

[Jeff Boyce]

Judith

Will each site operate independently of the others? Will you have a need to
"consolidate" the data from all sites?

How are the sites connected (electronically) now, if at all?

How "user-proof" do you need the application to be? What is your level of
experience with Access? With relational database design/development?

As you can tell, there are a few (and several more) questions still
unanswered. Answers to these help the folks here in the newsgroup offer
more specific suggestions.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[JudithJubilee]

Hello Jeff,

Thanks for replying so soon.

Little bit of history. I am an applications trainer in Microsoft packages so
I have a pretty good understanding of Access - queries, tables,
relationships. However, I only have a brief understanding of VBA - although I
am more than willing to give anything a go! I know what it can do and have
experimented with lots of pre done examples (mostly linked to from this
site!!)
I have set up a few databases to get others started but this is my first
foray into totally creating one!

Answers:

1. The sites will operate independently for most of the time although there
will be a definate need for consolidation for Rental amounts, dates when Gas
meters etc need to be checked company wide, and overall profit calculations.

2. The sites at the moment are all connected via Outlook but apart from that
they are mostly paper based. They have the tenants fill out a Word form
non-electronically and then someone adds that info to various Excel
spreadsheets. Very time-consuming and crying out for Access!

3. I need it to be generally secured: as in most people will not see the
Profit calcs but most will be able to add new tenants, query for relevant
properties, etc.

4. I need it to be user-friendly as the people who will be using this are
mostly beginners in Access. However, I need it to be customisable for others
to add other queries on the fly.

I hope this answers the q's. If there is anything else you need me to tell
you ask away!

Thanks again

Judith

 

[Jeff Boyce]

Judith

The newsgroups are great for help with specific questions. It seems like
you have a much more general need to design/develop an application.

My questions were intended to prompt you for more of the "system
requirements" that you'd need in order to design/develop an application, or
to "shop" the specs to other developers.

Have you check Google.com for the possibility that there are already
applications out there doing what you need?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[JudithJubilee]

Hello Jeff,

Thanks again for your quick response.

The company are looking at alternative bespoke packages, however I feel that
Access can give them everything they need and with a bit of training they can
themselves change the specs of the database instead of paying someone else to
change it as and when they need to do so.

My main question was how to lay out the database.
I would have thought it would be easier to put them all in one database
rather than have 5 seperate ones.

However, I've had some great answers and have given some pretty good anwsers
myself over the years so I LOVE this forum. In fact I reccommend it to all my
delegates.

I have the basic knowledge to create the database(s) but as I have no real
experience with creating one from start to finish I thought I'd ask the
higher powers!

To start mainly I just need advice on whether to do 1 or 5 different
databases and combine the results either into a main database or by exporting
the relevant info into Excel and getting them to work from there?

Cheers

Judith

 

[Jeff Boyce]

Judith

If you will be trying to consolidate data from all sites, consider checking
into "Replication". There's a newsgroup dedicated to that specific topic.
The basic concept is that you'd keep a "master" copy and distribute
replicated versions, then merge them all back in, periodically.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/