View SQL database data in a similar way to the Access database

Asked

Viewed 69 times

0

Good afternoon gentlemen

I am a layman in the subject of SQL database and I am trying to visualize the data of an SQL database in table form, below is the name database E3 already created being viewed by SQL Express software, it is possible to view the data from this database in table form similar to how it is done by Microsoft Access? Thanks for your help!!

inserir a descrição da imagem aqui

I am already familiar with database in Access, I created a database in SQL but I’m having difficulty analyzing the tables of the database, I can do this easily in Access

Exemplo de visualização de dados pelo Access

mysql sql database sql-server ms-access

  • If none of the interfaces available for your DBMS met your needs you can always connect to your database using MS Access and an ODBC connector.

  • 1

    Vitor, you can expand the table node, right-click on a table and then try the options "Select n upper rows" and "Edit n upper rows"

  • Thank you @Imex, you know some SQL server course or path I can go through to understand a little more about SQL server?

  • 1

    Sorry, I’m gonna owe you

1 answer

0

Good night

I was able to visualize the data in table form by pressing the right mouse button on the table file and selecting the option Select 1000 top lines follows image below

inserir a descrição da imagem aqui

Browser other questions tagged mysql sql database sql-server ms-access

You are not signed in. Login or sign up in order to post.