Bfgh

Stats

Submitted by:
Date Added: 01 / 03 / 2011
Category: Music and Film
Words | Pages: 2157 | 9
Views: 418

Bfgh

View Full Essay INFO & DATABASE MANAGEMENT

INFORMATION & DATABASE MANAGEMENT

Part 1 - What is an Information System? Part 2 - What is a Database? Part 3 - Relational Database Basics Part 4 - Using Excel as a Database Part 5 - Large Scale DBMS (Oracle) Part 6 - Microsoft Access

Part 6:

Microsoft Access

Introduction
• Please notice that the title of section is “Database and Information Managment” not “Introduction to Access”. It is important to realize that Access is just one of many programs that can be used to build and manage a database. The first part of this section is designed to follow the online tutorial in MS Access. To start the tutorial pages: 1. select: Help 2. select: Microsoft Access Help Topics 3. select: Contents 4. select: Visual Introduction to Microsoft Access. 5. Open and Display 6. Read through the following sections of the Help file and understand them. What is a database? Tables: What they are and how they work Customizing a table Working in table Datasheet view Queries: What they are and how they work Customizing a query Working in query Datasheet view Forms: What they are and how they work Customizing a form Working in Form view Reports: What they are and how they work 1

• •

INFO & DATABASE MANAGEMENT

Customizing a report NO: NO: Macros: What they are and how they work Modules: What they are and how they work

The first step in building a database is to create a table. 1. Open Access 2. select: 3. select: 4. select: 5. select: Create a new database using: "a blank database" Name the new database: test.mdb Click the "Table" tab. Double Click "Create table in Design View"

2

INFO & DATABASE MANAGEMENT

Create the following Table:
Field Name Name Age Province Pet Class Data Type Text Number Text Text Text Field Size 20 Integer 30 10 20

Notice where “Field Size” is set. After Creating the Fields, do the following: 1. Set the Name Field as the Primary Key. Click on "Name" and then click on the Primary Key button in the...