Transcript Access Project 1 - MDC Faculty Home Pages

Microsoft
Office 2003
Introductory Concepts
and Techniques
Access Project 1
Creating and Using a
Database
Features of Microsoft Access
• Data Entry and update – You can add,
change, and delete data
• Queries (questions) – You can ask and
receive instant answer to questions about
the data in the database
• Forms – You can create forms to view the
data
• Reports – You can create reports to
display the data
Access Project 1: Creating and Using a Database
2
Terminology
• DBMS – Database Management System
• Data – Is a collection of raw facts, figures,
and symbols. (information)
• Database – Describes a collection of data
organized in a manner that allows access,
retrieval, and use of that data.
Access Project 1: Creating and Using a Database
3
Terminology
• Database management System –
(Access) is a software tool that allows you
to use a computer to create a database;
add, change, delete, sort and retrieve data
in the database; Create forms and reports
using the database.
• In access a database consists of a
collection of tables.
Access Project 1: Creating and Using a Database
4
Terminology
• In access a database consists of a
collection of tables.
• Records – rows in a table (contains
information)
• Field – Columns in a table, contains a
specific piece of information within a
record.
Access Project 1: Creating and Using a Database
5
Terminology
• Unique Identifier – A unique number or
combination of characters that identifies a
record
• Primary Key – a Unique Identifier
Access Project 1: Creating and Using a Database
6
Access Project 1: Creating and Using a Database
7
Fields within a table
• Field Name – Each field in a table must
have a unique name.
– Names can be up to 64 characters in length
– Names can contain letters, digits, and
spaces, as well as most punctuation symbols
– Names cannot contain periods, exclamation
points (!), accent graves (`), or square
brackets ([]).
– Same name cannot be use twice
Access Project 1: Creating and Using a Database
8
Fields within a table
• Data type – Indicates the type of data the
field will contain. Some data types include:
– Text – The field can only contain characters. A
max of 255 characters is allowed.
– Number – The field can contain only numbers.
Numbers can be positive or negative.
– Currency – The field can contain only
monetary data. The values will appear with
currency symbols.
– Table 1-1 page AC17 has additional data
types
Access Project 1: Creating and Using a Database
9
Fields within a table
• Description – Access allows you to enter
a detailed description of the field.
Access Project 1: Creating and Using a Database
10
Access Project 1: Creating and Using a Database
11
The Access Window
• Title Bar – Includes the title of the
application (might include the name of the
file)
• Menu Bar – It is a special toolbar that
displays menu names
• Menu – Is a list of commands. It can
contain submenus
Access Project 1: Creating and Using a Database
12
The Access Window
• Toolbars – Contains buttons that allow
you to perform certain tasks more quickly
than using the menu bar.
• Taskbar – Displays the start button, any
active windows and the current time
• Status Bar – It contains special
information that is appropriate for the task
you are performing.
Access Project 1: Creating and Using a Database
13
Microsoft
Office 2003
Introductory Concepts
and Techniques
Access Project 1
Complete