database essentials n.
Skip this Video
Loading SlideShow in 5 Seconds..
Database Essentials PowerPoint Presentation
Download Presentation
Database Essentials

Loading in 2 Seconds...

play fullscreen
1 / 21

Database Essentials - PowerPoint PPT Presentation

  • Uploaded on

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

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Database Essentials' - morna

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
getting started
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.
getting started1
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.
start access
Start Access

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

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.
software orientation2
Software Orientation
  • Objects
    • Table—the most basic database object that stores data in categories
software orientation3
Software Orientation
  • Objects
    • Forms—control data entry and data views, and provide visual cues that make data easier to work with
software orientation4
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?
software orientation5
Software Orientation
  • Objects
    • Reports—present your information in ways that are most useful to you
using object tabs
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.


changing views
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.

design view
Design View
  • Data types
    • Text
    • Date/time
    • Auto-Number
    • Number
    • Currency
    • Etc
  • Properties
    • Field Size
    • Format
defining data needs and types
Defining Data Needs and Types
  • Purpose
  • Categorize information
  • Break each piece of information into the smallest useful part
    • Last Name
    • First Name
defining database tables
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.
changing views1
Changing Views
  • Switch back to Datasheet view

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.