1 / 11

Database

Database. ACCESS. Database. A series of objects used to enter, manage, and view data. Table. Organizes the data of customers, inventory, etc. that’s broken down into individual units of information. Field. A single unit of information about a person, place, item, or object. Primary Key.

amethyst-randall
Télécharger la présentation

Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database ACCESS

  2. Database A series of objects used to enter, manage, and view data.

  3. Table Organizes the data of customers, inventory, etc. that’s broken down into individual units of information.

  4. Field A single unit of information about a person, place, item, or object.

  5. PrimaryKey • The field by which the table is sorted whenever the table is opened. • One field is designated as the primary key. • The primary key field must contain unique data for each record, such as account number.

  6. Record A collection of fields about a person, place, item, or object.

  7. Query • Extracts data from one or more tables. • It selects some of the fields from the table(s) to display or print rather than viewing all fields in a datasheet.

  8. Validity Checking each entry to reduce errors and ensure that only valid information is stored for the customer.

  9. Report Print or view a tabular layout for datasheets or forms. Create a report when you want to specify which fields to print and have more control over the report layout and format.

  10. Filter • Used to view only those records that meet specified criteria. • Example: you may want to view only those records of suppliers in one state.

  11. WorksCited Rutkosky, Seguin, Rutkosky, Marquee Series Office 2007, Paradigm Publishing 2008.

More Related