<Li> Find and organize the information required - Gather all of the types of information to record in the database, such as product name and order number . </Li> <Li> Divide the information into tables - Divide information items into major entities or subjects, such as Products or Orders . Each subject then becomes a table . </Li> <Li> Turn information items into columns - Decide what information needs to be stored in each table . Each item becomes a field, and is displayed as a column in the table . For example, an Employees table might include fields such as Last Name and Hire Date . </Li> <Li> Specify primary keys - Choose each table's primary key . The primary key is a column, or a set of columns, that is used to uniquely identify each row . An example might be Product ID or Order ID . </Li>

To change the structure of a relation (table or file) what needs to be open in microsoft access