|
|
|
|
Overview:
Access is a relational database
application. A relational database contains a large amount of data
that is split into numerous tables; each table includes only the
information pertinent to one subject, such as Customer, Orders, or
Items. As a result, each table is smaller; more manageable; and, in
turn, more efficient. This Introduction Course will teach
delegates the basic skills necessary to effectively begin creating
& working with databases.
Getting Started with Access
| Opening an Existing
Database |
| Using Menu Commands |
| Displaying and
Hiding Toolbars |
| Selecting Object
Types |
| Opening a Database
Object |
Creating Tables
| Creating &
Designing a New Database |
| Using Design View |
| Adding Field Names |
| Assigning Data
Types |
| Adding a Field
Description |
| Setting a Primary
Key & Saving a New Table |
| Using the Table
Wizard |
Working with Tables
| Using Datasheet
View |
| Navigating Fields
in Tables |
| Adding &
Deleting Records |
| Moving through
Records |
| Selecting &
Editing Records |
Editing Tables
| Changing the Row
Height & Column Width |
| Changing a Font
Attribute |
| Selecting a Column;
Moving a Column |
| Hiding/Un-hiding a
Column |
| Freezing Columns |
Setting Field Properties
| Limiting Field Size |
| Setting Number
Formats, Date/Time Formats |
| Setting Yes/No
Formats, Default Values |
| Setting Validation
Rules |
| Creating an Input
Mask |
Finding and Filtering Data
| Sorting Records |
| Finding Specific
Records |
| Finding Records
using Wildcards |
| Using Replace;
Filter By Selection |
| Applying/Removing a
Filter |
| Using Filter
Excluding Selection |
| Using the Filter
For Feature |
| Using Filter By
Form |
Using Simple Queries
| Using Queries and
RecordSets |
| Using the Simple
Query Wizard |
| Creating a Query in
Design View |
| Opening a Query |
| Adding a Table to a
Query |
| Joining Tables in a
Query |
| Running a Query |
Modifying Query Results
| Sorting a Query |
| Adding Criteria to
a Query |
| Hiding a Field in a
Query |
| Adding a Record
using a Query |
| Printing a Query |
Creating Basic Forms
| Using the Form
Wizard |
| Viewing Records in
a Form |
| Printing Records in
a Form |
| Basing a Form on a
Query |
| Using AutoForm |
| Adding a Record
using a Form |
Creating Basic Reports
| Using the Report
Wizard |
| Using Print Preview |
| Printing Pages of a
Report |
| Basing a Report on
a Query |
| Using AutoReport |
Creating Relationships
| Using Related
Tables |
| Creating a
Relationship |
| Setting Referential
Integrity |
| Adding a Table -
Relationships Window |
This is just a 'sample' of a possible customised training course
for your staff.
If you have any questions, please contact
us
Back
to Custom Solutions
|
|
|
|
|
|
|
