Most of the organizations maintain and manage huge amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be designed, stored, linked, and managed using a single relational database application and its associated tools.
Microsoft Access 2007 is an application used to create small and medium-sized relational databases for the Microsoft Windows family of operating systems. It can also be used as a database server for a web-based application. It is also supported by ADO , OLEDB, ODBC, and the .NET Framework, etc.
Microsoft Access 2007 now makes it easier for anyone to use, or create powerful database solutions to help organize, access, and share data, in no time.
By completing the entire two parts Microsoft Access 2007 training, students will:
• Know how to use and design tables, forms, and queries.
• Know how to link information and automate data entryreate Queries to find and select records by criteria, and write, test, and update those queries.
• Understand how to create forms with subforms to represent one-to-many relationships.
• Create a Search Form that uses a Combo Box to filter the records.
• Learn to use criteria, parameters, concatenation, and operators in Query designs: calculate with DateDif(),Left(), and IIF(), improve report designs with Sorting and Grouping.
• Know how to use Microsoft Access and Word together in a Mail Merge, as well as publish an Access report to Word, and optimize a database for multiple users.
Workshop topics to be covered:
Section 1: Exploring the Access 2007 Environment
Essential Database Concepts
Explore the User Interface
Explore the Ribbon
Customize the Access Environment
Use an Existing Access Database
Section 2: Designing a Database
Describe the Relational Database Design Process
Define Database Purpose
Review Existing Data
Group Fields into Tables
Designate Primary and Foreign Keys
Determine Table Relationships
Section 3: Building a Database
Create a New Database
Create a Table
Create a Table Relationship
Section 4: Managing Data in a Table
Modify Table Data
Work with Subdatasheets
Section 5: Querying a Database
Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Grouping
Section 6: Designing Forms
View Data Using an Access Form
Create a Form
Create a Form Using the Form Wizard
Modify the Design of a Form
Section 7: 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