You'll Learn

General Concepts about Access

• Database software vs Spreadsheet software
• Access Database Objects discussion
• Defining your own Access database

Exploring Tables

• Exploring different tables views
• Working with Tables in Datasheet View
• Working with Tables in Design View
• Creating and customizing tables

Working with Fields

• Setting up Fields
• Setting up Data Type
• Setting up Properties
• Add/Delete/Move Fields
• Setting up Primary Key
• Setting up Index
• Setting up Relationships
• Setting up Combo Box to lookup data
• Data validation settings

Working with Records

• Add, Edit, Delete and Filter Records
• Copy, Move Data
• Find, Replace, Filter by Form, Sort Data

Relational Database

• Concept of relational database
• One to one / one to many / many to many relational
• Constructing relationship among tables

Form and Form Design

• Creating and Using Forms
• Standard Form by Form Wizard (AutoForm)
• Designing a Customized Form
• Using the form tools
• Using controls
• Enhancing Form-title, page number, header & footer

Exchange Information with Other Data Sources

• Importing, exporting and Linking Excel data
• Importing, exporting and Linking Access objects