Click this button in the relationships window to display relationships in print preview.
Jan's Working with DatabasesYou finally have two tables that have a relationship. The relationship was created in a previous lesson with the Lookup Wizard (2007) or the Contacts Application Part (2010, 2013, 2016). Show
Access will recognize matching fields between tables in some cases. In other situations you will have to show Access what fields to match and what kind of relationship it is: One-to-Many, Many-to-Many, or One-to-One. Examples below are from starwars.accdb Relationships WindowAccess provides a special window for viewing relationships. No tables are shown automatically. You must pick which ones you want to see. Open the Relationships window: Database Tools > Relationships button Join lines connect the matching fields between tables. A line with a 1 at one end and the infinity symbol On the other side, Access will not let you delete records on the One side that are related to records on the Many side. If you really need to do that, you first have to remove the related records. It would be an unusual situation. Example: In the Star Wars Collectibles database, you want to delete a particular supplier from the table Suppliers. But, Suppliers is on the One side of a One-to-Many relationship with the table Star Wars Collectibles. If that supplier's SupplierID appears in a record in Star Wars Collectibles table, Access will not let you delete a supplier. You must remove the conflict. There are two choices: change the supplier in the records or remove all of the records that used that supplier. Only then you can delete the supplier. Be careful and thoughtful before making changes like this to records. Tossing data out can often cause trouble later on when you find that you needed that data after all. Ribbon: Relationship Tools: DesignEdit Relationships opens a dialog about the selected relationship. So you should click on a join line before clicking this button. Clear Layout removes all of the tables from the window, but no relationships are actually deleted. Relationship Report creates a printable version of the layout in the Relationship window. If a table has a scroll bar, then the fields out of sight will not print. Resize the display of the table first, then create the report. Show Table opens a dialog that lists all of your tables and queries. You can show any or all of them in the Relationships window. Hide Table removes the current table only from the layout and does not change any relationships. Direct Relationships shows the relationships to a selected table. A table that you hid in the Navigation Pane will not show here either. All Relationships shows all tables and all relationships, except those tables that you hid in the Navigation Pane.
Start with: mytrips-Lastname-Firstname.accdb from previous lesson View RelationshipsThere is a special window for viewing Relationships. Let's look at the relationship you created in a previous lesson.
Delete a RelationshipWhy would you want to delete a relationship? If you need to make changes to the table design, Access may not let you while there is a relationship to another table. Of course, you need to be careful that the relationship will still work after you make your changes! You will delete the relationship for practice and so you can recreate it manually.
Create a Relationship ManuallyTo create a relationship manually is a simple drag and drop action. You will create a new join between the two tables, but it will not be quite like the earlier one. So far you have only used a relationship as part of a Lookup field. But, the join type affects any queries that use both tables.
Print Relationship ReportThere is no print button in the ribbon tab for Relationship Tools: Design but there is a special button to create a printable report of the Relationships layout. What you see on screen is close to what you get in the report. If some fields are out of sight in the table's field list, they won't print either. You should arrange the layout before creating the report.
Edit SubdatasheetAs you saw in a previous lesson, a table that is in a One-to-Many or One-to-One relationship can show a subdatasheet of the related records from the other table. You can actually edit the records in the subdatasheet.
Test Referential IntegrityLet's see what Access will do
now that it must enforce referential integrity on your new join.
How are relationships indicated in the relationships window?A table relationship is represented by a relationship line drawn between tables in the Relationships window. A relationship that does not enforce referential integrity appears as a thin line between the common fields supporting the relationship.
How do you start the Lookup Wizard quizlet?How do you start the Lookup Wizard? Click in the Data TypeLookup Wizard column and choose from the drop-down list.
In which situation would using a one to one relationship be helpful?One-to-one relationships are frequently used to indicate critical relationships so you can get the data you need to run your business. A one-to-one relationship is a link between the information in two tables, where each record in each table only appears once.
Which of the following wildcard characters does access use in validation rules to match any number of characters?ANSI-89 wildcard characters
Matches any number of characters. You can use the asterisk (*) anywhere in a character string.
|