Download
Skip this Video
1 / 7
Access Chapter 1 - PowerPoint PPT Presentation
- 93 Views
- Uploaded on
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
Download Presentation 
An Image/Link below is provided (as is) to download presentation
PowerPoint Slideshow about 'Access Chapter 1' - leo-larson
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.
While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
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
- Ask complex questions concerning the data and receive instant answers
- Forms
- Produce attractive forms for representing data
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.
Records
- A record contains information about a given person, product or event.
- Rows in tables are called records
Field
- A field contains a specific piece of information within a record.
- Columns in the tables are called fields
Unique Identifier
- A client number
- Example – Social Security Number
- Also known as a Primary Key
