Transcript Chapter 1 ACCESS (Part Two)

Create a Table and Define
Fields in a
New Blank Database
with Microsoft® Access 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
1
Create a Table and Define
Fields in a
New Blank Database
with Microsoft® Access 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
2
Save and Close
• When you close an Access table, any
changes made to the records are
saved automatically.
• You will be prompted to save
changes to design of the table or the
layout of Datasheet view.
• Saving the entire DB is a different
action then saving a table or other
object.
with Microsoft® Access 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
3
Two views
You can manipulate database
tables in either DATASHEET
view or DESIGN view.
I usually use DESIGN view to
create fields and their
associated properties.
Then use DATASHEET view to
enter, modify, add, and delete
records.
with Microsoft® Access 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
4
Create a Table
and Define Fields
You may use either table VIEW to:
• Add fields
• Rename fields
• Change data types
• Change field properties
I’ll demonstrate this in DESIGN view and
the chapter tutorial will instruct you to do
this in DATASHEET view. Both are fine!
with Microsoft® Access 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
5
Create a Table
In DESIGN View
with Microsoft® Access 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
6
Create a Table
• Adding data into fields for a record in
a table must be done in DATASHEET
view. Data is typed in just like data
was entered in a Excel spreadsheet.
with Microsoft® Access 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
7
Create a Table
• Data may also be entered by Importing
data from some other source (like an
Excel spreadsheet.
with Microsoft® Access 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
8
Change the Structure of Tables
and Add a Second Table
Browse for data to import and then
allow import wizard to prompt you.
with Microsoft® Access 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
9
Change the Structure of Tables
and Add a Second Table
• Adding a second table to a database
by importing an Excel spreadsheet
with Microsoft® Access 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
10
Create and Use a Query via
Query Wizard
with Microsoft® Access 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
11
Create and Use a
Form and Report
with Microsoft® Access 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
12
Create a Database
Using a Template
• A database template contains prebuilt tables, queries, forms, and
reports to perform a specific task.
– You do not have to create the objects.
– All you need to do is enter your data and
modify the pre-built objects to suit your
needs.
with Microsoft® Access 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
13
Organize Objects in the
Navigation Pane
Objects include Tables, queries,
forms, and reports
with Microsoft® Access 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
14
Save and Close
• When you close an Access table, any
changes made to the records are
saved automatically.
• You will be prompted to save
changes to design of the table or the
layout of Datasheet view.
• Saving the entire DB is a different
action then saving a table or other
object.
with Microsoft® Access 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
15