Transcript File - Brett Jennings

Project 17
Database
Working for
Social Reform
Data file:
none
Unit 4 Project 17
Slide 1
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
OUR EXPLORATION ASSIGNMENT
Creating a New Database and Then
Creating a Table, a Form, a Report, and
Query Objects
Objectives:
In this project, you will:
► create, name, and save a new database
► modify a table in Design view
► create a form using the Form tool
► create a report using the Report tool
► create a select query in Design view
Unit 4 Project 17
Slide 2
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
Starting Out!
Start the Access application.
► Start the Access application using the Start menu or
a desktop shortcut.
Unit 4 Project 17
Slide 3
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 1
Creating, Naming, and
Saving a New Database
KEYWORDS
► templates
Unit 4 Project 17
Slide 4
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 1
Creating, Naming, and
Saving a New Database
Create a new database.
► Click the Blank database icon to select it, if
necessary.
► Key reformers17 solution in the File Name text box
in the lower-right corner of Backstage view; then
click the Browse icon to open the File New
Database dialog box.
► Switch to the folder that contains your solution files
and click OK to save the new database file.
(continued)
Unit 4 Project 17
Slide 5
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 1
Creating, Naming, and
Saving a New Database
Create a new database.
► Click the Create button
below the File Name text
box and path to open the
new database containing
an empty table.
Unit 4 Project 17
Slide 6
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 1
Creating, Naming, and
Saving a New Database
CHECKPOINT
The empty table in your new database
should look similar to this.
Unit 4 Project 17
Slide 7
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 1
Creating, Naming, and
Saving a New Database
Create a new database.
► Click the Blank database icon in the New Blank
Database pane in the Getting Started with Access page.
► The File Name text box and Browse icon appear in
the Blank Database pane in the lower-right corner of
the page.
► Key reformers17 solution in the File Name text box and
click the Browse icon to open the File New Database
dialog box.
► Switch to the folder that contains your solution files and
click OK to save the new database file.
(continued)
Unit 4 Project 17
Slide 8
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 1
Creating, Naming, and
Saving a New Database
Create a new database.
► Click the Create button
below the File Name text
box and path to open the
new database containing
an empty table.
Unit 4 Project 17
Slide 9
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 1
Creating, Naming, and
Saving a New Database
CHECKPOINT
The empty table in your new database
should look similar to this.
Unit 4 Project 17
Slide 10
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 2
Modifying a Table
in Design View
KEYWORDS
► Design view
► field properties
► Field Properties pane
► primary key
► table design grid
Unit 4 Project 17
Slide 11
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 2
Modifying a Table
in Design View
Name and save a table while switching to
Design view.
► Click the Design View button face in the Views
group on the Home tab.
► Key Famous Reformers
in the Table Name text
box and click OK.
Unit 4 Project 17
Slide 12
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 2
Modifying a Table
in Design View
CHECKPOINT
Your table in
Design view
should look
like this.
Unit 4 Project 17
Slide 13
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
Database Fields
Field
Properties
Description
Field Name
a descriptive name up to 64 characters
Data Type
the kind of data, such as text or an AutoNumber,
to be stored in the field
Field Size
the number of characters that can be keyed in
the field
Caption
text, instead of the field name, that appears in
the datasheet or form
Default Value text or a value that automatically appears in the
field
Required
Unit 4 Project 17
Slide 14
whether data must be entered in a field before a
record can be saved
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 2
Modifying a Table
in Design View
Add fields and set the field properties.
► Tap the Down arrow to move the insertion point to
the next blank text box in the Field Name column in
the table design grid.
► Key FirstName in the text box in the Field Name
column and tap the TAB key.
► The default Text data type is automatically
selected.
► Select the contents of the Field Size text box in the
Field Properties pane using the I-beam pointer.
(continued)
► Key 10. Tap the ENTER key three times.
Unit 4 Project 17
Slide 15
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 2
Modifying a Table
in Design View
Add fields and set the field properties.
► Key First Name as
the caption.
► Tap the ENTER key
four times to move
down and select
the Required text
box in the Field
Properties pane.
(continued)
Unit 4 Project 17
Slide 16
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 2
Modifying a Table
in Design View
Add fields and set the field properties.
► Click the Required text box arrow and click Yes to
require data entry in the FirstName field.
► Click the next empty text box in the Field Name
column in the table design grid.
► Define the remaining fields.
Unit 4 Project 17
Slide 17
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 2
Modifying a Table
in Design View
CHECKPOINT
Your table design grid should look like this.
Unit 4 Project 17
Slide 18
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 2
Modifying a Table
in Design View
Review the primary key set by Access, save the
table and close it.
► Click the ID field in the table design grid.
► The primary key icon appears in the Field selector
button to the left of the field name, and the Primary
Key button in the Tools group on the Table Tools
Design tab is active.
► Click the Save button on the Quick Access Toolbar.
► Click the Datasheet View button in the View Shortcuts
on the status bar. Close the table.
Unit 4 Project 17
Slide 19
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 3
Creating a Form
Using the Form Tool
KEYWORDS
► Form tool
► Layout view
Unit 4 Project 17
Slide 20
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 3
Creating a Form
Using the Form Tool
Use the Form tool to create and save a simple
data entry form.
► Click the Famous Reformers table in the Navigation
pane.
► Click the Form button in the Forms group on the
Create tab to create a simple data entry form.
► The form opens in Layout view in the workspace.
► Click the Save button on the Quick Access toolbar to
open the Save As dialog box.
► Key Famous Reformers Data Entry Form in the
Form Name text box and click OK.
Unit 4 Project 17
Slide 21
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 3
Creating a Data Entry Form
Using the Form Tool
CHECKPOINT
Your data entry
form in Form
view should
look similar to
this.
Unit 4 Project 17
Slide 22
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 3
Creating a Form
Using the Form Tool
Switch to Form view.
► Click the Form View button in the View Shortcuts to
switch to Form view.
► Scroll horizontally to the left to
more clearly see the field names
in the form.
Unit 4 Project 17
Slide 23
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 3
Creating a Form
Using the Form Tool
Enter data in the table using the new form.
► Tap the ENTER key to move the insertion point to the
First Name field text box.
► Key Jane and tap the ENTER key twice.
► Key Addams and tap the ENTER key.
► Key 1860 in the Born field and tap the ENTER key.
► Key 1935 in the Died field and tap the ENTER key.
(continued)
Unit 4 Project 17
Slide 24
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 3
Creating a Form
Using the Form Tool
Enter data in the table using the new form.
► Key Poverty in the Social Concern field.
► For now, leave the Source 1 field blank. The
Source 2 field contains a default value.
► Click the New (blank) record button in the
navigation buttons. Click the First Name text box.
► Using Julie’s list, enter the remaining records. Close
the form.
Unit 4 Project 17
Slide 25
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 3
Creating a Form
Using the Form Tool
Open the updated table, widen its columns, and
save it.
► Double-click the Famous Reformers table name in
the Navigation Pane.
► Double-click or drag the right boundary of the field
selectors (column headers) to resize the columns as
necessary.
► Double-check your data entry against Julie’s data.
► Click the Save button on the Quick Access Toolbar.
Close the table.
Unit 4 Project 17
Slide 26
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 4
Adding Records to a Table
Using a Form
CHECKPOINT
Your Famous
Reformers
datasheet
should look
similar to this.
Unit 4 Project 17
Slide 27
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 4
Creating a Report
Using the Report Tool
KEYWORDS
► Report tool
Unit 4 Project 17
Slide 28
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 4
Creating a Report
Using the Report Tool
Create a simple report using the Report tool,
save the report, and switch to Print Preview.
► Make certain the Famous Reformers table is
selected in the Navigation pane. Click the Report
button in the Reports group on the Create tab to
create a basic report.
► Click the Save button on the Quick Access toolbar.
► Key Famous Reformers Report in the Report
Name text box and click OK.
► Click the Print Preview button in the View Shortcuts
on the status bar.
Unit 4 Project 17
Slide 29
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 4
Creating a Report
Using the Report Tool
CHECKPOINT
Your report in
Print Preview
should look
similar to this.
Unit 4 Project 17
Slide 30
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 5
Creating a Select Query
in Design View
KEYWORDS
► query design grid
Unit 4 Project 17
Slide 31
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 5
Creating a Select Query
in Design View
Create a select query to find all records meeting
specific criteria.
► Make certain the Famous Reformers table is selected in the
Navigation pane.
► Click the Query Design
button in the Queries
group on the Create tab.
► Double-click the Famous
Reformers table in the Tables
tab in the Show Table dialog
box. Close the Show Table
dialog box.
Unit 4 Project 17
Slide 32
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 5
Creating a Select Query
in Design View
Create a select query to find all records meeting
specific criteria.
► Make certain the Famous Reformers table is selected in the
Navigation pane.
► Click the Query Design
button in the Other
group on the Create tab.
► Double-click the Famous
Reformers table in the Tables
tab in the Show Table dialog
box. Close the Show Table
dialog box.
Unit 4 Project 17
Slide 33
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 5
Creating a Select Query
in Design View
Specify fields for the query.
► Scroll the table list window at the top of the query
design grid to view all of the fields in the table.
► Note that the list shows field names and not field
captions.
► Double-click the FirstName field in the
table list.
► Continue by adding the MiddleName,
LastName, Born, Died, and Concern
fields to the grid.
Unit 4 Project 17
Slide 34
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 5
Creating a Select Query
in Design View
CHECKPOINT
Your design
grid should
look like this.
Unit 4 Project 17
Slide 35
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 5
Creating a Select Query
in Design View
Key additional query criteria.
► Click the Criteria box in the Died field (column).
► Key >1920. Tap the ENTER key.
► Do not forget to key the
greater than sign.
► Key =Women’s sufferage
in the Concern field’s criteria
box. Tap the Down arrow.
► Do not forget to key the equals sign.
(continued)
Unit 4 Project 17
Slide 36
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 5
Creating a Select Query
in Design View
Key additional query criteria.
► Click the Save button on the Quick Access Toolbar.
Key Nineteenth Amendment as the query name and
click OK.
► Click the Datasheet View button in the View
Shortcuts on the status bar to switch to Datasheet
view and run the query.
► Close the Query datasheet and other open objects
and close the database.
Unit 4 Project 17
Slide 37
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
TRAIL MARKER 5
Creating a Select Query
in Design View
CHECKPOINT
Your query datasheet should look like this.
Unit 4 Project 17
Slide 38
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
Project Skills Review
Start Access and then
Click the Blank database icon in
create, name, and save Backstage view; key the filename, browse for
a new database
the solution files folder, and save the
database; and then click the Create button in
Backstage view.
Click the Blank Database icon in the
New Blank Database pane in the Getting
Started with Access page; key the filename,
browse for the solution files folder, save the
database; and then click the Create button.
Switch object views
Unit 4 Project 17
Slide 39
Click the View button face in the Views
group on the active Ribbon tab. Click a
button in the View Shortcuts on the status
bar.
(continued)
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
Project Skills Review
Add table fields and
set properties in
Design view
Select the table name in the Navigation Pane
and click the Design View button face in the
Views group on the Home or Table Tools
Fields or Datasheet tabs. Move back and
forth between the table design grid and Field
Properties pane to name fields, set the data
type, and set field properties.
Move from text box
to text box in the
table design grid or
Field Properties
pane to define field
properties
Tap the TAB, ENTER, or arrow key. Click
the text box.
(continued)
Unit 4 Project 17
Slide 40
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
Project Skills Review
Set the primary key
Select the field name and click the
Primary Key button in the Tools group on
the Table Tools Design tab.
Create a data entry
form using the Form
tool
Select the underlying table in the Navigation
Pane; then click the Form button in the
Forms group on the Create tab.
Add records to a
table using a form
Open the form in Form view and key data
in a field’s text box; use the TAB, SHIFT +
TAB keys, ENTER key, or arrow keys to
move from field to field. Use the record
navigation bar at the bottom of the form to
navigate between records.
Create a report using Click the Report button in the Reports
the Report tool
group on the Create tab.
(continued)
Unit 4 Project 17
Slide 41
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
Project Skills Review
Save a table, form,
or report object
Click the Save button on the Quick
Access toolbar.
Click the File tab or Office Button,
point to Save As, and click Save Object
As.
Create a query in
Design view
Click the Query Design button in the Queries
group on the Create tab.
Click the Query Design button in the Other
group on the Create tab.
Unit 4 Project 17
Slide 42
Learning With Computers II (Level Orange)
©2012 Cengage Learning. All Rights Reserved.
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.