23+ Years of Professional Service – Fully Accredited, Quality Guaranteed!
MS-Access2018-08-27T23:06:28+00:00

MS-Access

[Under Our Professional-Plus Course Series]

This program is provided at Basic, Basic/Intermediate* and Advanced Levels [*Time&Cost-Saving Option]
Please see the Course Outlines
Also note the Prerequisites [Course Readiness Requirements – What Learners need to already know without struggle]

MS-Access is a Relational Database Management System that helps PC-Users to create and manage custom databases that store large amounts of related information together; for easy reference and accuracy, reporting, and analytical techniques.

With this program PC-Users can effectively create and manage important information in custom tables, queries, forms, report creation features, use of external data sources, macros, and more…

  • Fewer errors and inconsistencies – maintain one database version, minimizes duplication, errors and inconsistent values.
  • High productivity – need only change one record and all other related items will automatically change.
  • Security and Control – central location to store, secure, and good control of data.
  • Assists decision making – a single data source with various integrated categories of information and many reporting and analytical tools.

Since MS-Access is a relational database application which allows PC-Users to enter, manage and run reports on a large scale, it is most suitable for those who need to organize and control large amounts of data quickly and professionally.

Best suited for, but not limited to: Sales Reps, Data Capturers, Office Administrators, Store/Warehouse Personnel, Head of Departments, Managers, Supervisors…

Course Outline: MS-Access 2007/2010 /2013/2016: Basic (i)

Prerequisites

MS-Word and Excel, or equivalent experience

Outline

Database concepts
– Identifying database components
– Identifying the advantages of relational databases

Exploring the Access environment
– Starting Access and examining the Access window
– Opening a database
– Using the Navigation Pane
– Examining a database table

Getting help
– Using Help

Planning and designing databases
– Planning a database
– Creating a database from a template
– Creating a blank database

Exploring tables
– Discussing views
– Examining a table in Datasheet view
– Navigating in a table in Datasheet view
– Examining a table in Design view

Creating tables
– Creating a table by using the table templates
– Creating a table in Design view
– Adding fields and descriptions to a table
– Setting the primary key
– Saving the table
– Adding a record
– Copying, modifying, and deleting a table
– Creating a composite key

Changing the design off a table
– Modifying field names
– Deleting and inserting fields
– Moving a field
– Using the Attachment data type
– Adding a total row

Finding and editing records
– Finding and replacing a value
– Undoing changes

Organizing records
– Sorting records by a single field
– Sorting records by multiple fields
– Using Filter By Selection
– Using Filter By Form
– Using Filter Excluding Selection
– Using Advanced Filter/Sort
– Deleting a record

Setting field properties
– Setting the Required property
– Using the Allow Zero Length property
– Setting the Field Size property
– Setting the Append Only property

Working with input masks
– Creating an input mask
– Working with the Input Mask Wizard

Setting validation rules
– Creating validation rules
– Setting validation text

Creating and using queries
– Planning a query
– Using the Query Wizard
– Creating a query in Design view
– Saving and running the query
– Sorting query results
– Filtering a query by adding criteria
– Creating a query from a filter

Modifying query results and queries
– Editing query results
– Adding fields to a query
– Finding records with empty fields

Performing operations in queries
– Using comparison operators
– Using the OR condition
– Using the AND condition
– Using the * wildcard
– Using calculations in a query
– Totalling a group of records
– Using the Avg and Count functions
– Using the Min and Max functions

Creating forms
– Examining a form
– Creating a basic form
– Creating a form using the Form Wizard

Using Design view
– Creating a form in Design view
– Adding controls
– Modifying properties
– Applying conditional formatting

Sorting and filtering records
– Using a form to sort records
– Using a form to filter records

Reports
– Examining a report
– Creating a basic report
– Creating a report using the Report Wizard
– Creating a report using Design view

Modifying and printing reports
– Modifying a report in Design view
– Modifying a report in Layout view
– Grouping, sorting, and filtering a report
– Adding summary fields using the Report Wizard
– Modifying the layout and style of a report
– Printing a report

Download Basic Course Outline

Course Outline: MS-Access 2007/2010 /2013/2016: Intermediate (ii)

Prerequisites

MS-Access Basic, or equivalent experience

Outline

Database normalization
– Discussing the first normal form
– Discussing the second and third normal forms
– Using the Table Analyzer
– Identifying object dependencies

Relating tables
– Establishing a one-to-one table relationship
– Establishing a one-to-many table relationship
– Establishing a many-to-many table relationship
– Printing table relationships

Implementing referential integrity
– Planning table relationships
– Working with orphan records
– Setting cascading deletes
– Testing cascading deletes
– Using cascading updates

Lookup fields
– Creating a lookup field
– Creating a multivalued lookup field

Modifying lookup fields
– Modifying lookup field properties
– Changing a text box to a combo box

Subdatasheets
– Using a subdatasheet

Joining tables in queries
– Creating a query using the Simple Query Wizard
– Creating a join in Design view
– Creating an outer join
– Creating a join with an intermediate table
– Creating a self-join query
– Finding records that do not match between tables
– Finding duplicate records
– Deleting tables from a query

Calculated fields
– Creating a calculated field
– Modifying the format of a displayed value
– Using the Expression Builder

Summarizing and grouping values
– Creating a query to display summary values
– Using queries to concatenate values

Adding unbound controls
– Drawing a rectangle around a control
– Changing tab order
– Grouping controls

Adding graphics
– Adding a graphic to a form
– Embedding a graphic in an unbound object frame

Adding calculated values
– Binding a control to a calculated field
– Creating a calculated control

Adding combo boxes
– Adding a combo box to a form
– Modifying the properties of a combo box

Advanced form types
– Creating a multiple item form
– Creating a split form
– Creating a datasheet form
– Creating a subform

Customized headers and footers
– Adding a report header
– Adding a report footer
– Applying conditional formatting
– Keeping parts of a report on the same page
– Adding controls to group footers
– Forcing a new page

Adding calculated values
– Working with the DateDiff function
– Using the IIf function

Printing
– Printing a table
– Printing a database document

Labels
– Creating labels

Charts in forms
– Creating a chart in a form
– Modifying a chart in a form

Charts in reports
– Adding a chart to a report
– Modifying a chart in a report

PivotTables
– Examining PivotTable view
– Adding fields to a PivotTable

Modifying PivotTables
– Creating totals
– Moving fields in a PivotTable
– Showing and hiding details in a PivotTable
– Formatting fields

PivotCharts
– Creating a PivotChart

PivotTable forms
– Creating a PivotTable form

Download Intermediate Course Outline

Course Outline: MS-Access 2007/2010 /2013/2016: Advanced (iii)

Prerequisites

MS-Access Basic and Intermediate, or equivalent experience

Outline

SQL and Access
– Discussing Structured Query Language
– Examining an SQL statement in Access

Writing SQL statements
– Writing an SQL SELECT statement
– Using the WHERE clause
– Creating aliases
– Displaying matching records from related tables
– Finding unmatched records
– Getting context-sensitive help in SQL

Attaching SQL queries to controls
– Assigning an SQL-specific query to a command button

Creating crosstab queries
– Viewing a crosstab query
– Using the Crosstab Query Wizard

Creating parameter queries
– Creating a single-criterion parameter query
– Creating a query with multiple parameters
– Using a wildcard in a parameter query

Using action queries
– Adding records to a table with an append query
– Deleting records with a delete query
– Modifying records with an update query
– Creating a Make Table query

Creating, running, and modifying macros
– Creating and running a macro
– Modifying a macro

Attaching macros to the events off database objects
– Attaching a macro to the Open event of a form
– Attaching a macro to a command button

Creating macros to provide user interaction
– Creating a data validation macro
– Creating a data-entry macro

Creating macros that require user input
– Creating a macro that runs a parameter query

Creating the AutoKeys and AutoExec macros
– Creating an AutoKeys macro
– Creating an AutoExec macro

Creating macros for data transfer
– Importing a database object by using a macro
– Exporting data to a spreadsheet by using a macro

Importing objects
– Importing multiple objects
– Importing an object from Excel
– Using a Saved Import specification
– Importing a CSV file

Exporting objects
– Exporting an object
– Using a Saved Export specification

Interacting with XML documents
– Exporting and importing XML documents
– Exporting to an XML document with an XSL file
– Saving to an XPS file

Linking Access objects
– Linking to an Access table
– Updating the links
– Linking to an Excel workbook

Working with Windows SharePoint Services
– Discussing Windows SharePoint Services

Optimizing resources
– Converting a database to a prior version
– Analysing performance
– Splitting a database
– Using the Compact and Repair Database utility
– Backing up a database

Protecting databases
– Encrypting a database with a password
– Removing a password and encryption

Setting options and properties
– Setting Access Options
– Creating and populating properties

Hyperlink fields
– Creating a hyperlink field
– Inserting data in a hyperlink field
– Modifying data in a hyperlink field

Working with Outlook 2007
– Collecting data via e-mail

Download Advances Course Outline