*Microsoft Access
2016
Lição #01
*What is a
database?
* A database is a tool
used to organize, store,
retrieve, and
communicate groups of
related information.
*Telephone book * Customer data
*Student data * Real estate listings
*Music *MLS listings online
*Fingerprint database * Hospital/patient data
*Dictionaries * Inventory
*Barcode scanner keeps inventory
in database
* Examples of Business
Databases
Slide 3
*Examples
Show
how to
access
and use
for
activity
*Columns & Rows Datasheet view displays
the data in columns &
rows much like what is
seen in an Excel
spreadsheet.
A “row” represents a
record.
A “column” represents a
field.
*Example
*Terms… Field
Name
Cell/Entry
Record
Field
*Database vs.
Spreadsheet
*Databases are more powerful allowing for
information to be retrieved based upon
criteria, calculations, etc.
database
spreadsheet
*What makes a database?
Databases consist of four objects:
1. Tables store data in rows and columns*
2. Queries retrieve and process data
3. Forms control data entry and data views
Customized manner of inputting data into a database or
presenting data on a screen
4. Reports summarize and print data
*In this objective, our focus is on tables
Slide 9
*Tables: the Building Blocks
of all Databases
►Tables store data, so they’re essential building
blocks of any database.
► All databases contain at least one table
► A database should have a separate table for
every major subject, such as for employee
records or customer orders. Data should not be
duplicated in multiple tables.
• Tables organize data ► Tables contain Rows called Records and
• Each database Columns called Fields.
consists of one or
more tables
Slide 10
*Components of a
Database Table
* Record – A group of related fields of information.
Everything on one row is a record
* Field – One item or bit of information in a record;
represented by a COLUMN. Comprised of entries
* Entry – Data typed into a field. Made up of
characters. Example: John Doe is an entry in the
name field. Also known as data.
Slide 11
Database Tables: The Big
Picture
1. Records
2. Fields
3. Entry
1. Rows – RECORDS 2. Columns -
FIELDS
3. Cells -
ENTRIES
To calculate the number of entries in a database multiply the number of fields
by the number of records. Ex. 5*26= 130 entries in this database.
Slide 12
* Name Each item on the left is classified as a/an:
* Birth date a) Table
* Social Security No. b) Record
* Street c) Field
* City d) Entry
* State
* Zip
* Phone
* Discussion
Slide 13
* Susan Almond Each item on the left is classified as a/an:
* 10/22/1985 a) Table
* 245-88-9845 b) Record
* 31 Bessemer St. c) Field
* Greensboro d) Entry
* NC
* 25233
* 336-585-5646
* Discussion
Slide 14
* Susan Almond All of the information about Susan Almond
* 10/22/1985 is classified as a/an:
* 245-88-9845 a) Table
* 31 Bessemer St. b) Record
* Greensboro c) Field
* NC d) Entry
* 25233
* 336-585-5646
* Discussion
Slide 15
* Information about multiple employees is classified as a/an:
a) Table
b) Record
c) Field
d) Entry
* Discussion
Slide 16
One record is displayed from the Employee
Table above. The table contains 8 fields.
Name Bday SS Street City St Zip Phone
Almond 10/22/ 245- 31 Greensbor NC 2523 336-585-
, Susan 1985 88- Bessemer o 3 5646
9845 St
* Susan’s Record
Slide 17
*Open & Close an Object
*The Navigation Pane does *You can select open objects
not display any groups that using the object table that
are empty. appears below the ribbon
*By default, objects in the area
Navigation Pane are *The currently selected
organized by Table. object’s tab appears in
*Double-Click an object in yellow
the Navigation Pane to *Close an object by choosing
open the object the close button on the
upper right corner of the
object window
Access Lesson 1 Lesson Plans Michele Smith – North Buncombe High School, Weavervil
le, NC 28787
* Differences between
Design View & Datasheet View
* Datasheet view shows the data in the database. It
also allows you to enter and edit the data. It does not
let you change the format of the database, other than
minor changes (such as displayed column widths).
Design view allows you to create or change the table,
form, or other database object, and configure the
fields. You can also set keys and restrict the values
entered here. But you can't change the database data
in design view.
You don't use one or the other exclusively. You
constantly switch back and forth between them while
designing your database
*Design View Design view displays
the background
structure of the
object.
Design view may be
used to modify the
underlying design of
the object.
ALL OBJECTS can be
Field opened in Design
Name View.
Data This is
Types how a
Table
Propertie looks in
s Design
View
* Switch between Design & Data
Views
* Switch between Design & Data
View
*Navigate in Datasheet View Navigate
using the
mouse
and/or the
navigation
buttons
Can also
navigate
by using
the
keyboard
arrow keys
Scroll Bars can be
Navigation used to navigate
Buttons HOT KEY
Tab Key =
Total Number of moves 1 field
Records to the right
Shift + Tab =
Moves one field
to the left
* What you see after you open
Access…
The screen that
appears
immediately after
opening Microsoft
Access 2016 is
the Backstage
View.
Parts of the Access Ribbon
Quick Access Toolbar Contextual Command Tab
Tab
Group
Navigation Pane
Status Bar (can be turned
on or off) File/Options
*Available Templates &
[Link]
* How to open an existing
database using Open from File
Tab.
* Open a recent database using
“Recent Command”
*It opens in “Datasheet
View”
*File Tab…
*Quick Access Toolbar
*Navigation Pane