18 Topics
5 Days
57 Sessions
Programme Overview
Training Description
Who Should Attend
The course targets individuals who wish to establish a foundational understanding of Microsoft Office Access, including the skills necessary to create a new database, construct data tables, design forms and reports and create queries
Session Objectives
- Restructure data into appropriate tables to ensure data dependency and minimize redundancy
- Write queries to analyse and summarize data
- Create and revise macros
- Customize reports
- Maintain databases using Microsoft Access tools
- Build and work with online databases.
- Create and publish web databases.
- Save a changed database to the web.
- Learn keyboard shortcuts and access keys.
- Learn to work with security protocols
About the Course
Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. Microsoft Access is a very popular program used worldwide to build and run databases. Databases created with MS Access can also be viewed and edited online by uploading them to SharePoint. Microsoft implements some safety precautions when you work with online files, and this course will show you how to activate your content after you download it. This course will also review keyboard shortcuts which help you work faster by relying more on the keyboard. You do not need any prior experience working with Access to undertake this course, but if you are familiar with previous versions, then this course will help you quickly make the transition to the upgraded version, Microsoft Office 2013, that would be used in this course.
Curriculum & Topics
18 Topics | 57 Sessions
-
Workshop 1.1:
Database concepts
-
Workshop 1.2:
Exploring the Access environment
-
Workshop 1.3:
Getting help
-
Workshop 2.1:
Planning and designing databases
-
Workshop 2.2:
Exploring tables
-
Workshop 2.3:
Creating tables
-
Workshop 3.1:
Changing the design of a table
-
Workshop 3.2:
Finding and editing records
-
Workshop 3.3:
Organizing records
-
Workshop 3.4:
Data entry rules
-
Workshop 4.1:
Creating and using queries
-
Workshop 4.2:
Modifying query results and queries
-
Workshop 4.3:
Performing operations in queries
-
Workshop 5.1:
Creating forms
-
Workshop 5.2:
Using Design view
-
Workshop 5.3:
Sorting and filtering records
-
Workshop 6.1:
Reports
-
Workshop 6.2:
Modifying and printing reports
-
Workshop 7.1:
Database normalization
-
Workshop 7.2:
Relating tables
-
Workshop 7.3:
Implementing referential integrity
-
Workshop 8.1:
Lookup fields
-
Workshop 8.2:
Modifying lookup fields
-
Workshop 8.3:
Subdatasheets
-
Workshop 9.1:
Joining tables in queries
-
Workshop 9.2:
Calculated fields
-
Workshop 9.3:
Summarizing and grouping values
-
Workshop 10.1:
Adding unbound controls
-
Workshop 10.2:
Adding Graphics
-
Workshop 10.3:
Adding calculated values
-
Workshop 10.4:
Adding combo boxes
-
Workshop 10.5:
Advanced form types
-
Workshop 11.1:
Customized headers and footers
-
Workshop 11.2:
Adding calculated values
-
Workshop 11.3:
Printing
-
Workshop 11.4:
Labels
-
Workshop 12.1:
Charts in forms
-
Workshop 12.2:
Charts in reports
-
Workshop 13.1:
SQL and Access
-
Workshop 13.2:
Writing SQL statements
-
Workshop 13.3:
Attaching SQL queries to controls
-
Workshop 14.1:
Creating crosstab queries
-
Workshop 14.2:
Creating parameter queries
-
Workshop 14.3:
Using action queries
-
Workshop 15.1:
Creating, running, and modifying macros
-
Workshop 15.2:
Attaching macros to the events of database objects
-
Workshop 16.1:
Creating macros to provide user interaction
-
Workshop 16.2:
Creating macros that require user input
-
Workshop 16.3:
Creating the AutoKeys and AutoExec macros
-
Workshop 16.4:
Creating macros for data transfer
-
Workshop 17.1:
Importing objects
-
Workshop 17.2:
Exporting objects
-
Workshop 17.3:
Interacting with XML documents
-
Workshop 17.4:
Linking Access objects
-
Workshop 17.5:
Working with Windows SharePoint Services
-
Workshop 18.1:
Optimizing resources
-
Workshop 18.2:
Protecting databases
