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

Working With Databases

MS Access

AB
databaseA tool used to organize, store, retrieve, and communicate groups of related information.
fieldsis a grouping or category of similar information contained in a table; a unique identifier for a category of information.
recordis a group of fields such as all the information about the person, including first name and last name, addres, postal code, telephone number, and so forth.
field nameto help identify the fields.
design viewallows you to work with the underlying structure of your tables, queries, forms, and reports. ...
datasheet viewdisplays data in a row-and-column format.
cellthe intersection of a row and a column is called a
entrywhen you enter data into a cell.
field propertiesspecifications that allow you to customize a field beyond chosing a data type.
tableswhere all database information is stored, and stores data in columns and rows.
queriessearch for and retrieve data from tables based on specified criteria.
formsallow you to enter records in a custom format.
reportsdisplay data in a custom format.
pagesenables you to design other database objects so they can be published on the web.
macrosenables you to perform a series of operations with a single command.
Filterallows for retrieval of information that meets specific criteria
Filter by selectionfilters for information related to an active cell
Filter/Advanced Sorttype of filter that defines specific search criteria
Sortsenables information to be arranged in a specific order such as alphabetically, chronologically, ascending, descending......
Field sizeused to control the size of the field, measured in characters
Formatused to control the layout of the field, such as one or two decimal places
input maska field property that regulates how data is entered in a cell.
Captionfield property for column naming that allows a more user-friendly and properly formatted field name


Mac Williams Middle School
NC

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