Access Introduction
Duration:
2 days
Versions Available:
97, 2000, XP, 2003, 2007, 2010
| COURSE OUTLINE |
|
|
Introduction
Designing a Database
Starting Access
The office assistant
Creating a new file
Saving a file
What is a database?
Terminology
Navigating the screen
Opening a file
Importing from Microsoft Word or Excel
Quitting from Access
Tables
Creating a table
Entering data
Highlighting areas of the table
Adjusting field widths and heights
Design view
Inserting and deleting fields
Inserting and deleting records
Using the new object button
Freezing columns
Moving and copying
Undo
Deleting a table
Sorting & Filtering
Using find
Sorting
Filtering data |
Forms
Creating a form
Using AutoForm
Using design view
Deleting a form
Command buttons
Relationships
Showing relationships
Datasheets
Creating subforms
Queries
What is a query
Select queries
Multi-table queries
Calculations in queries
Parameter queries
Action queries
Reports
Using AutoReport
Creating a report using the wizard
Changing a report in design view
Previewing a report
Additional Features
Exporting information to Word and Excel
Database properties
Compact and repair database
Database security
Changing the database view |
Book this course
PDF 
