1 / 7

Access Chapter 1

Access Chapter 1. Database. Describes a collection of data organized in a manner that allows access, retrieval, and use of that data. Key Features of Access. Data entry/update Easy mechanism for adding, changing, and deleting data Queries

leo-larson
Download Presentation

Access Chapter 1

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. Access Chapter 1

  2. Database • Describes a collection of data organized in a manner that allows access, retrieval, and use of that data

  3. Key Features of Access • Data entry/update • Easy mechanism for adding, changing, and deleting data • Queries • Ask complex questions concerning the data and receive instant answers • Forms • Produce attractive forms for representing data

  4. Key Features of Access Cont. • Reports • Makes it easy to produce sophisticated reports for presenting data • Web support • Allows you to save as HTML format and use on the web.

  5. Records • A record contains information about a given person, product or event. • Rows in tables are called records

  6. Field • A field contains a specific piece of information within a record. • Columns in the tables are called fields

  7. Unique Identifier • A client number • Example – Social Security Number • Also known as a Primary Key

More Related