It also features portfolio management tools, as well as advanced analytics and reporting functions to afford stakeholders greater visibility and control over projects.Īccessible online MS project tutorials are available to ensure users maximize the platform’s benefits.
MICROSOFT ACCESS 2013 TUTORIAL 1 REVIEW ASSIGNMENTS SOFTWARE
Microsoft Project is project management software that helps users manage projects, resources, and budgets. Next we're going to modify our query so we can look at some of the other things we can do with queries.Increase productivity with Smartsheet. We didn't want to see a big list of customers that haven't ordered anything yet. But that didn't stop the pesky sales person from adding her name into the database! She simply expressed interest in buying a space ship. Well actually, Marge is only a potential customer.
she doesn't have a corresponding record in the Orders table). If you look back at the Customers table (near the top of this page), you'll see that Marge Simpson is a customer but she hasn't ordered any products yet (i.e. If a customer is in the Customers table but does not order a product, that customer's record will not be displayed in the results of this query. This query will only return those customers who have ordered at least one product. The query has automatically joined the three tables using the relationship that we created and returned the matching data. You can also see that some customers have ordered more than one product. Our query successfully returns a all customers who ordered at least one product and it includes the product and its price next to their name.
Select all three tables and click Add, then click Close: The Show Table dialog box will appear with all of our tables listed.Ensuring you have the CREATE tab open on the Ribbon, click Query Design.Now let's create a query that returns the names of all customers who have ordered a product. If you hadn't enforced referenctial integrity, Access would have happily let you enter the meaningless values and the referential integrity of your database would have flown out the window. Note that you will only get this message if you have enabled Enforce Referential Integrity.
In this case I tried to enter a CustomerId of 50 and a ProductId of 50, but my Customers and Products tables don't have a CustomerId of 50 or a ProductId of 50: If you had enforced referential integrity on the relationship (as we have), Access would prevent this from happening.īelow is a screenshot of what will happen if you attempt to enter a value that would breach referential integrity. In this case, referential integrity has not been maintained. Using our tables as an example, let's say you have 10 records in the Customers table (with a CustomerId of 1 to 10), but your Orders table contains a record using a CustomerId of 11.
This prevents foreign key values from having no corresponding primary key value in the referenced table. When you create a relationship, you also have the option to Enforce Referential Integrity (which we selected when we created our relationship).
0 kommentar(er)
