When connecting to an Access database, what entities are displayed in the navigator window?

When connecting to an Access database, what entities are displayed in the navigator window?

• A. Queries only
• B. Tables from the Access database
• C. Views only
• D. Stored procedures only

Answer: (B)

When connecting to an Access database, the navigator window displays tables from the Access database. This includes all the base tables that are created and managed within Access. Tables are the primary objects used to store data, and they contain rows and columns of data similar to a spreadsheet format. When you initiate a connection, Power BI identifies these tables and presents them for selection. This feature allows users to easily visualize and analyze data right from the Access database without needing to write SQL queries or perform extensive data preparation beforehand. While queries, views, and stored procedures are significant components of database systems, they either summarize data (queries), present data in a specific way (views), or encapsulate commands (stored procedures) that perform operations on the database. In the case of Access, the focus during the initial connection through Power BI is primarily on accessing the foundational data stored in tables, making them the key entities shown in the navigator window.

When connecting to an Access database, the navigator window displays tables from the Access database. This includes all the base tables that are created and managed within Access. Tables are the primary objects used to store data, and they contain rows and columns of data similar to a spreadsheet format.

When you initiate a connection, Power BI identifies these tables and presents them for selection. This feature allows users to easily visualize and analyze data right from the Access database without needing to write SQL queries or perform extensive data preparation beforehand.

While queries, views, and stored procedures are significant components of database systems, they either summarize data (queries), present data in a specific way (views), or encapsulate commands (stored procedures) that perform operations on the database. In the case of Access, the focus during the initial connection through Power BI is primarily on accessing the foundational data stored in tables, making them the key entities shown in the navigator window.