1 / 31

MS ACCESS 2010

MS ACCESS 2010. What is Database?. A database is a collection of data that is organized so that its contents can easily be accessed , managed, and updated. EXAMPLES OF DATABASES. What is Access?. ACCESS is a relational database management system.

melita
Download Presentation

MS ACCESS 2010

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. MS ACCESS 2010

  2. What is Database? • A database is a collection of data that is organized so that its contents can easily be accessed, managed, and updated.

  3. EXAMPLES OF DATABASES

  4. What is Access? • ACCESS is a relational database management system. • Relational databases allow you to organize your data into tables • Each table focuses on a specific topic; the various tables can then be linked to each other for inquiry and reporting purposes.

  5. Database Objects

  6. Database Objects • Microsoft Access uses four objects to create a Database: • Tables • Queries • Forms • Reports

  7. Table • A table is the basic element of a Database and contains the data entered by users. • Each row (or record) contains information about a particular item (e.g., an employee). • The record is made up of several fields; each field contains one piece of information relating to the item (e.g., employee's name, address, phone, etc.).

  8. Query • A query extracts selected data from a table (or another query) and presents it in spreadsheet format.

  9. Form • A form is a graphical template based on a table (or query). • It is used to enter new data into the database or display existing data.

  10. Report • A report extracts selected data from a table (or query) and formats it for printing.

  11. What is a Table? • A table is a database object used to store, organize and view data. All other objects are based on the data stored in tables. • Tables are comprised of: • Fields - represented by columns • Records - stored as rows.

  12. Data Types

  13. Text • Any character (alpha, special characters, numbers) • Up to 255 in length • Numbers cannot be used for calculations

  14. Memo • Any character (alpha, special characters, numbers) • Up to 65,000 in length • Numbers cannot be used for calculations • Field cannot be sorted or indexed

  15. Number • Numeric data to be used for mathematical calculations • Not to be used for currency fields • Field Size property further defines its function and size

  16. Date/ time • Must be a valid date/time entry at entry time • Format property determines display format

  17. Currency • Accepts monetary values with a dollar sign and decimal point. • It can be used for computations

  18. Lookup • Creates a field that lets you look up a value from another table or from a list of values.

  19. Attachment • Stores graphics, sound and other types of files attachments.

  20. Hyperlinks • Stores a value that contains a hyperlink. • Clicking the value activates the link and opens a webpage or addresses a message to an email address.

  21. Yes/No • Stores Yes/No, True/False or On/Off Values

  22. Auto Number • Adds a unique numeric field value to each record in a table.

  23. Calculated • Opens the Expression builder dialog box which lets you specify fields and operators to use in calculations.

  24. Field Properties

  25. Field Size • Sets a maximum size for data • Varies according to Data Type:

  26. Input Mask • Controls the way data is entered; frequently used for telephone numbers, postal codes, SSN #’s, date/time fields. • ACCESS offers a Wizard for text and date/time data types.

  27. Caption • You specify text for the label attached to a field; • Will be used as the column heading when displaying tables, queries and reports. • The default value is Field Name.

  28. Default Value • Specifies a value that will be automatically entered when you create a new record.

  29. Input Mask Characters

  30. Primary Key • The primary key of a relational table uniquely identifies each record in the table. • It can either be a normal attribute that is guaranteed to be unique (such as Social Security Number in a table with no more than one record per person.

More Related