My Personal Life Planing
[pic]
Getting Started with Access 2007
This document gives an introduction to Microsoft Access— the Relational Database Management System
John Davies, Phil Marshall & Brenda Lowndes
January 2008
Document 094
Computing Services Department
Contents
1 Introduction 2 Fundamentals 2 System Requirements 2 Data Types Supported by Access 2 Restrictions Imposed by Access 2
2 Running Access 2 Help 2 Creating a New Database 2 Opening an Existing Database 2 Creating Tables within a Database 2 Field Properties 2 Indexes 2 Table Properties 2 Saving and Naming a Table 2 Modifying the Structure of a Table 2 Viewing Data 2 Sorting 2 Finding a Record in a Table 2 Special Characters (Wild cards) 2 Inserting, Deleting and Modifying Data 2 Using Existing Data 2 Exporting to Other Systems 2 Queries 2 Displaying Wanted Data from a Single Table 2 Editing Through a Query 2 Sorting Information 2 Operators 2 AND, OR and NOT 2 Expressions 2 Groups and Summary Statistics 2 Joining Information 2 Query Properties 2 Field Properties 2 Parameters 2 Global Editing 2 Relationships 2 Forms 2 Creating a Form for a Single Table 2 Anatomy of a Form 2 Form Attributes 2 Controls 2 Altering the Design of a Form 2 Aesthetics (Tips) 2 Filters 2 Sorting 2 Creating a Form for Related (Master Detail)
Getting Started with Access 2007
This document gives an introduction to Microsoft Access— the Relational Database Management System
John Davies, Phil Marshall & Brenda Lowndes
January 2008
Document 094
Computing Services Department
Contents
1 Introduction 2 Fundamentals 2 System Requirements 2 Data Types Supported by Access 2 Restrictions Imposed by Access 2
2 Running Access 2 Help 2 Creating a New Database 2 Opening an Existing Database 2 Creating Tables within a Database 2 Field Properties 2 Indexes 2 Table Properties 2 Saving and Naming a Table 2 Modifying the Structure of a Table 2 Viewing Data 2 Sorting 2 Finding a Record in a Table 2 Special Characters (Wild cards) 2 Inserting, Deleting and Modifying Data 2 Using Existing Data 2 Exporting to Other Systems 2 Queries 2 Displaying Wanted Data from a Single Table 2 Editing Through a Query 2 Sorting Information 2 Operators 2 AND, OR and NOT 2 Expressions 2 Groups and Summary Statistics 2 Joining Information 2 Query Properties 2 Field Properties 2 Parameters 2 Global Editing 2 Relationships 2 Forms 2 Creating a Form for a Single Table 2 Anatomy of a Form 2 Form Attributes 2 Controls 2 Altering the Design of a Form 2 Aesthetics (Tips) 2 Filters 2 Sorting 2 Creating a Form for Related (Master Detail)