Access 2007: Setting Up Tables & Fields

TL;DR

This lesson provides step-by-step instructions on creating a database in Access, starting with the books table and then adding customers and orders. It also covers field setup and table organization.

Transcript

In our previous lesson we focused on designing our database. We said that we wanted a customers table, an orders table, and books table. So let's start by creating our books table. I could have started with customers, orders or books, but in this case I think it makes sense to start with books since we need to have our inventory of books before our... Read More

Key Insights

• 🚰 Database design in Access generally starts with creating tables, and it is recommended to begin with the table that forms the foundation of the database.
• 😒 Access provides options to create a new database from scratch or use built-in templates.
• 🗯️ Tables can be renamed by right-clicking on them in the Navigation Pane and selecting the Rename option.
• 🏑 Fields can be added, reordered, and deleted within a table, providing flexibility and customization.
• 🫵 Access offers different views, including Datasheet view and Design view, each serving specific purposes in data entry and design.
• 🏑 The data type of a field can be set to ensure appropriate data entry, such as changing the data type of a "price" field to currency.

Questions & Answers

Q: Why is it suggested to start with creating the books table?

Starting with the books table is logical because we need to have an inventory of books established before customers can place orders. It ensures that the necessary information is available for the ordering process.

Q: How can I change the name of a table in Access?

To change the name of a table, right-click on the table in the Navigation Pane and select Rename. If the table is open, you'll receive a prompt to close it first. Type the desired name and press Enter to save the changes.

Q: Can I have multiple tables in an Access database?

Yes, you can have multiple tables in an Access database. To create additional tables, go to the Create tab, select Table in the Tables group, and save the new table with a unique name.

Q: What is the purpose of the ID field in each table?

The ID field, set to AutoNumber, assigns a unique number to each record in the table. It helps in identifying and distinguishing each entry within the table and is a good practice to give it a unique name in each table for clarity.

Summary & Key Takeaways

• The lesson begins by explaining the importance of designing a database and suggests starting with the books table as it is necessary for the inventory. Access is opened, and a blank database is created.

• The books table is created first, followed by the customers and orders tables. Fields are added, renamed, reordered, and deleted as necessary.

• The lesson introduces both Datasheet view and Design view, explaining the benefits of each. The data type and formatting of fields are also discussed.

• The lesson concludes by mentioning the importance of linking tables to build relationships in the relational database.