Access Lesson 2 Creating a Database

Access Lesson 2 Creating a Database

Access Lesson 2 Creating a Database Microsoft Office 2010 Introductory 1 Creating a Database The Access Lesson 2 2 first step in creating a database is to create the file that will store the database

objects. When you use a template to create a database, the template creates the database and the objects, which can be queries, reports, tables, or forms. Microsoft Office 2010 Introductory Creating a Database (continued) The Access Lesson 2 3 Blank database template creates a database with an empty table in it.

After specifying the file name and the location in which to store the database, click the Create button to create and open the new database. When you create a blank database, Access opens an empty table in Datasheet view so that you can start entering data. Microsoft Office 2010 Introductory Creating a Database (continued) Creating a new, blank database Access Lesson 2

4 Microsoft Office 2010 Introductory Creating and Saving a Table Access Lesson 2 5

When you create a blank database, Access creates the first table in the database for you. To save a table, click the Save button on the Quick Access Toolbar. In many databases, data is stored in more than one table. Microsoft Office 2010 Introductory Designing a Table After Access Lesson 2 6 creating a table in a database, you

need to tell Access which fields to include in the table. When you create a blank database, the table that Access creates for you contains one field named ID. Access sets the ID field as the tables primary key. Microsoft Office 2010 Introductory Designing a Table (continued) In Access Lesson 2 7 a table, the primary key is the field that

contains a unique field value for each record. In some tables, this field is called an AutoNumber because it automatically adds a unique number to the primary key field for each record in the table. Each record number after this will be incremented by 1. Your data might already have a field that stores unique numbers for each record. Microsoft Office 2010 Introductory Designing a Table (continued) A Access Lesson 2 8

fields data type determines the kind of data that you can enter in the field, such as: Numbers or text A combination of numbers and text (also called alphanumeric data). Microsoft Office 2010 Introductory Designing a Table (continued) Common data types in Access

Access Lesson 2 9 Microsoft Office 2010 Introductory Working in Design View In Access Lesson 2 10 Design view, you can add, delete, and make changes to the way that fields store data.

The field names and data types appear in the design grid in the top half of the Table window. The bottom half of the Table window is called the Field Properties pane. The properties for a field depend on the fields data type. Microsoft Office 2010 Introductory Working in Design View (continued) Applicant table in Design view Access Lesson 2

11 Microsoft Office 2010 Introductory Working in Design View (continued) In Access Lesson 2 12 Design View, you can add and delete fields, and drag fields to new locations. Any changes that you make in Design view are automatically updated in Datasheet view when you save the table. The Description property is an optional field

property used to describe what to enter in the field. Microsoft Office 2010 Introductory Changing Field Properties in Design View When Access Lesson 2 13 you set a fields data type, the field is given certain properties. A field property describes a fields contents beyond the fields basic data type, such as the number of characters the field can store

or the allowable values for a field. The Field Size property sets the number of characters you can store in a field. Microsoft Office 2010 Introductory Changing Field Properties in Design View (continued) Use Access Lesson 2 14 the Format property to specify how you want Access to display numbers, dates, times, and text. The Default Value property enters the same

field value in a field every time a new record is added to the table. The Required property specifies whether you must enter a field value in a record. Microsoft Office 2010 Introductory Task Open Access Lesson 2 15 the Access Employment Table Design task and complete the requested design and print using the supplied directions when complete

Microsoft Office 2010 Introductory

Recently Viewed Presentations

  • Apresentação do PowerPoint - WordPress.com

    Apresentação do PowerPoint - WordPress.com

    XNA fornece um tipo de Texture2D que contém uma textura 2D (flat) a ser desenhado no visor. As classes do jogo precisa conter uma variável para armazenar a textura de bola que será desenhada quando o jogo é executado.
  • Vocabulary Workshop - levittownschools.com

    Vocabulary Workshop - levittownschools.com

    Vocabulary Workshop Unit 7: #'s 1-20 www.vocabularyworkshop.com authorize (v.) to approve or permit; to give power or authority to Synonyms: order, entitle, empower I wonder if Congress will someday authorize U.S. citizens to cast official votes over the Internet.
  • Open Educational Resources (OER) at Peralta

    Open Educational Resources (OER) at Peralta

    open educational resources (oer) at peralta. building a community of practice. district flex day, thursday, august 16, 2018. planning team: andrew park, heather dodge, jenny yap, lilia celhay, cady bow, yiping wang, and tim hackett
  • PERSONIFICATION You need: A pencil, eraser, highlighter and

    PERSONIFICATION You need: A pencil, eraser, highlighter and

    Punch Up Writing with Personification. PURPOSE: To show that personification is a figure of speech that gives human qualities, such as speech, feelings, behavior, to something that doesn't have these qualities.
  • Demonstration Speech

    Demonstration Speech

    Students must follow formal speech structure from lesson #2 and must incorporate the use of at least one prominent visual aid.. The purpose of the visual aid is to discourage you from using a word-for-word manuscript (it is difficult to...
  • Kein Folientitel - Team 358

    Kein Folientitel - Team 358

    Pneumatic Gripper Solution Pneumatics is excellent for providing the gripper functions on your robot. Here, two pneumatic cylinders open and close the gripper arms at the touch of a button on the Innovation controller. ... Work along with the kids...
  • Analyzing a Text Rhetorically Definition of a Text

    Analyzing a Text Rhetorically Definition of a Text

    Textual Analysis Analysis Breaking something down into its essential parts to understand how and why those parts work together to accomplish something (what + how and why) Versus "summary" (what) Importance of structure Looking at the relationship between the parts...
  • File Organizations and Indexing - Simon Fraser University

    File Organizations and Indexing - Simon Fraser University

    Overview of Storage and Indexing Chapter 8