Portland Microsoft Access Programming And Consultant Services

MS Access Programmer In Portland

Microsoft Access database services web pages for locating information about Accessible Data Solutions custom datbase development.

Here is an important term used in custom database development . . .

Filter

Databases are the primary entities for storing information, both for internet databases and desktop database systems. "Filtering" data is an important activity for locating precise data. Filter is a term that's used in data management. It is a command or routine that transforms data in accordance with this specific criteria. A filter passes the main part of data similar to an electrical filter. It may, for example, sort the data, remove extraneous delimiters or duplicate elements, convert codes, restrict numerical values, assign values to nulls, or perform other incidental operations. By extension it also means transforming data for display on the screen. Also importing by one application from another while, for example, retaining selected formatting commands, as from a spreadsheet to a database or from a word processor to a page layout program. It also refers to the specification of conditions for selecting records in a database operation. A filter may involve a range of values, illogical condition, or an attribute.

The previous information is from "The Database Dictionary", by Ellen Thro, 1990.

This page is brought to you courtesy of Microsoft Access, Access developer, Access programmer, Access database, Access programming, custom database, database services by Accessible Data Solutions featuring custom database development.

. . . Database development featuring Microsoft Access

Call 503-309-6691

For Free Consultation

Web Pages Sitemap

Locate Pages About Microsoft Access Database Services

+ More about starting your database project

Get the database you want from Accessible Data Solutions

Getting Started With Your Database page.

Database programmer service areas

Articles
- 2012
- 2011
- 2010
- 2009
- Access Blog
Projects
Testimonials
FAQs
Database Glossary
DB Questionnaire

Accessible Data Solutions
Specializing in Access
Database Development

Database Terminology

First Normal Form

Used in data management database systems. A normalized table. Abbreviated 1NF. First, second, and third normal forms are sufficient for most data management. The first normal form eliminates repeating groups. One criterion for the first normal form specifies that the table should faithfully represent the concept of a relation in our relational data model. In addition, and arguably the most significant defining criterion for the first normal form the table must be free of repeating groups. In order to faithfully represent the concept of a relation, table design must meet the following concepts of a relation in the relational data model: It describes one entity. The order of the rows and columns must be meaningless. No rows can be duplicated, thus requiring each table to have a primary key. Every column value contains one value that is appropriate for the attribute being described.

This material is found in "The Database Dictionary", by Ellen Thro, 1990 and "Microsoft Access Small Business Solutions" Hennig, et al, 2010.

This information compliments of " Microsoft Access, Access developer, Access programmer, Access database, Access programming, custom database, database services by Accessible Data Solutions featuring custom database development. "