# How could I make much easier the experience with the order of my database?

I would like to make easier the way I use this program to organize the profile data of my employees in a simple database that I can just to look for each one easily and with no scrolling down throught all of the document

##### Post Metadata
- Posted at: about 7 years ago
- Author title: Executive Director at Importsjyr Computer Services. 
- Net upvotes: 1


## Comments
### Comment 1

You are talking that you would like have an interface with a scroll button to data in 1 or more tables. So not using the Sqlserver management studio. You do that stuff in an application on top of the database. Such stuff is not possible in Sqlserver. You need to use other features like a report generator or build an application in VBA. 

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: Database Developer



### Comment 2

You can create a unique view that will extract data from the different tables using a primary key, as the ID of each employee and show everything you want to see on the screen, without needing to go down

##### Comment Metadata
- Posted at: almost 7 years ago
- Author title: Profesional en libre ejercicio 



### Comment 3

You can create different tables with your employee information eg employee table, employee roles etc. Then you can create a single view that will pull data from the different tables using a primary key

##### Comment Metadata
- Posted at: almost 7 years ago
- Author title: Software QA Tester (ISTQB, OCA, OCP)



### Comment 4

If you have SQL knowledge you can generate queries to obtain the specific data you're looking for based on selected criteria.

##### Comment Metadata
- Posted at: almost 7 years ago
- Author title: IT Manager




## Related Product
[Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews)

## Related Category
[Relational Databases](https://www.g2.com/categories/relational-databases)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4