12.5: Creating an Access Table

Last updated
Save as PDF

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}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

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

PRactice Question

https://assessments.lumenlearning.co...essments/18750

Contributors and Attributions

Creating an Access Table. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution