
By TED Integrated
Developing Application Database Using Microsoft® Access 2013



By TED Integrated
![]() |
![]() |
![]() |
![]() |
Developing Application Database Using Microsoft® Access 2013
Training Category:
Information Technology
Target Audience:
Anyone who are interested to use Microsoft Access as light-weight database for application development and to learn some basics of relational database.
Duration:
2 Days
![]() |
Request for Quotation |
![]() |
+603-2386-7788 |
![]() |
training@ted.com.my |
- Language: English
- PowerPoint Presentation
- Presentation Handouts
- Computer Lab Work
- Certificate of Participation
Course Introduction ›
One of the most efficient and powerful information management approaches used by many software and web applications is Relational Database. It helps to manage large amount of information for a company to facilitate application development and produce meaningful reports. Data can be stored, linked, and managed using a single relational database application and its associated tools.
In this 2-day training course, you will be introduced to the concept of relational database in Microsoft® Access 2013 and its information management tools.
Course Objectives ›
By the end of this Microsoft Access course, participants should be able to:
- Understand the concepts of database
- Manage the data in a database.
- Examine existing table relationships.
- Query the database.
- Design simple forms.
- Create and modify access reports
Course Outline ›
Module 1: The Basics
- Getting Started
- Signing In
- Creating a Database
- Database Terminology
- Saving a Database
- Opening a Database
Module 2: Your First Database
- About Security Warnings
- About Relationships
- Searching for Objects
- Opening Database Objects
- Changing the Object View
- Understanding the Types of Views Available
- Managing Objects
Module 3: Working with Tables and Records
- Creating a Table
- Understanding Table Views
- Adding and Editing Records
- Searching and Browsing Records
- Deleting Records
- Printing Records
Module 4: Formatting Tables
- Selecting Data
- Changing Column and Row Width and Height
- Applying Text Formatting
- Applying Gridlines
- Changing Fill Colors
- Checking Your Spelling
Module 5: Creating Forms
- Creating a Form from an Object
- Creating a Form with the Wizard
- Creating a Form from Scratch
- Understanding Form Views
- Using a Form
Module 6: Formatting Forms
- Understanding Bound and Unbound Controls
- Changing the Theme
- Using the Format Painter
- Adding Fields
- Adding Controls
- Adding Images and Logos
Module 7: Creating Reports
- Creating a Report from an Object
- Creating a Report with the Wizard
- Creating a Report from Scratch
- Understanding Report Views
- Printing Reports
Module 8: Formatting Reports
- Changing the Theme
- Using the Format Painter
- Grouping and Sorting Data
- Adding Controls
- Adding Images and Logos
- Adding Page Numbers, Headers, and Footers
Module 9: Creating Basic Queries
- Types of Queries
- Creating a Query with the Wizard
- Running a Query
- Understanding Query Views
- Sorting and Filtering a Query
Module 10: Creating Advanced Queries
- Creating and Using Parameter Queries
- Creating and Using Crosstab Queries
- Creating and Using Make-Table Queries
- Creating and Using Multiple Table Queries
- Creating and Using Append Queries
- Creating and Using Delete Queries
- Creating and Using Update Queries
Module 11: Managing Your Database
- Compacting and Repairing a Database
- Encrypting a Database with a Password
- Backing Up Your Database
- Exporting a Database and Database Objects
- Printing Database Objects
Module 12: Customizing the Interface
- Collapsing and Pinning the Ribbon
- Customizing the Quick Access Toolbar
- Hiding and Showing Ribbon Tabs
- Creating Custom Ribbon Tabs
- Resetting Interface Changes
Contact us now ›
|
|
![]() |
![]() |
Related Courses ›
- Microsoft® Access 2010/2013 Intermediate
- Microsoft® Access for Intermediate / Advanced Level
- Business Intelligence with Microsoft® Excel 2010 & PowerPivot – Level 2
- Microsoft® Excel 2010: Task Automation with VBA Using Macro
- Integrating Microsoft® Excel Power Query Technology
- More other Information Technology related courses