microsoft access presentation

Project Presentation

Group D

Maryam FarooqMaryam Farooq L1S09BBAM0029L1S09BBAM0029

Maryam RiazMaryam Riaz L1S09BBAM2116L1S09BBAM2116

M AbdullahM Abdullah L1S09BBAM0028L1S09BBAM0028

Asad RazaAsad Raza L1F08BBAM0206L1F08BBAM0206

Rabia AijazRabia Aijaz L1F07BBAM0220L1F07BBAM0220

Members Introduction

Roadmap

Origin IntroductionHistoryFeaturesComponents of a DatabaseSome Extras

Origin

Office for Windows and Mac

Release of Microsoft Access

Introduction

History

Version 1.1 release

Version 2.0

New Version of Windows

Access included in Office Suite

History

Compatibility

Database Market

Other info.

Features

Creating tables and queries

Import and export of data

Jet Database format

Compatibility with SQL

Features

Offers parameterized queries

Desktop editions of SQL

File server based database

Extras

Stores data in its own format Import or links to data in other

databases VBA support A rich programming environment

Uses

Used to create simple database solutions Includes query interface, forms and

reports An advanced solution for non-

programmers Template to quickly enhance databases Create solutions using VBA Database solutions

Development Storage of Database Components Query Designer Pass-Through Queries Programming Language Database Libraries Leszynski Convention Other info.

Protection

Access Security

Database Password

Workgroup Security

Locking through .MDE

Competing Software’s

Alpha Five Borland Paradox Microsoft SQL Lotus Approach Openoffice.org Base Oracle XE Omnis Studio etc.

DatabaseWhat is a Database?

A Sample Database

Creating a Database

Components of a Database

EntityCollection of information about

a particular topic Field

Anything about information is kept

RecordColumn of tables in databases

Components of a Database File

Collection of related tables Table

Medium (object) used to define and store data

AttributesCharacters of entity

Components of a Database Query

Statements that extract specific info from database

FormObject of Database to enter

data Report

Used to present data in a more formatted way

Components of a Database Logical Design

ERDDiagram indicating how

entities are connected to each other

Types of Keys Primary Key

Attribute that uniquely identifies a row or a record

Secondary KeyNon-unique field that is used as a

secondary (alternate) key Concatenate Key

Consists of two or more data elements or attributes

Types of Keys

Control Key Used to physically

sequence the stored data Foreign Key

An attribute in a table whose values must match a primary key in another table

How to create a Database?

Process of creating a database can be completed in two ways:

With Template

Without template

Getting started with a database

Creating without template

Choosing a Blank Database

Renaming & Saving

Saving

Choosing the location of your choice

Creating a table

Changing Views

Choosing Views

Changing Views

Saving Tables

Widening Columns

Setting Primary Key

Set primary key

Entering data in Design View Fill in according to your choice

Saving

Microsoft Office Button

Saving

Other ways

Use Ctrl+S or the diskette button to save quickly

To change view i.e. datasheet view

Exiting Access

Click Office Button

Choose Exit Access

Entering data into a database

There are two methods for entering data into a database :

Datasheet View Method

Form View Method

Creating data with a template Let me practically present…