Microsoft Access L1 & L2 Duration: 2 Days
Course Overview
Course Objective To give an introduction to database design concepts. This course offers grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level. Target student People who intend to design databases from scratch or improve existing Access databases also covers conversion of databases made in other applications and spreadsheet (flat file) databases. The training also cover the Conversion of databases made in other applications and spreadsheet (flat file) databases. Prerequisites This course assumes no previous experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access.
Day 1.
Introduction to Databases
- Database concepts
- Database layout
- Launching Access.
- The access menu system
- Dialog boxes
- Getting help
- Creating a new database
- Closing a database (vs. exit access)
- Opening a database
Working with Tables
- Adding/Editing Records
- Pasting Records
- Sorting the Table
- Deleting a Table
- Table Layout Changes
- Find
- Replace
- Wildcards
- Using Filters
Queries
- The Simple Query Wizard
- The Design View
- Modifying the Query
- Using Basic Criteria
- Additional Criteria
- Parameters
- Multiple Object Queries
- Custom Calculations in a Query
- Calculating Fields continued
Forms and Reports
- Creating a Basic Form
- Creating a Basic Report
Day 2.
Creating a Database
- Database Design.
- Creating Tables using the Table Wizard
- Creating Tables in The Datasheet View
- Creating Tables in the Design View
- Data Types
- Field Properties
- Data Display Format Vs Input Mask
- The Input Mask
- Data Entry Problems
- Moving and Copying Records
Managing Relational Databases
- Types of Relationship
- Creating Table Links
- Referential Integrity
Action Queries
- Types of Query
- The Crosstab Query
- The Make Table Query
- The Append Query
- The Delete Query
- The Update Query
Customising Forms
- Manipulating Data in the Form
- Creating a New Form
- Using the Form Wizard
- Creating a Form with a Subform
- Modifying and Redesigning the Form.
- Modifying and Redesigning the Form continued
Reports
- The Report Wizard
- Creating a Report with Calculated Totals
- Using the Chart Wizard
- Altering the Chart
- Using the Label Wizard
- Modifying and Redesigning the Report.
- Publishing Access Data on the Web
Microsoft Access L1 & L2 Duration: 2 Days
Course Overview
Course Objective To give an introduction to database design concepts. This course offers grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level. Target student People who intend to design databases from scratch or improve existing Access databases also covers conversion of databases made in other applications and spreadsheet (flat file) databases. The training also cover the Conversion of databases made in other applications and spreadsheet (flat file) databases. Prerequisites This course assumes no previous experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access.
Day 1.
Introduction to Databases
- Database concepts
- Database layout
- Launching Access.
- The access menu system
- Dialog boxes
- Getting help
- Creating a new database
- Closing a database (vs. exit access)
- Opening a database
Working with Tables
- Adding/Editing Records
- Pasting Records
- Sorting the Table
- Deleting a Table
- Table Layout Changes
- Find
- Replace
- Wildcards
- Using Filters
Queries
- The Simple Query Wizard
- The Design View
- Modifying the Query
- Using Basic Criteria
- Additional Criteria
- Parameters
- Multiple Object Queries
- Custom Calculations in a Query
- Calculating Fields continued
Forms and Reports
- Creating a Basic Form
- Creating a Basic Report
Day 2.
Creating a Database
- Database Design.
- Creating Tables using the Table Wizard
- Creating Tables in The Datasheet View
- Creating Tables in the Design View
- Data Types
- Field Properties
- Data Display Format Vs Input Mask
- The Input Mask
- Data Entry Problems
- Moving and Copying Records
Managing Relational Databases
- Types of Relationship
- Creating Table Links
- Referential Integrity
Action Queries
- Types of Query
- The Crosstab Query
- The Make Table Query
- The Append Query
- The Delete Query
- The Update Query
Customising Forms
- Manipulating Data in the Form
- Creating a New Form
- Using the Form Wizard
- Creating a Form with a Subform
- Modifying and Redesigning the Form.
- Modifying and Redesigning the Form continued
Reports
- The Report Wizard
- Creating a Report with Calculated Totals
- Using the Chart Wizard
- Altering the Chart
- Using the Label Wizard
- Modifying and Redesigning the Report.
- Publishing Access Data on the Web
