Brightmoon Consulting & Training

  • Home
    • Gallery
    • Testimonial
  • Contact Us
  • Home
    • Gallery
    • Testimonial
  • Contact Us
Microsoft Access

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

    I'm interested. Let's get connected.

Submit
Powered by Create your own unique website with customizable templates.