Microsoft Access
| Previous | 2 / 10 | Next |
This is 2-Day Microsoft Access training suitable for beginner and those people have desire to learn Access and create some kind of database management system.
Objective:
Outline:
Objective:
At the end of the training, participants are able to:
- Create and design Access database solutions
- Work with Access tables, relationships, keys and constraints
- Write basic and advanced queries
- Create and design interfaces with access forms
- Create basic to advanced access reports
- Perform database maintenance
- Automate tasks with macros
- Know database design concept
Outline:
-
Databases and Database Objects: An Introduction
- Project- Database Creation
- Designing a Database
- Creating a Database
- The Access Window
- Creating a Table
- Previewing and Printing the contents of a Table
- Creating Additional Tables
- Importing Data from other Applications to Access
- Additional Database Objects
- Database Properties
- Special Database Operations
-
Querying a Database
- Project-Querying a Database
- Creating Queries
- Sorting
- Joining Tables
- Creating a Form for a Query
- Exporting Data from Access to Other
- Adding Criteria to a Join Query
- Calculations
- Crosstab Queries
-
Maintaining a Database
- Project – Maintaining a Database
- Updating Records
- Filtering Records
- Changing the Database Structure
- Mass Changes
- Validation Rules
- Changing the Appearance of a Datasheet
- Multivalued Fields in Queries
- Referential Integrity
- Ordering Records
-
Creating Reports and Forms
- Project – Reports and Forms
- Report Creation
- Multitable Reports
- Form Creation
- Mailing Labels
-
Multitable Forms
- Project – Multitable Forms
- Adding Special Fields
- Updating the new fields
- Multitable form techniques
- Object Dependencies
- Date/Time,Memo, and Yes/No Fields in Queries
- Datahseets in Forms
- Creating a Multitable form based on the many table
-
Advanced Report Techniques
- Project -Advanced Report Techniques
- Additional Tables
- Creating Reports in Design View
-
Advanced Form Techniques
- Project- Advanced Form Techniques
- Creating a Form with Combo Boxes and Command Buttons
- Creating a Multipage Form
- Using the Arrange Tab on Forms and Reports
-
Macros and Navigation Forms
- Project – Macros and Navigation Forms
- Creating and Using Macros
- Creating and Using the Navigation Form
- Data Macros
-
Administering a Database System
- Project- Administering a Database System
- Microsoft Access Tools
- Navigation Pane
- Table and Database Properties
- Special Field Properties
- Creating and Using Indexes
- Encrypting a Database
- Splitting a Database
-
Database Design
- Project – Design a Database
- Entities, Attributes, and Relationship
- Relational Databases
- Database Design
- Normalization
Duration:
2 days (14 hours)
Target Audience:
This course is designed with novice Access users, but serves as a quick reference for more experienced Access users.
Methodology:
Demonstration, practical learning, case discussion and exercises
Prerequisite(s) or equivalent knowledge:
Basic knowledge of computers, using the keyboard, mouse and windows is required.