|
You have the basic skills needed to work with Microsoft Office Access 2007 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.
In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.
|
|
Upon successful completion of this course, students will be able to:
• Modify the design and field properties of a table to streamline data entry and maintain data integrity.
• Retrieve data from tables using joins.
• Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
• Enhance the capabilities of a form.
• Customize reports to organize the displayed information and produce specific print layouts.
• Share Access data across other applications
• Restructure the data into appropriate tables to ensure data dependency and minimize redundancy.
• Write advanced queries to analyze and summarize data.
• Create and revise Access macros.
• Display data more effectively in a form.
• Customize reports effectively by using various Access features.
• Maintain your database using tools provided by Access
|
|
* Restrict Data Entry Using Field Properties
* Establish a Pattern for Entering Field Values
* Create a List of Values for a Field
* Create Query Joins
* Join Unrelated Tables
* Relate Data Within a Table
* Set Select Query Properties
* Create Parameter Queries
* Create Action Queries
* Design a Form Layout
* Enhance the Appearance of a Form
* Restrict Data Entry in Forms
* Add a Command Button to a Form
* Create a Subform
* Organize Report Information
* Format the Report
* Set Report Control Properties
* Control Report Pagination
* Summarize Report Information
* Add a Subreport to an Existing Report
* Create a Mailing Label Report
* Import Data into Access
* Export Data
* Analyze Access Data in Excel
* Export Data to a Text File
* Merge Access Data with a Word Document |
|
* Analyze Tables
* Create a Junction Table
* Improve Table Structure
* Create Subqueries
* Create Unmatched and Duplicate Queries
* Group and Summarize Records Using Criteria
* Summarize Data Using a Crosstab Query
* Create a PivotTable and a PivotChart
* Create a Macro
* Attach a Macro
* Restrict Records Using a Condition
* Validate Data Using a Macro
* Automate Data Entry Using a Macro
* Display a Calendar on a Form
* Organize Information with Tab Pages
* Display a Summary of Data in a Form
* Include a Chart in a Report
* Print Data in Columns
* Cancel Printing of a Blank Report
* Create a Report Snapshot
* Link Tables to External Data Sources
* Manage a Database
* Determine Object Dependency
* Document a Database
* Analyze the Performance of a Database |
|
|
Students need to take the following course or have equivalent knowledge:
• Microsoft Access 2007: Beginner
Students need to take the following courses or have equivalent knowledge:
• Microsoft Access 2007: Beginner
• Microsoft Access 2007: Intermediate
|
|
|
|
1 Day |
1 days |
Instructor led-learning
|
Instructor led-learning |
At the end of the course the student will be awarded with a Certificate of Attendance |
|
|
Administration Fees : RM200 (Non-Refundable)
Course Fees : Please contact us for more details
|
|
Informatics Kuala Lumpur
09-35 & 09-37, 9th Floor, West Wing,
Berjaya Times Square, 1, Jalan Imbi,
55100 Kuala Lumpur, Malaysia |
(map) |
Course Enquiry Hotline : 03-2148 9188
Email : callcentre@informatics.com.my
Opening Hours :
Monday – Friday : 10.00am to 6.00pm
Saturday : 10.00am to 2.00pm
Closed on Sundays and Public Holidays
* Information here is subject to changes without prior notice.
|
|
|
