About creating a table (MDB)
Note The information in this topic applies only to a Microsoft Access database (.mdb).
To create a blank (empty) table for entering your own data, you can:
- Use the Table Wizard to choose the fields for your table from a variety of predefined tables such as business contacts, household inventory, or medical records.
- Create a table in Design view, where you can add fields, define how each field appears or handles data, and create a primary key.
- Enter data directly into a blank datasheet. When you save the new datasheet, Microsoft Access will analyze your data and automatically assign the appropriate data type and format for each field.
To create a table from existing data, you can:
- Import or link data from another Access database or data in a variety of file formats from other programs.
- Perform a make-table query to create a table based on data in a current table. For example, you can use make-table queries to archive old records, to make backup copies of your tables, to select a group of records to export to another database, or to use as a basis for reports that display data from a specific time.