1 / 7

Introduction to Databases: Key Features of Microsoft Access

This chapter provides an overview of databases, specifically focusing on Microsoft Access. A database is a collection of data organized for easy access, retrieval, and use. Key features of Access include efficient data entry and updates, complex query capabilities for instant answers, customizable forms for attractive data representation, and advanced reporting tools for sophisticated data presentation. Additionally, Access supports web functionalities by allowing data to be saved in HTML format. Understanding records, fields, and unique identifiers like primary keys will enhance your proficiency with Access.

leo-larson
Télécharger la présentation

Introduction to Databases: Key Features of Microsoft Access

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