MOS Access 2013

Syllabus

Unit 1 - Getting started

• 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 2 - Databases and tables

• 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 3 - Fields and records

• 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 4 - Data entry rules

• 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 5 - Basic queries

• 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 6 - Using forms

• Create forms
• Create and modify forms in Design view
• Sort and filter records by using forms

Unit 7 - Working with reports

• 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 8 - Relational databases

• 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 9 - Related tables

• 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 10 - Complex queries

• 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 11 - Advanced form design

• 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 12 - Reports and printing

• 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 13 - Charts

• Create and modify a chart in a form
• Create and modify a chart in a report

Unit 14 - Querying with SQL

• 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 15 - Advanced queries

• 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 16 - Macros

• Create and run macros to automate tasks
• Attach macros to events of database objects

Unit 17 - Advanced macros

• 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 18 - Importing, exporting and linking objects

• 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 19 - Database management

• Work with database utilities to optimise resources
• Protect a database with a password and encryption
• Set Access options and database properties

Assessment

To earn the MOS certification you must sit a separate examination (Access 2013 77-424). The exam is in a multiple choice/multiple answer format. It must be sat at a registered Certiport testing centre. You can locate testing centres and schedule exam appointments via Prodigy UK (www.prodigyuk.co.uk), where you can also buy exam vouchers for £65.00.

Please note that you may be charged by the exam centre an additional proctoring fee of approximately £20 for sitting the exam.

Study Hours

This is only an approximate figure and is dependant upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material. Furthermore, at the end of each lesson there is a question paper that needs to be completed and returned to your tutor. You should allow at least 1 - 2 hours of study to complete each question paper.

The approximate amount of time required to complete the course is: 99.94 hrs.