Question: how to create a relational database in excel?
Answer: Click the Create button and the Create Relationship dialog box appears. Under Table, click the down arrow and choose Sales from the available tables list. Under Column (Foreign), click the arrow and choose Sales ID from the field list.