Question

If you needed to identify inventory items whose stock was running low, what Access tool could quickly find this answer?

When you're creating relationships,, what Access option allows you to protect your database from inconsistent data?

Which tab or object should be selected if you want to create a data screen or user interface that would allow you to add, modify, or delete existing records?

Answer 1

1Q Answer:

In order to maintain, monitor and search data from a database is very difficult there are so many tools and software’s that are designed to organize all the information in a well-defined format. In that one of the best source to add, delete and find the data is Access tool.

The information that needs to be identified in different ways in Access tool. The “Query” option in access tool is used to identify the related information.

To find the specific data quickly, use queries to identify the data in a very less time. Write a specific query to identify the data.

· Open the data that wants to review and on the create tab, click query design.

· In show table, Identify the products in the inventory table

· On the design tab, click Run the particular query runs and displays the data.

2Q Answer:

While creating relationships it’s very important to secure the database from inconsistent data. The “Encrypt with password” is the option that is used to protect the data from all inconsistent data.

3Q Answer:

In Access where we can create multiple tables and do changes as per the requirement. That is, we can add the new data, modify the data and delete the existing data.

In the Table tools tab, select the particular data table where we need to add the data, modify the data or delete the existing records.