Microsoft Access 2013 (Intermediate)

Duration: 3 Days
Contact Hours: 21

---

Course Mode

• Lectures
  
• Hands-on
• Mini-project

---

Target Audience

• Administrators
• IT Personnel
• This training is suitable for those require to handle complex data processing and constantly churn out different reports

---

Benefits

• Bring control into uncontrolled and complex data
• Create validation/ control to prevent garbage data from entering
  
• Process the data in accordance to unique requirements
• Churn out report to satisfy unique needs of relevant people
• Maintaining the Access database

---

Course Overview

Getting Started

• Key database concepts
  
• Launching Access and the Backstage screen
  
• Creating the database file
  
• Understanding the Trust Center
  
• Digging in to Ribbon tabs
  
• Using the Navigation pane
  
• Using the Quick Access Toolbar
  
• Signing in to Microsoft Live
  
• Taking backups
  
• Accessing help
  

Creating Tables

• Understanding table structure and relationships
  
• Creating a table and setting data types
  
• Entering data
  
• Understanding primary and foreign keys
  

Setting Fields Properties

• Establishing relationships and maintaining referential integrity
  
• Editing table structure in Design view
  
• Controlling input with masks
  
• Setting the default value
  
• Establishing validation rules
  
• Creating lookup fields
  
• Setting additional field properties
  

Organizing Records

• Formatting columns
  
• Sorting table data
  
• Filtering table data
  
• Searching and replacing values
  

Using Queries

• Understanding queries
  
• Creating queries with the Simple Query Wizard
  
• Building queries in Design view
  
• Establishing constraints with criteria
  
• Specifying criteria with wildcards
  
• Leveraging multiple criteria with AND and OR statements
  
• Filtering with mathematical comparisons
  
• Creating flexible queries with parameter requests
  
• Building expressions
  
• Obtaining summary statistics
  

Working with Specialty Queries

• Using update queries
  
• Using make table queries
  
• Using delete queries
  
• Using append queries
  
• Getting a different look with crosstab queries
  
• Creating a union query in SQL view
  

Creating Forms

• Understanding the role of forms
  
• Generating forms from tables
  
• Adjusting form elements in Layout view
  
• Using the Form Wizard
  

Designing Forms

• Creating forms in Design view
  
• Exploring the form property sheet
  
• Setting data sources
  
• Adding components with form controls
  
• Understanding input boxes
  
• Recording navigation
  
• Adding buttons
  
• Assigning tab order
  
• Checking out the More Forms options
  
• Creating a navigation form
  

Creating Reports

• Introducing reports
  
• Using the Report Wizard
  
• Creating a report in Design view
  
• Grouping and sorting records
  
• Creating calculated totals
  
• Applying conditional formatting rules
  
• Creating labels
  
• Adjusting print settings
  

Working with Macros

• Creating macro
  
• Embedding macros into buttons
  
• Attaching data macros to tables
  
• Launching macros at startup
  

Integrating Access with the Office Suite

• Exporting tables to Excel
  
• Emailing with macros
  
• Linking to data in an Outlook database
  
• Setting up labels and mail-merge documents in Word
  

Maintaining the Database

• Organizing the Navigation pane with custom groups
  
• Compacting and repairing the database
  
• Examining database object relationships
  
• Documenting your work
  
• Printing the blueprint of your database with the Database Documenter
  
• Splitting a database into front and back ends
  
• Protecting the database with a password
  
• Creating customer Ribbon tabs
  
• Setting startup options and custom icons
  

---