1 / 15

Create a Table and Define Fields in a New Blank Database

This guide outlines the process of creating and managing tables in a new blank Access database. You will learn how to create a table, define fields, and manipulate data in both DESIGN and DATASHEET views. Discover how to save changes, import data from sources like Excel, and organize objects within the Navigation Pane. It also covers using database templates for efficiency and modifications. Follow the tutorial to efficiently manage your database structures and enhance your data organization skills.

hayes-dudley
Télécharger la présentation

Create a Table and Define Fields in a New Blank Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Create a Table and Define Fields in a New Blank Database

  2. Create a Table and Define Fields in a New Blank Database

  3. Save and Close • When you close an Access table, any changes made to the records are saved automatically. • You will be prompted to save changes to design of the table or the layout of Datasheet view. • Saving the entire DB is a different action then saving a table or other object.

  4. Two views You can manipulate database tables in either DATASHEET view or DESIGN view. I usually use DESIGN view to create fields and their associated properties. Then use DATASHEET view to enter, modify, add, and delete records.

  5. Create a Table and Define Fields • You may use either table VIEW to: • Add fields • Rename fields • Change data types • Change field properties • I’ll demonstrate this in DESIGN view and the chapter tutorial will instruct you to do this in DATASHEET view. Both are fine!

  6. Create a Table In DESIGN View

  7. Create a Table • Adding data into fields for a record in a table must be done in DATASHEET view. Data is typed in just like data was entered in a Excel spreadsheet.

  8. Create a Table • Data may also be entered by Importing data from some other source (like an Excel spreadsheet.

  9. Change the Structure of Tables and Add a Second Table Browse for data to import and then allow import wizard to prompt you.

  10. Change the Structure of Tables and Add a Second Table • Adding a second table to a database by importing an Excel spreadsheet

  11. Create and Use a Queryvia Query Wizard

  12. Create and Use a Form and Report

  13. Create a Database Using a Template • A database template contains pre-built tables, queries, forms, and reports to perform a specific task. • You do not have to create the objects. • All you need to do is enter your data and modify the pre-built objects to suit your needs.

  14. Organize Objects in the Navigation Pane Objects include Tables, queries, forms, and reports

  15. Save and Close • When you close an Access table, any changes made to the records are saved automatically. • You will be prompted to save changes to design of the table or the layout of Datasheet view. • Saving the entire DB is a different action then saving a table or other object.

More Related