Database Need - Will Azure Work?

Question

I have a need for a database with a user interface that is like a "form", where users will input information about an "item" and will also link this "item" to "services" and vice versa (linking services to items when inputting services). I want the user to then be able to search an item or a service and return all of the items/services linked to what was searched and I wan that return to be in a form format. Is this something Azure could do? I feel like this is probably a very beginner question, but I don't know the first thing about databases so any information is appreciated!

Answer 1

Databases do not have forms. Forms are provided by applications. To help you understand how they fit together you can try Microsoft Access; it will help you become familiar with the technology. An Access database does have forms and queries as well as tables so that can make things confusing but generally speaking forms are considered to be separate from databases.

There are many database systems; SQL Server is one of them. In Azure you can have one or more SQL Server databases and a beginner like you can consider a SQL Server database in Azure to be the same as a SQL Server database in your local computer. In Azure however there are very many other things you can have.

You need to learn better what your needs are. To get better help in a forum such as this you need to be able to explain your needs better. There are many ways you can create forms to be used with a database. The best solution for someone else might be lousy for you. Do you need to provide something for use only within an organization that is connected by a local network? Or do you need to provide something for use only by personnel of an organization but accessible over the internet? There are many possibilities. The most important thing for you to do is to determine your requirements and you do not need to be technical to do that.

Answer 2

Thank you for your information/help, I'm sorry for my lack of clarity in explanation. I tried just doing open-ended research but figured a forum would be better because I'm so un-clear on what it is exactly that I'm looking for (i.e. forms vs. databases).

So from what you're saying, I need to find a database solution along with an application that works with that database option for data entry. The organization is connected by a local network, so doesn't need to be accessible over the internet. The organization has 100-150 employees. Based on the function I'm looking for - would Access be a potential option? Or would I need something more complex? Thank you again!