Microsoft Access 2003

Jitendra CDN Patel

Description

Microsoft Access is a Window based program created by Microsoft. It helps you store & manage a large collection of information.

A systematically arranged database helps you manage the stored information in an efficient way so that It can access quickly whenever needed.

You can easily create such a database using Access.

A good Database design ensure that you will be able to perform various tasks on it efficiently and accurately and without any hindrance.

Sujets

• Database Administration
• Computers
• Informatique
• Database

Informations

• Publié par: eBookIt.com
• Date de parution: 21 février 2013
• Nombre de lectures: 2
• EAN13: 9781456611910
• Langue: English

Extrait

Microsoft Access

Jitendra Patel
Overview

Microsoft Access: This book is specially written for those who are interested in using of Microsoft Access for developing database applications in the Computer Engineering and Information technology and Programmers to gain fundamentals knowledge about power of Microsoft Access in software development.
Also every one with interest in using Access for application development can refer this book to get the knowledge about Various features of this subject.
It covers virtually most of MS Access features and some of the advanced features like Hadnling Queries, Creating Forms, Generating Reprts, Exporting Database etc... including more than hands on examples tested thru MS Access 2003. Samples are presented in easy to use way and test.
Copyright © 2012 Jitendra Patel
All rights reserved. No part of this book shall be reproduced, stored in a retrieval system, or transmitted by any means, electronic, mechanical, photocopying, recording, or otherwise, without written permission from the publisher. No patent liability is assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein.
Warning and Disclaimer
Every effort has been made to make this book as complete and as accurate as possible, but no warranty or fitness is implied. The information provided is on an "as is" basis. The authors and the publisher shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this book.
Contents : MS Access Introduction to Database Database RDBMS Object of RDBMS Introduction to Access Access Getting Started Creating New and Opening Existing Database Creating DB using Database Wizard Creating DB without using Database Wizard Tables Introduction to table Creating table Table in design view* Working on tables* Description of design view Properties of fields Primary Key Switching view Entering data Manipulation data Relationships Handling Queries Introduction to query Creating a query in design view* Query wizards* Finding duplicate query Forms Creating form by using Wizard* Creating form by design view* Adding Records using A form Editing Forms Form Control Command Buttons* Reports Report using the Wizard* Creating report in Design view Printing Reports Importing exporting Importing Exporting Linking Sorting and Filtering Introduction Sorting Filter by Selection Filter by Form Saving a Filter Keyboard Shortkeys How to install MS-Access
MS Access Microsoft Access is a Window based program created by Microsoft . It helps you store & manage a large collection of information. A systamatically arrangeed database helps you manage the stored information in an efficient way so that It can access quickly whenever needed. You can easily create such a database using Access. A good Database design ensure that you will be able to perform various tasks on it efficiently and accurately and without any hindrance.
Introduction To Database Database Database is a collection of information or you can say it is hub of information For reteriving information we fall back on databases. With the help of database you can easily get information in structural form and You can easily search & update your information and easily change/modified your data in database. Most popular database management system( DBMS ) in market is like MS ACCESS . Microsoft Access provides users with one of the simplest and most flexible DBMS solutions on the market today. Regular users of Microsoft products will enjoy the familiar Windows "look and feel" as well as the tight integration with other Microsoft Office family products.
Introduction To Database RATIONAL DATABASE MANAGEMENT SYSTEM Suppose you have two two database-a database containging book detail and the other containing details of the company .Now you wish to display on the screen the information about the book A.and the details of the company which published it.What will you do to display the information?.you will display the name of company which has published the book A.Both these database were related.such a system is called is RDBMS (Relational Database Management System). RDBMS is defined as method of viewing information from several ,separate database that relate to one an another through keyword or values.The main advantage of relational database management system is that you can use simultaneously use more than one database to see information stored in them . Suppose customer wants to details of publisher any book so with the help of RDBMS the seller can give the detail of particular book.Most of the organization are using RDBMS because it provide facilty like you can add and delete your data also you can modified or update your data and easily find your data when you have large amount of data. RDBMS play important role in bussines marketing like a dealer who have data of customer and also want to data of customer daily purchasing details so with the help of RDBMS he can take data easily from database.
Introduction To Database OBJECT OF RATIONAL DATABASE MANAGEMENT SYSTEM Tables All data is stored in tables. When you create a new table, Access asks you define fields ( column headings ), giving each a unique name, and telling Access the data type. Use the "Text" type for most data, including numbers that don't need to be added e.g. phone numbers or postal codes. Using Wizards, Access will walk you through the process of creating common tables such as lists of names and addresses. Once you have defined a table's structure, you can enter data. Each new row that you add to the table is called a record. To define relationships between tables, click Database Tools | Relationships in Access 2007, or choose Relationships from the Tools menu in Access 95, 97, 2000, or choose Relationships from the Edit menu
Queries Use a query to find or operate on the data in your tables. With a query, you can display the records that match certain criteria ( e.g. all the members called "Barry" ), sort the data as you please (e.g. by Surname), and even combine data from different tables. You can edit the data displayed in a query (in most cases), and the data in the underlying table will change. Special queries can also be defined to make wholesale changes to your data, e.g. delete all members whose subscriptions are 2 years overdue, or set a "State" field to "WA" wherever postcode begins with 6. Forms These are screens for displaying data from and inputting data into your tables. The basic form has an appearance similar to an index card: it shows only one record at a time, with a different field on each line. If you want to control how the records are sorted, define a query first, and then create a form based on the query. If you have defined a one-to-many relationship between two tables, use the "Subform" Wizard to create a form which contains another form. The subform will then display only the records matching the one on the main form. Reports If forms are for input, then reports are for output. Anything you plan to print deserves a report, whether it is a list of names and addresses, a financial summary for a period, or a set of mailing labels. Again the Access Wizards walk you through the process of defining reports. Pages (Access 2000 - 2003) . Use pages to enter or display data via Internet. Pages are stored as HTML files, with data read from and written to the database. Michael Kaplan has published a to convert Access forms and reports into Data Access Pages. Macros An Access Macro is a script for doing some job. For example, to create a button which opens a report, you could use a macro which fires off the "OpenReport" action. Macros can also be used to set one field based on the value of another (the "SetValue" action ), to validate that certain conditions are met before a record saved (the "CancelEvent" action) etc. Each line of a macro performs some action, and the bottom half of the macro screen provides the details of how the action is to apply. Modules This is where you write your own functions and programs if you want to. Everything that can be done in a macro can also be done in a module, but you don't get the Macro interface that prompts you what is needed for each action. Modules are far more powerful, and are essential if you plan to write code for a multi-user environment, since macros cannot include error handling. Most serious Access users start out with macros to get a feel for things, but end up using modules almost exclusively. On the other hand, if your needs are simple, you may never need to delve into the depths of Access modules.
Introduction To Access Access Microsoft Access is a powerful program to create and manage your databases. It has many built in features to assist you in constructing and viewing your information. Access is much more involved and is a more genuine database application than other programs such as Microsoft Works. Microsoft Access can be used for personal information management ( PIM ), in a small business to organize and manage all data, or in an enterprise to communicate with server. Microsoft Access stores information in what is called a database. For now it is good enough to know that your data is put into a database and not worry about the details. We will be explaining databases and other key Access elements in a later lesson. There are four major steps to using Microsoft Access: 1. Database Creation: Create your Microsoft Access database and specify what kind of data you will be storing. A retail business might create a database to store all their sales information (i.e. items sold, customer, employee, commission, etc) 2. Data Input: After your database is created the data the stor