Quia Home Home FAQ About Log in Subscribe now 30-day free trial
Java Games: Matching, concentration, word search, and flashcards.

Fun With Microsoft Access

Introduction to usign Microsoft Access--a Database Application


AB
Microsoft AccessThe database management system in Microsoft Office
Databasean organized collection of facts about a particular subject
Access Databasethe electronic equivalent of a manual database
Database Objectsthe tools you need to store, maintain, search, analyze, and report on the data in your database
Tablea datasheet
Forma format that displays one record at a time; used to enter or update data
Querya structured way to tell Access to retreive data that meets certain criteria from one or more database tables
Reporta formatted way to display information retrieved from the database
Recorda set of details about aspecific item
Fieldeach column in a table; headed by a field name
Field Namethe heading for a field
Field Contentsspecific data contained in each field
Data Typetext with a default Field Size of 50 characters
Field Descriptionan optional field that helps you describe the field and that can be viewed by the user
Primary Keythe fieldused to efficiently select information from different tables within a database; must be unique to each record