Skip to main content
Business LibreTexts

12.5: Creating an Access Table

  • Page ID
    46618
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)

    Learning Outcomes

    • Create a new table

    You can add new tables to an existing database by using the commands in the Tables group on the Create tab. Access will automatically create a new table with a table structure built in. Access will also set the field types based on the data entered. The new table will be automatically displayed in Datasheet view, allowing you to take immediate action, i.e., enter change field names, set properties, and enter data directly in to the table.

    An alternate way to create a new table is to select Table Design in the Tables group. Access will create a new table and display it in Design View. This approach provides a more traditional albeit manual method of setting the details of the table.

    Microsoft Access "Create" button in toolbar selected.

    Learn More

    For detailed, step-by-step instructions Microsoft Access Help is an excellent resource and can be found by following this link: Creating Tables Access Help

    Contributors and Attributions

    CC licensed content, Original
    • Creating an Access Table. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution

    12.5: Creating an Access Table is shared under a CC BY license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?