Java Games: Flashcards, matching, concentration, and word search.

Access Lesson 2: Creating a Database

Key Terms

AB
Alphanumeric dataData that that is a combination of numbers and text.
AutoNumberautomatically adds a unique number to the primary key field for each record in the table.
Blank database templateCreates a database with an empty table in it.
Data typeDetermines the kind of data that you can enter in the field, such as numbers or text
Default Value propertyEnters the same field value in a field every time a new record is added
Description propertyAn optional field property that you can use to describe what to enter in
Design gridIn Design View, the field names and data appear in the top half of the table window.
Design viewcan add, delete, and make changes to the way that fields
Field Properties paneIn Design view, the bottom half of the Table window
Field propertydescribes a field’s contents beyond the field’s basic data type
Field Size propertysets the number of characters you can store in a
Format propertyhow you want Access to display
Primary keyThe field that contains a unique field value for each record in the table.
Required propertySpecifies whether you must enter a field value in a record.
Templatecreates the database


Programming Instructor
Nation Ford High School
Charlotte, NC

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities