How Do You Add A Table To A Microsoft Access Database From Scratch?
The tables created by the Access wizard are not always what you want. Making a table from scratch allows you to customize the table more easily. These instructions are for Microsoft Access 97. Open your database in Microsoft Access. Use the F11 key to display the database view. Click the Table tab, then click New. A menu appears. Select “Database view” to create your new table. Click OK. Your new, blank data sheet opens. Rename the existing fields, giving them the names you want. Double-click in the Field label (it will turn black), then enter the name you want. If you need additional columns, click in the column to the immediate right of where you want your new column to appear. Then, from the Insert menu, select Column. Rename or move as desired. Enter your data in the data sheet. From the File menu, click Save. You’ll be asked if you want Access to create primary keys for your table. Click Yes unless you want to assign primary keys yourself. Open your database and switch to the Data
