Transcript Chapter 1 - SaigonTech

by Mary Anne Poatsy, Keith
Mulbery, Lynn Hogan, Amy
Rutledge, Cyndi Krebs, Eric
Cameron, Rebecca Lawson
Chapter 1
Introduction to Access
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
1
• Understand database fundamentals
• Use an existing database
• Sort table data on one or multiple fields
• Create, modify, and remove filters
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
2
• Know when to use Access or Excel to
manage data
• Understand relational power
• Create a database
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
3
• Microsoft Access is a database.
• Databases are used to store assortments of data.
• Organizations rely on databases for day to day
operations.
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
4
• Objects are needed for the database to function
• Four commonly used objects
– Table
– Form
– Query
– Report
• Two less commonly used objects
– Macro
– Module
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
5
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
6
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
7
• Title Bar
• The Access Ribbon
– File Tab
– Home Tab
– Create Tab
– External Data Tab
– Database Tools Tab
• Navigation Pane
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
8
• Datasheet View
• Design View
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
9
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
10
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
11
• Manage accurate information
• Edit Records
• Delete Records
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
12
• Microsoft Word, Excel and Power work from
memory
• Microsoft Access works from storage
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
13
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
14
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
15
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
16
• Multiple criteria
• Comparison Operators
• AND and OR conditions
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
17
• Excel
– Only one worksheet
– Number data
• Access
– Multiple related tables
– Large amount of data
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
18
• RDBMS
• Normalization
• Join Lines
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
19
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
20
• Protects integrity of data
• Prevents accidental deletion of data
• Improves data accuracy
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
21
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
22
• Browser-based application
• Others can access
• Requires a host server
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
23
• Specific to needs
• Create in Backstage view
• Data added in Datasheet view
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
24
• Saves time
• Helps user become familiar with database design
• Variety of templates available
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
25
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
26
• A database is a collection of data
• There are many tools in Access
• Access is a relational database.
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
27
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
28
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 © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
29