ms access ppt presentation download

• My presentations

Auth with social network:

Download presentation

We think you have liked this presentation. If you wish to download it, please recommend it to your friends in any social system. Share buttons are a little bit lower. Thank you!

Presentation is loading. Please wait.

Lecture Note 9: Introduction to the MS Access

Published by Betty Wells Modified over 8 years ago

Similar presentations

Presentation on theme: "Lecture Note 9: Introduction to the MS Access"— Presentation transcript:

Database Basics. What is Access? Database management system Computer-based equivalent of a manual database Makes it easy to organize and update information.

MS-Access XP Lesson 1. Introduction to MS-Access Database Management System Software (DBMS) Store data in databases Database is a collection of table.

Benchmark Series Microsoft Access 2010 Level 1

 Use the Left and Right arrow keys or the Page Up and Page Down keys to move between the pages. You can also click on the pages to move forward.  To.

Microsoft Office 2010 Access Chapter 1 Creating and Using a Database.

Access - Project 1 l What Is a Database? –A Collection of Data –Organized in a manner to allow: »Access »Retrieval »Use of That Data.

Chapter 1 Databases and Database Objects: An Introduction

1 An Introduction to IBM SPSS PSY450 Experimental Psychology Dr. Dwight Hennessy.

Automating Tasks With Macros

XP New Perspectives on Microsoft Office Access 2003, Second Edition- Tutorial 2 1 Microsoft Office Access 2003 Tutorial 2 – Creating And Maintaining A.

COMPREHENSIVE Access Tutorial 2 Building a Database and Defining Table Relationships.

Creating And Maintaining A Database. 2 Learn the guidelines for designing databases When designing a database, first try to think of all the fields of.

Office 2003 Introductory Concepts and Techniques M i c r o s o f t Access Project 1 Creating and Using a Database.

FIRST COURSE Access Tutorial 2 Building a Database and Defining Table Relationships.

HIBBs is a program of the Global Health Informatics Partnership PETE HANKE & JESSICA COTE INDIANA UNIVERSITY – PURDUE UNIVERSITY – INDIANAPOLIS SCHOOL.

COMPREHENSIVE Excel Tutorial 8 Developing an Excel Application.

Access Tutorial 10 Automating Tasks with Macros

Advanced Tables Lesson 9. Objectives Creating a Custom Table When a table template doesn’t suit your needs, you can create a custom table in Design view.

XP New Perspectives on Microsoft Access 2002 Tutorial 41 Microsoft Access 2002 Tutorial 4 – Creating Forms and Reports.

Introduction to Access By Mary Ann Chaney and Alicia Harkleroad.

About project

© 2024 SlidePlayer.com Inc. All rights reserved.

• Preferences

Microsoft Access PowerPoint PPT Presentations

Microsoft Access

Mar 20, 2019

650 likes | 1.29k Views

Microsoft Access. A Hands-On Introduction Chapter 1. What is Microsoft Access?. A Windows software application. An application development environment. A data organizer. A collection of Information tools. A R elational D ata b ase M anagement S ystem. All of the above.

Share Presentation

• natural order
• major objects
• multi user system
• true relational database model

Presentation Transcript

Microsoft Access A Hands-On Introduction Chapter 1

What is Microsoft Access? • A Windows software application. • An application development environment. • A data organizer. • A collection of Information tools. • A Relational Database Management System. • All of the above.

What is a Database? • A Database is a collection of information organized for a specific purpose. An example might be information about a movie collection. A telephone book is another example. In a given day you might use many objects that could be considered databases.

What is a Database? (contd.) • In Access, we work with what is called a Relational database. Access is an RDBMS. The term Relational means that each table in the database contains information about a single subject and only that subject. Each table however will typically be related to one or more other tables. An example would be a Customers table related to an Orders table. More on this later.

Types of Databases Flat file: like a spreadsheet Flat files are limited in their use Used for less complicated databases Waste disk space as the complexity increases Customer Ship method Invoice Invoice Item Quantity Unit cost date number number Mendenhall Steel UPS Blue 12/1/05 229901 B4500 2 $2.33 Mendenhall Steel UPS Blue 12/1/05 229901 C2134 4 $3.45 Mendenhall Steel UPS Blue 12/1/05 229901 Z2344 6 $342.33 Mendenhall Steel UPS Blue 12/1/05 229901 M4098 8 $12.98 Mendenhall Steel UPS Blue 12/1/05 229901 Q1243 10 $132.33 Mendenhall Steel UPS Blue 12/1/05 229901 P0918 12 $134.95 Gerrity Lumber FedEx 12/1/05 229902 P0918 1 $134.95 Gerrity Lumber FedEx 12/1/05 229902 M4098 2 $12.98 Gerrity Lumber FedEx 12/1/05 229902 C2134 3 $3.45

Types of Databases (Contd.) Relational: Contain information that spans multiple topics or subject tables. Use common information to link the subject tables. Use less disk space. Are more complex to design than flat-file systems. Are more efficient in terms of Data extraction.

Access as an RDBMS • With an RDBMS, you have complete control over how you define, work with and share data. • There are three types of capabilities provided; data definition, data manipulation, and data control. • You can use an Access database as either a desktop database serving one user or as a table sharing database on a network serving many users. • Access is also useful as a front-end to a client/server database such as SQL Server or Oracle. • The possibilities are endless!

Data Definition • You define what Type of data is stored in your database. For example text or numbers or a combination of both. • You define how the data is related. • You may also define how the data is formatted and how it is validated. • You also determine the level of data integrity desired.

Data Manipulation • In Access, you can work with your data in many ways. • You can select which data fields you want. • You can sort the data and filter it. • You can work with multiple tables using relationships that you have defined. • You can summarize data, update and delete data and also copy it to another database if you wish.

The Data Control feature allows you to define who may read, update and insert data. This functionality also allows you to define how data can be shared and updated by multiple users at the same time. A true RDBMS is designed such that if users are sharing data, no two users can be updating the same record concurrently. Another feature is the ability to create transactions which are multi-step processes where all steps either succeed or fail. This ensures data integrity. Data Control

When Is Access Appropriate? As a self-contained system A fully functional desktop database system for a single user or for multiple non-concurrent users on a standalone computer. As a networked multi-user system A multi-user system using Access MDB database files shared on a network file server. Supports record locking and refreshing. As a front-end to an external database system A front-end control system for ODBC-compliant databases. Supports Structured Query Language (SQL) calls. ODBC = open database connectivity

How Access interacts with Windows • Access is a visual design tool. -- Supports all Windows design standards. -- Drag and Drop support. -- Supports all Windows Menu standards. -- Is part of Microsoft Office so works seamlessly with all Office applications. -- Includes the Visual Basic Programming language.

How is Access visual? • Most Access objects are created with visual design tools. • These designers work in a way that could be described as a Computerized Erector Set. • Another set of tools available are called Wizards. Wizards simplify object creation via a multi-step question and answer process. • Wizards are a great tool for creating objects such as tables, queries, forms and reports. • The end result is maximum creation for minimal work.

To Summarize • How would you best describe Microsoft Access? • What are some examples of databases you might use in the everyday world? • What does RDBMS stand for? • What is the non-relational type database called? • Using Access as a front-end means what? • Access is part of what software suite? • Now that you have a general idea of what Access is and how it works with databases, let’s take a closer look at its parts. • We will learn about the major objects contained in Access and then drill down and discover how it works with data.

What are the major objects. • An Access database or MDB file contains seven major objects. -- Forms Visual interfaces for display and acceptance of data. -- Tables Created with simple point and click, drag and drop functionality.

Major objects (Contd.) -- Queries Objects that provide views of data from one or more tables. Created with sophisticated visual Query by Example tool. -- Reports Similar to forms but designed for hard copy output. Like Queries, also created with visual design tools.

Major objects (Contd.) -- Data Access Pages Similar to forms, however are accessed by user with a Web browser. -- Macros Provide some rudimentary programming. -- Modules VBA code that provides additional capability beyond the other main objects.

Major objects (Contd.) • More difficult design tasks must be done with manual coding. • Responding to special types of user input. • More complex data validation. • Creating buttons and toolbars that respond in special ways. • Bulk processing of records. • VBA modules can take your database to the next level.

Access as a Relational Design Tool • True relational model • Access implements a true relational database model. • Allows Access to function as a frontend to other client/server database systems. • Integrated data • All data tables and indexes are integrated into an Access file. • Integrated forms • Access databases contain not only the data, but also the forms and reports for that system in the same file.

The Windows Way • Windows programs are event driven • Windows is a multitasking operating system. • Windows uses an event-driven model to allow programs to respond to the user. • Access programming requires responding to Windows events using event procedures. • Some examples of events are: Mouse Clicks, a Keypress, selecting an item in a Listbox, a Form opening or closing. • The list is seemingly endless.

The Windows Way (Contd.) • Working with Access means working with objects. • Everything in Access is an object. • Tables • Forms • Queries • Reports • Pages • Macros • Modules • This object paradigm requires a new approach to programming to fully exploit the features of Access objects.

Where is the Data? Database (MDBFILE) Records in Table Tables in database Fields in Record

Tables • Tables contain data about a particular subject. -- Orders -- Order Items -- Vendors • A table is a container of records. -- A record contains data about one Order, one Order Item, one Vendor. • A record is a container of fields. -- A field for example in an Order record might contain one piece of information such as ShipDate. • All records in a table contain the same fields.

Fields • Each field contains information about a specific thing such as VendorNumber, OrderDate, ItemCost. • Each field contains a specific type of data such as Text, Currency, Yes/No, Numeric and more… • Some fields might contain small amounts of data and others many hundreds or even thousands of characters of data. • Access allows many different data types.

Creating order out of chaos • Data entered into a table winds up in what is called Natural Order. That is, each record is added just following the previous record. • Natural Order bears no resemblance to the way we typically need to view our data.

Creating order out of chaos (Contd.) • As you can see, natural order is not very useful so Access allows us to assign indexes to fields. This enhances speed of retrieval and sorting of records. Internal index Natural table order Table Record pointer

Indexes • Indexes provide: -- Quick retrieval of records. -- Quick sorting of records. -- Faster query response. • Indexes are actually internal tables that contain field contents and a record pointer. When the database is opened, Access places the indexes in memory for efficiency. • An index specified for the Last Name field in a Customers Table would be useful for rapid retrieval of a given customer record. • Indexes can be specified as unique or duplicates allowed.

Primary key • A field or combination of fields that uniquely identify a record. • A given table can only have one Primary key. • Multiple fields would only be needed in the event that one field cannot guarantee uniqueness. • Access does not require a table to have a Primary key, however most tables will have one. • Access can create one for you if necessary. • Although not a requirement, Primary Key fields are usually the first fields in each table. • Internally, Primary keys are really indexes that are required to be unique.

Primary keys in Table relationships

Primary keys in table relationships (contd.) • Primary keys are used to create relationships with other tables. • This is sometimes called a Parent/Child relationship. • The Primary key of one table is linked to a field in the second table. • The field in the second (child) table must be the same data type as the Primary key field of the first (parent) table. • This field in the child table is sometimes called a Foreign Key. • As you may have noticed in the relationships screen, the linked fields were spelled the same. This is not a requirement however, but a useful design goal. • These sorts of challenges are what make working with databases so interesting and enjoyable.

What we have covered • What is Access. • What is a database. • The ways we can work with data. • The visual emphasis of Access. • Access as a Relational Database Management System • The major Access objects. • Tables as data containers. • Primary keys and indexes. • Table relationships.

• More by User

Microsoft Access. Exporting Access Data and Mail Merging. Objectives. Access export options Mail Merge Data Sources Form Letter. Access Export Options. Data within Access can be exported in a variety of ways. The most common are exporting to a text file (.txt) an Excel file (.xls)

233 views • 9 slides

Microsoft Access. Project Four Reports, Forms, and Combo Boxes. MOUS Objectives. Create a query for a report Use the Report Wizard to create a report Use the Report window to modify a report design Move between Design view and Print Preview. MOUS Objectives. Recognize sections in a report

1.25k views • 110 slides

Microsoft Access. Review for Access Exam. Columns are called FIELDS Rows are called RECORDS Navigation Pane: On left ; used t o organize DB objects Collapsable for more working space on screen Access is a DBMS Blank DB vs. Templates

359 views • 4 slides

Microsoft Access. Using Visual Basic Routines. Visual Basic Datatypes. Boolean Byte Currency Date Double Integer Long Object Single String Variant Hyperlink. Variables and Arrays. Use of “Dim” e.g. Dim count as Integer Use of “Dim” to create arrays

273 views • 14 slides

Microsoft Access. Database Creation and Management. Overview of Access Database. One of database management systems software. Access, SQL Server, Oracle, DB 2 MS Access is a relational database . a collection of tables that are related to one another based on a common field.

1.21k views • 96 slides

Microsoft Access. Organizing Data. Your first step in organizing data is to identify the individual fields The specific value, or content, of a field is called the field value Record Next, you group related fields together into tables. Databases and Relationships.

515 views • 33 slides

Microsoft Access. CS 110 Fall 2005. Entity Relationship Model. Entities Principal data object about which information is to be collected employees, projects, invoices, etc. Relationships An association between two or more entities employees are assigned to projects. Entities.

272 views • 16 slides

Microsoft Access. Database software. What is a database?. … a database is an organized collection of data. A collection of data of similar information compiled in a table of records consisting of individual fields. Examples…. A Telephone book State and IRS files A file box with cards

454 views • 21 slides

Microsoft Access -

Microsoft Access -. A Primer for Relational Database Design and Use. Presented by Manjeet Singh. Microsoft Access – Module 1. An Overview of MS-Access. What is Microsoft Access?.

739 views • 38 slides

Microsoft Access -. Crash Course A Primer for Relational Database Design and Use. Paul A. Harris, Ph.D. Office of Research Informatics Oct 07, 2010. PA Harris, Vanderbilt University. What is Microsoft Access?.

223 views • 17 slides

Microsoft Access. Tutorial 2 – Creating And Maintaining A Database. Learn the guidelines for designing databases. When designing a database, first try to think of all the fields of data that needs to be stored.

532 views • 32 slides