Course duration
(we will customise to your learning requirements and timeframe)
Target audience
This course is designed for those who need to devleop the skills to create a new database, design data tables, design forms and reports, and create simple queries.
Course Objectives
At the end of the course participants will be able to:
- Understand the fundamental properties of a database
- Understand the major components of Microsoft Access
- Use the Database Wizard to create a database
- Create, edit and add data to tables
- Search for data
- Design customised forms and reports
- Create Query Tables using a variety of methods
- Understand and create Relationships between tables
- Create Applied Queries
Fundamentals
- Databases
- Tables
- Database management systems
- Starting & exiting Access
- Creating a Database
- Rules governing database filenames
- Opening an existing Database
- The Database Wizard & the table Wizard
Tables
- Designing a Table
- Fields and field data types
- Rules governing field names
- The Primary key
- Datasheet and design View
- Table design guidelines
- Entering data into a Table
- Managing Objects
Finding Data
- Finding by record number
- Finding by value
- Wildcards
- Find and replace
- Filtering records
- Filter by selection and form
Introductory Forms
- Creating a Form
- Opening an existing Form
- Filtering records
Form Design
- Form design & design View
- Mouse Modes
- Selecting, resizing and moving controls
- Grids
- Aligning and spacing controls
- Editing Labels
- Deleting Controls
- Basic design tools
- Formatting toolbar
Introductory Reports
- Creating a Report
- AutoReport
- The Report Wizard
Report Designing
- Design View
- Formatting
- Aligning Controls
Field Properties
- Field Properties and Size
- Validation Rule and Text
- LookUp Field Properties
Relationships
- Relational Databases
- Foreign Keys
- Relationship Window
- Adding Tables
- Creating One to Many Relationships
- Saving the Relationships Window Layout
- Subdatasheets
- Main/Subforms
Building Simple Queries
- Creating a Query
- Design View
- Adding Fields
- Datasheet View
- The QBE Grid
- Sorting
- Criteria
- Logical Operators
- Relational Operators
Applied Queries
- Multi-Table Queries
- Parameter Queries
- Applications in Forms and Reports
- Action, Update and Delete Query
Other Access Training Courses
Access Advanced
Access Queries and Reports
StressLess Learning, Microsoft Access Training Experts