Transcript DBC-e04-Access-Workbench-Section-01-PP

DAVID M. KROENKE and DAVID J. AUER
DATABASE CONCEPTS, 4th Edition
The Access Workbench: Section One
Getting Started with Microsoft Access
Section Objectives
 Learn how to use Microsoft Access to:







Create a database
Create tables
Enter table data
Modify table data
Delete table data
Create single-table forms
Create single-table reports
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-2
Starting Microsoft Access
• These instructions use Windows XP
and Microsoft Access 2007 –
Windows Vista is very similar
• If you are not familiar with the
Microsoft Office Fluent user
interface, review Appendix A
• Select Start | All Programs |
Microsoft Office | Microsoft Office
Access 2007
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-3
The Microsoft Access 2007 Window
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-4
Creating an Access Database
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-5
Creating an Access Database:
The New Access Database
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-6
The Microsoft Office Fluent User Interface
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-7
The Navigation Pane Drop-Down List
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-8
The All Access Objects Drop-Down List
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-9
The Empty Navigation Pane
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-10
The Open Recent Database Pane
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-11
The Recent Documents Pane
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-12
The Security Warning Bar
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-13
The Microsoft Office
Security Options Dialog Box
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-14
Database Column Characteristics:
The CUSTOMER Table
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-15
Microsoft Access 2007 Data Types
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-16
Creating an Access Table:
The Table Design Button
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-17
Creating an Access Table:
The Table1 Tabbed Document Window
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-18
Creating an Access Table:
Selecting the Data Type
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-19
Creating an Access Table:
The Completed CustomerID Column
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-20
Creating an Access Table:
Editing the Text Field Size
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-21
Creating an Access Table:
Setting the Column Required Property Value
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-22
Creating an Access Table:
Selecting the CustomerID Row
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-23
Creating an Access Table:
Setting the Primary Key
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-24
Creating an Access Table:
Naming and Saving the CUSTOMER Table
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-25
Creating an Access Table:
The Named CUSTOMER Table
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-26
Creating an Access Table:
The CUSTOMER Table Object
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-27
Entering Data into a Table:
CUSTOMER Data
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-28
Entering Data into a Table:
The CUSTOMER Table in Datasheet View
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-29
Entering Data into a Table:
The Collapsed Navigation Pane
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-30
Entering Data into a Table:
Entering Data Values for Ben Griffey
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-31
Entering Data into a Table:
The Completed Row of Data Values
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-32
Entering Data into a Table:
The Completed CUSTOMER Datasheet
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-33
Modifying Data in a Table:
The Modified CUSTOMER Datasheet
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-34
Deleting Data from a Table:
Deleting a Row in the CUSTOMER Datasheet
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-35
Deleting Data from a Table:
The Access Deletion Warning Dialog Box
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-36
Reentering Data into a Table:
The New CustomerID Number
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-37
Creating an Access Form:
The More Forms Gallery
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-38
Creating an Access Form:
The Form Wizard
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-39
Creating an Access Form:
The Completed Form
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-40
Entering Data in an Access Form:
The Data for Judy Hayes
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-41
Deleting Data using an Access Form
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-42
Creating an Access Report:
The Report Wizard Button
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-43
Creating an Access Report:
The Report Wizard
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-44
Creating an Access Report:
The Completed Column Selection
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-45
Creating an Access Report:
Choosing the Sort Order
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-46
Creating an Access Report:
The Finished Report
KROENKE and AUER - DATABASE CONCEPTS (4th Edition)
© 2010, 2008 Pearson Prentice Hall
AW-1-47
DAVID M. KROENKE and DAVID J. AUER
DATABASE CONCEPTS, 4th Edition
End of Presentation on The Access Workbench: Section One
Getting Started with Microsoft Access
All rights reserved. No part of this publication may be reproduced,
stored in a retrieval system, or transmitted, in any form or by any
means, electronic, mechanical, photocopying, recording, or otherwise,
without the prior written permission of the publisher. Printed in the
United States of America.
Copyright © 2010 Pearson Education, Inc.
Publishing as Prentice Hall