Access - Introduction to Database Management with Microsoft...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
Introduction to Database Management with Microsoft Access
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Creating a Database 1. Plan the Database 2. Locate and Run Microsoft Access XP 3. Entering and Editing Data in Tables 4. Sorting and Analyzing Data 5. Querying the Database 6. Creating Output in the Form of Reports
Background image of page 2
Creating a Database ( Cont… ) DB Name: Students.mdb Table(s) Form Query Report Page - Design View -From Wizards -By entering data (Datasheet) - From Blank DB - From Wizard - From a File Create a Database then create at least one Table of DB records.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Table Structure Field Name Data Type Field Properties and description Primary key Field Name Field Type Field length Student Class ID AutoNumbe r 10 Class ID Number 6 Student ID Number 12 Grade Text 2
Background image of page 4
Primary key Uniquely identify a record Select a field and click the primary key button Primary Key….
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Creating a Form - Go to the Objects menu - Right click on the table you want as a form and click Save As and then select Form - Or, Click the Forms Object
Background image of page 6
Compacting a Database To reduce the size of the database, compact it using Tools/Database Utilities/Compact Database from the Tools menu
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
II. Modifying a Database
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/22/2010 for the course CMSY 103 taught by Professor N/a during the Fall '06 term at Howard County Community College.

Page1 / 34

Access - Introduction to Database Management with Microsoft...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online