MOS ACCESS 2013 ESSENTIALS COURSE
Course
Distance
Description
-
Type
Course
-
Level
Intermediate
-
Methodology
Distance Learning
-
Class hours
100h
-
Duration
1 Year
-
Start date
Different dates available
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
Approximate Study Time: 100 Hours (Selft Study) Buy Now More Info The MOS (Microsoft Office Specialist) Microsoft Access 2013 Course will help students to master Microsoft Access 2013. The course is ideal for beginners and takes users to an advanced level of proficiency. Designated as Approved Courseware for the Microsoft Office Specialist program, this course will help students prepare for the Access 2013 exam (77-424). You will learn how to create database tables, queries, forms, and reports, and how to sort and filter data. Additional topics include table relationships, referential integrity, joins, charts, PivotTables, PivotTable charts and forms. You will also learn how perform more advanced tasks such as querying with SQL; using crosstab, parameter and action queries; creating and running Macros; importing, exporting and linking database objects; optimising databases and implementing basic database security.
Facilities
Location
Start date
Start date
About this course
There are no particular entry requirements as the course is set out for beginners although students will require their own version of Microsoft Access 2013 to complete the course.
On completion of this course students can apply for the Microsoft Office Specialist Access 77-424 Examination.
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 15 years
Subjects
- Access
- Security
- Basic
- IT
- Basic IT training
- Office IT
- Database
- SQL
- Database training
- Basic IT
- Ms Office
- IT Security
- Microsoft Access
- Microsoft Office
Course programme
MOS Access 2013 Course Book
The Course book covers the functions and features of Access 2013, explained in detail with a summary at the end of each unit.
Unit One - Getting started
Learn how to: Organise data efficiently by using a database management system. Start Access, learn about it's environment, open a database file with shared access and learn about database objects
Unit Two - Databases and tables
Learn how to: Plan and create a database. Examine a table in Datasheet view and Design view. Create and modify tables, create a primary key and create a composite key.
Unit Three - Fields and records
Learn how to: Modify a table design by changing field names, inserting and deleting fields, moving fields and using the Attachment data type. Find and replace data in a table, and hide and freeze fields. Sort, filter and delete records.
Unit Four - Data entry rules
Learn how to: Set properties for a field. Create input masks for fields and use the Input Mask Wizard. Set validation rules for entering data in a field.
Unit Five - Basic queries
Learn how to: Plan, create, save and run queries, and use queries to sort data and to filter query results. Modify queries and query results by adding fields and find records with empty fields. Perform operations in queries by using comparison operators, use AND and OR conditions in queries, and use expressions and aggregate functions.
Unit Six - Using forms
Learn how to: Create forms. Create and modify forms in Design view. Sort and filter records by using forms.
Unit Seven - Working with reports
Learn how to: Create reports by using the Report button, the Report Wizard, Design view and Layout view. Group and sort records in a report, summarise information in a report, change the report layout and style, and print a report.
Unit Eight - Relational databases
Learn how to: Normalise tables, use the Table Analyser and identify object dependencies. Set relationships between tables, and print a report listing the table relationships. Implement referential integrity between related tables.
Unit Nine - Related tables
Learn how to: Use the Lookup Wizard to create a lookup field and a multi-valued field. Modify properties for a lookup field. Use subdatasheet to add to related tables.
Unit Ten - Complex queries
Learn how to: Create outer join, inner join and self join queries, find non-matching records and duplicate records and delete tables from a query. Create calculated fields in a query, and use the Expression builder. Use queries to view summarised grouped data from tables.
Unit Eleven - Advanced form design
Learn how to: Add unbound controls to a form, change the tab order of controls, group controls and format a form for printing. Use controls to add graphics to a form. Use controls to add calculated fields to a form. Add a combo box to a form. Create multiple-item forms, split forms, datasheet forms, subforms and navigation forms.
Unit Twelve - Reports and printing
Learn how to: Customise report headers and footers, set properties for grouping data in the report, use conditional formatting and change a report's appearance. Add calculated values to a report by using functions and add a subreport. Print database objects and a report on database design. Create and print labels.
Unit Thirteen - Charts
Learn how to: Create and modify a chart in a form. Create and modify a chart in a report.
Unit Fourteen - Querying with SQL
Learn how to: Use SQL statements and examine them in Access. Write SQL statements to create queries and subqueries, and assign aliases to fields. Create a SQL-specific query and attach it to a command button.
Unit Fifteen - Advanced queries
Learn how to: Create crosstab queries to summarise grouped data. Create parameter queries to view results based on specific criteria. Create action queries to add, delete and modify data in tables and to make tables.
Unit Sixteen - Macros
Learn how to: Create and run macros to automate tasks. Attach macros to events of database objects.
Unit Seventeen - Advanced macros
Learn how to: Create data validation and data entry macros. Create macros that run parameter queries. Create AutoKeys and AutoExec macros. Create AutoKeys and AutoExec macros. Create macros to import and export database objects.
Unit Eighteen - Importing, exporting and linking objects
Learn how to: Import objects from another Access database, from Excel and from CSV files. Export objects from an active database to another Access database. Export and import XML documents. Link objects from one database to another and update the links. Create and modify hyperlink fields.
Unit Nineteen - Database management
Learn how to: Work with database utilities to optimise resources. Protect a database with a password and encryption. Set Access options and database properties.
Assessment:
Assessment is in the form of MOS Examinations. MOS 2013 Examinations are project-based simulations which are designed to offer real world exercises to appraise a student's understanding of using Microsoft Office.
Additional information
MOS ACCESS 2013 ESSENTIALS COURSE