1 / 21

Database Essentials

Database Essentials. Lesson 1. Software Orientation. Getting Started.

morna
Download Presentation

Database Essentials

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 Essentials Lesson 1

  2. Software Orientation

  3. Getting Started • A database is a tool for collecting and organizing information. For example, as a database, a phone book organizes a large amount of data—names, addresses, and phone numbers—so you can access it by name in alphabetic order.

  4. Getting Started • A computerized database management system (DBMS), such as Microsoft Office Access, enables you to easily collect large volumes of data organized into categories of related information. This type of database allows you to store, organize, and manage your data, no matter how complex it is, andthen retrieve and present it in various formats and reports.

  5. Start Access When creating a new file ALWAYS click the yellow folder to save it in your folder.

  6. Step-by-Steps • Go to StudentApps\CBA Data\MOAC data files\ Access\Lesson01 in My Computer. • Right-click on Student Information and choose Copy. • Browse to your CBA folder, right-click and Paste. • Right-click and Rename to Student Information1 - # username. Then double-click to open. • The header is automatic in Access and will include your filename. This is the only way to get your name on your file in Access.

  7. Opening an Existing Database

  8. Software Orientation

  9. Software Orientation • Objects • Table—the most basic database object that stores data in categories

  10. Software Orientation • Objects • Forms—control data entry and data views, and provide visual cues that make data easier to work with

  11. Software Orientation • Objects • Queries—allow you to search and retrieve the data you have stored (ask a question of the database) • Which students’ last names begin with C?

  12. Software Orientation • Objects • Reports—present your information in ways that are most useful to you

  13. Using Object Tabs • When you create a database in Access, all the objects in that database—including forms, tables, reports, queries—are displayed in a single window separated by tabs. Tabs help keep open objects visible and accessible. Tabs

  14. Changing Views • A datasheetis the visual representation of the data contained in a table Design View allows you to change the structure of the database.

  15. Design View • Data types • Text • Date/time • Auto-Number • Number • Currency • Etc • Properties • Field Size • Format

  16. Defining Data Needs and Types • Purpose • Categorize information • Break each piece of information into the smallest useful part • Last Name • First Name

  17. Review Data Types (pg. 23)

  18. Review Data Types (continued)

  19. Defining Database Tables • Tables are the most basic organizational element of a database. • Not only is it important to plan the tables to hold the type of data you need, but also to plan how the tables and information will be connected. • Even if it’s the only object in a database, there MUST be at least one table.

  20. Changing Views • Switch back to Datasheet view

  21. Records and Fields Each column is a field. • Each row in a table is called a record. • Each column in a table is called a field. • A primarykey is a column that uniquely ­identifies each row, such as Item Number or ID. Each row is a record.

More Related