2. On the tab in the Relationships group, click Relationships.
3. On the Relationship Tools Design tab in the group, click Show Table.
6. Click and drag the from a table and drop it on the primary key of the other table.
7. In the box, make sure the correct fields are being linked.
What characteristics should be determined to design a relational database? Check all that apply.the fields neededthe tables neededthe keys and relationshipsthe purpose of the databaseall of the tables in the databaseall of the records in the databasethe queries, forms, and reports to generate
When determining the statement of purpose for a database design, what is the most important question to ask?
What is another name for the one-to-many relationship?
What view would you use to create a database without focusing on the data?
What options are available in the Lookup Wizard? Check all that apply.label the fieldsort the recordsfilter the recordsadjust the column widthadjust the header heightreduce the number of columnsset where to get lookup field values
Which rules are part of referential integrity? Check all that apply.The tables must use a junction table.The primary table must have a primary key.The tables must belong to the same database.The related fields should have the same data type.The related fields should be combined as a composite key.The destination table must be linked through its primary key.
Why is it important for developers to be careful when using cascading deletes?
1. Click the tab.
3. Double-click .
4. In the Edit Relationship dialog box, add a check mark next to .
Did you find these answers helpful?