MS-ACCESS

Module-1 CREATING A DATABASE AND TABLES
Understanding Database Concepts
5 Topics
Organize Data
The Access Interface
Examine Access Objects
Use the Navigation Pane
Use Datasheet and Design View of a Table
Creating and Managing a Database
11 Topics
Templates
Database Properties
Create a Blank Database
Access Naming Rules
Data Types
Create and Save Database Objects
Open Database Objects
Rename Database Objects
Delete Database Objects
Close and Open a Database
Back Up and Recover a Database
Creating and Using a Table in Datasheet View
13 Topics
Create a New Table in Datasheet View
Edit the Default Primary Key
Add New Fields
Add New Fields by Entering Field Names
Add New Fields by Entering Data
Delete Fields
Edit Properties in Datasheet View
Add a Table Description
Save a Table
Close a Table
Open a Table
Rename a Table
Add, Edit, and Delete Records
Importing Data Records from Excel
Exploring Datasheet View
13 Topics
Navigation Buttons
Refine the Datasheet Layout
» Modify the Field Order
» Select a Display Font Face and Font Size
» Modify the Row Height
» Modify the Column Width
» Modify the Field Alignment
» Display Gridlines
» Display Alternate Row Colors
» Use the Datasheet Formatting Dialog Box
» Hide and Unhide Table Fields
» Add Total Rows
» Save Changes
Using Search, Sort, and Filter Tools to Find Records in a Table
10 Topics
Search Data in a Table
Sort Data in a Table with Datasheet View
» Sort Data on a Single Field
» Sort Data on Multiple Fields
» Remove Sorting Criteria
Filter Data in a Table with Datasheet View
» Create a Filter by Selection
» Create a Text Filter, Number Filter, or Date Filter
» Create Compound Filter Criteria
» Remove Filter Criteria
MODULE - 2USING DESIGN VIEW, DATA VALIDATION, AND RELATIONSHIPS
Creating a Table in Design View
7 Topics
Create a New Table in Design View
Add New Fields
Define a Primary Key
Delete Fields in a Table
Save, Close, Rename, and Open a Table
Property Update Options Smart Tag
Switch between Datasheet and Design Views
Setting Field Properties
10 Topics
Set the Field Size
The Format Property
» Number and Currency Field Formats
» Date/Time Field Formats
» Yes/No Field Formats
» Short Text and Long Text Field Formats
The Caption Property
Set the Default Value
The Required Property
The New Values Property
Understanding Data Integrity and Data Validation
Integrating Data Validation in Tables
6 Topics
Field Validation Rules
Record Validation Rules
Test Validation Rules
Create Validation Text
Create a Lookup Field
Define an Input Mask
Changing Field Properties after Records Are Added into a Table
Understanding and Designing Relational Databases
15 Topics
Relational Principles
The Steps to Design a Relational Database
Three Types of Relationships
» One-to-One Relationship
» One-to-Many Relationship
» Many-to-Many Relationship
» Understand a Foreign Key
Create Relationships between Tables
» Define a Relationship Using the Relationships Window
» Enforce Referential Integrity
» Cascade Updates
» Cascade Deletes
» Save a Relationship
Delete a Relationship between Tables
Edit a Relationship between Tables
Printing the Contents of a Table
2 Topics
Preview the Data Records
Print the Data Records without Previewing
Using the Compact & Repair Database Utility
MODULE - 3 CREATING AND USING QUERIES
Understanding Queries and Using the Simple Query Wizard
Creating, Running, and Editing a Query in Design View
9 Topics
Create a Query Based on a Single Table
Add Fields into a Query
Run a Query
Switch between Datasheet and Design Views
Save and Close a Query
Open a Saved Query
Rename a Query
Create a Query Based on Multiple Tables
Edit Fields in Query Design
Adding a Criterion to a Query
6 Topics
Single Criterion
Comparison Operators
Use Wildcards in Criteria
» The ? Wildcard Character
» The * Wildcard Character
» The # Wildcard Character
Controlling the Display of Query Results
3 Topics
Unique Values Property
Show Option for Query Fields
Apply Sorting
Defining Multiple Criteria in a Query
3 Topics
The AND Operator
The OR Operator
Combine the AND and OR Operators
Creating and Using a Simple Parameter Query
3 Topics
Create a Parameter
The Parameter Data Type
Use Wildcards in a Parameter Query
1 of 2
Previous Lesson
Next Lesson

Understanding and Designing Relational Databases

MS-ACCESS Understanding and Designing Relational Databases
Lesson Content
0% Complete 0/15 Steps
Previous Lesson
Back to Course
Next Lesson