Opening Databases. Once you've created a database, it's easy to open it later. The first step is to go backstage; choose File→Open. There you'll see a list of all the databases you've viewed. Determine the purpose of your database. Find and organize the information required. Divide the information into tables. Turn information items into columns. Specify primary keys. Set up the table relationships. Refine your design. Apply the normalization rules.