Press Enter twice. Type CD . Press Tab and type Certificate of Deposit . Press down arrow key and type Small Business Account . Close the tblAccountTypes table.
Relationships created among various objects enhance the functionality of the database.
In Microsoft Access, relationships are mainly created using the Lookup Wizard because the wizard takes care of a lot of issues behind the scenes. You can also use the Relationship window either to create relationships or to enforce them. To create a relationship between two tables, you have to use two field of the same data type, this is something the wizard can take care of behind the scene. Once you have decided how you want these fields to be related, drag the originating field to the child field. Microsoft Access will check some validation.