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

HIT - Microsoft Access

A review of database keywords and concepts.

AB
FormsThese provide a quick and easy way to view
TableA collection of information about a specific topic.
QueryThis asks a database to find information that meets the criteria or condition you specify.
Primary keyOne or more fields that uniquely identifies each record in a table.
RelationshipThis tells Access how to bring together related information stored in separate tables.
FieldA column in a table
ReportA database object you can use to perform calculataions such as averages on.
Database windowYou can use this to view and work with all the objects in your database.
ToolbarsContain buttons that help you perform common tasks quickly.
RecordA collection of information about one person, place, or thing.
FieldA specific category of information in a table..
Field NameIdentifies the information in a field.
Table WizardHelps you quickly create a table that suits your need.
OrientationDetermines which direction information prints on a page.
Datasheet ViewDisplays all the records in a table. Allows you to enter, edit and review records.
Design ViewDisplays the structure of a table.
Data TypeDetermines the kind of information you can enter in a field.
Field PropertiesA set of characteristics that provide additional control over the kind of information you can enter in a field.
Field DescriptionThis helps you remember what information to enter in a field.
Text Data TypeAccepts entries up to 255 characters long that include text and numbers.
Autonumber Data TypeAutomatically numbers each record for you.
Memo Data TypeAccepts entries over 255 characters long that include text and numbers.
Number Data TypeAccepts numbers you want to use in calculatiions.
OLE Object Data TypeAccepts objects created in other programs, such as documents, spreadsheets, pictures, and sounds.
Date/Time Data TypeAccepts only dates and times.
Hyperlink Data TypeAccepts hyperlinks you can select to jump to another document or web page.
Currency Data TypeAccepts only monetary values.
CaptionYou can use this instead of a field name.
Default valueA value you want to appear automatically in a field each time you add a new record.
Validation ruleHelps you reduce errors when entering data by only accepting data that meet certain requirements.

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