MS Access 2013/16 – Set of 3 Interactive Courses

access-2013

  • Category : Microsoft Office 2013/16
  • Course Name : MS Access 2013/16 – Set of 3 Interactive Courses
  • Instruction Language : English
  • No. of Courses : 3
  • No. of Lessons : 66
  • Est. Study Time : 33 hours
  • Price : R1675 ( Includes Vat % ) | (USD $99)

MS Access 2013/16 – Set of 3 Interactive Courses

MS Office 2013

Microsoft Access is a program designed for creating and managing relational databases. In three courses dedicated to this program, you will learn step by step to create such databases and to process their data. Within the first lessons, you will get acquainted with the program environment and the used terminology. You will learn to design tables, set the properties of their fields and try the entry of data to them. You will link the individual tables with each other via relations and will set the relation properties. You will also learn how to structure the entire database to be able to use it efficiently. Then you will learn to select specific data from the created tables via queries, in combination with calculations to achieve new data. You will also learn to use special action queries. You will examine how to arrange the data from tables and those derived by queries using forms and reports in order to print them or to make the entry of new data easier even to other users. You will learn to create macros that will automate the work in a database and will control whether the entered data comply with the set rules. You will also familiarise yourself with the options of importing and exporting data in databases and saving their individual objects.

List of Courses:


MS Access 2013/16: Introduction

In the course MS Access 2013/16: Introduction, you will familiarise yourself with the terminology concerning relational databases and with the basics of working in the Access program. You will try various ways of creating tables and setting the properties of their fields. You will learn to further analyse the data in tables through select queries, including the creation of calculated fields in them. You will set relations between tables and ensure their referential integrity. You will also familiarise yourself with an easy way of creating simple forms and reports.

Lessons:

  • Introduction to databases
  • Program interface and the database objects
  • Creating a table in the Datasheet view
  • Creating a table in the Design view
  • Special field types and working with fields
  • Designing databases
  • Analysis of the relations between tables
  • Relations and referential integrity
  • Working with tables
  • Searching and editing records
  • Filtering and sorting records
  • Select queries
  • Sorting records in select queries
  • Working with criteria in select queries
  • Calculated fields
  • Joining tables in queries
  • Creating a lookup column
  • Editing the query of a lookup column
  • Creating forms
  • Creating reports

MS Access 2013/16: Intermediate

In the course MS Access 2013/16: Intermediate, you will learn to create calculated fields in queries that operate with functions. You will create totals queries and parameter queries. You will familiarise yourself with the properties of table joins and will examine how they can affect the result of queries. You will create forms in the Design view and will learn to insert calculated fields into them. You will also design and edit reports and will learn to perform various calculations in them. You will also learn how to insert controls into forms and reports, including subforms and subreports.

Lessons:

  • Copy and import data
  • Query with parameters
  • Join properties
  • Custom joins
  • Function and Expression Builder
  • Other function categories
  • Indexing fields and validating data
  • Totals
  • Aggregate functions
  • Crosstab query
  • Sort and pick data in forms
  • Form in Design View
  • Form creation in Design View
  • Edit a form
  • Form controls
  • Calculated form fields and conditional format
  • Combo Box in forms
  • Option buttons in forms and change form source
  • Form fields organizing
  • Form with subform creation
  • Subforms and aggregate functions in Design View
  • Command button
  • Totals in reports
  • Calculations and sorting in reports
  • Additional report options
  • Reports graphical editing

MS Access 2013/16: Advanced

In the course MS Access 2013/16: Advanced, you will familiarise yourself with action queries. You will examine different types of queries in the SQL view and will get acquainted with the essential clauses of this language. You will learn to create and use macros to automate your work with databases. You will explore importing and exporting of objects and their data. You will examine the printing options of different objects in details and you will familiarise yourself with normalisation of data. You will also examine the options of navigation in a database.

Lessons:

  • Update and append queries
  • Other action queries
  • SQL language and specific query types
  • SQL – domain functions and subqueries
  • Pick up parameters from forms
  • Macro basics
  • Assigning a macro to a button
  • Data validation via macros
  • Data evaluation via macros
  • Data exporting
  • Objects importing and splitting a database
  • Programmatic import and export
  • XML format
  • Object dependencies and properties inheritance
  • Navigation in a database
  • Security and privacy in databases
  • Database print and documentation
  • Data normalization

College Africa Group is the African Continent’s authorised partner for Gopas. GOPAS is one of the major IT training providers. Its technical courses are annually attended by almost 30,000 students, mostly IT specialists.


System Requirements

The courses have been developed using Flash technology. For this reason the minimum system requirements for a user PC are very low:

  • Any of following internet browsers: Internet Explorer 8.0 or higher, Opera, Mozilla Firefox, Chrome; all with the Adobe Flash plug-in version 8.0 or higher
  • 1 GHz CPU; 512 MB RAM; OS Windows XP or higher
  • Display resolution of 1280 x 1024
  • Sound card, speakers or headphones are recommended

System Requirements For Using LMS

  • Processor: 1 GHz or higher
  • Memory: 512 MB RAM
  • Display resolution 1280 × 1024 or higher
  • Any of following internet browsers: Internet Explorer 8.0 or higher, Opera, Mozilla Firefox, Chrome; all with the Adobe Flash plug-in version 8.0 or higher
  • Operating system for online or internal LMS use: Windows XP or higher or Mac OS (+ Opera browser)
  • Sound card and speakers/headphones are recommended

MS Office 2013

Download TOC for MS Access 2013/16
Buy