Microsoft Access 2007- Beginners
Short course
In
Description
-
Type
Short course
-
Level
Beginner
-
Methodology
Inhouse
-
Duration
1 Day
In this hands-on course, you will learn the basic operations of the Microsoft Access Database program. You will explore how it can help you to manage your day-to-day responsibilities as well as learning about the advantages that using a relational database program can bring to your business processes. The course will include designing and creating new databases, tables, and. Suitable for: Suitable for someone who wants to learn how to use access
Reviews
Course programme
Course review:
In this hands-on course, you will learn the basic operations of the Microsoft Access Database program. You will explore how it can help you to manage your day-to-day responsibilities as well as learning about the advantages that using a relational database program can bring to your business processes. The course will include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database.Microsoft Access 2007 Training Course (Beginners) Outline
- Exploring the Access Environment
- Examine Database Concepts
- Explore the User Interface
- Explore the Ribbon
- Customize the Access Environment
- Obtain Help
- Use an Existing Access Database
- Designing a Database
- Describe the Relational Database Design Process
- Define Database Purpose
- Review Existing Data
- Determine Fields
- Group Fields into Tables
- Normalize Data
- Designate Primary and Foreign Keys
- Determine Table Relationships
- Building a Database
- Create a New Database
- Create a Table
- Manage Tables
- Create a Table Relationship
- Managing Data in a Table
- Modify Table Data
- Sort Records
- Work with Subdatasheets
- Querying a Database
- Filter Records
- Create a Query
- Add Criteria to a Query
- Add a Calculated Field to a Query
- Perform Calculations on a Record Grouping
- Designing Forms
- View Data Using an Access Form
- Create a Form
- Create a Form Using the Form Wizard
- Modify the Design of a Form
- Generating Reports
- View an Access Report
- Create a Report
- Create a Report Using the Report Wizard
- Add a Custom Calculated Field to a Report
- Format the Controls in a Report
- Apply an AutoFormat to a Report
- Prepare a Report for Print
Microsoft Access 2007- Beginners