• Courses
    • Microsoft Technical
      • Microsoft Azure
      • Microsoft Exchange Server
      • Microsoft SQL Server
      • Microsoft SharePoint
      • Microsoft Office 365
      • Microsoft Teams
      • Microsoft Visual Studio
      • Microsoft Windows Server
      • Microsoft Windows Client
    • Microsoft Office
      • Microsoft Excel-Advanced
      • Microsoft Excel-Basic
      • Microsoft Word-Advanced
      • Microsoft Word-Basic
      • Microsoft Power BI
      • Microsoft Access
      • Microsoft PowerPoint
      • Microsoft Project
      • Microsoft Publisher
      • Microsoft Visio
    • Security
      • CCSA – Check Point Certified Admin
      • CND-Certified Network Defender
      • CSCU – Certified Secure Computer User
      • CEH-Certified Ethical Hacker v11
      • CAST 611-Advanced Penetration Testing
      • CISM – Certified Information Security Manager
      • CISA-Certified Information Systems Auditor
      • CISSP – Certified Information Systems Security Professional
    • CCNA
    • AWS
    • Cisco
    • Oracle
    • Linux
      • LPI
      • Red Hat
    • Adobe
      • Photoshop-Basic
      • Photoshop-Advanced
      • Illustrator
      • InDesign
      • Dreamweaver
      • Flash
      • Premiere Pro
    • Autodesk
    • Project Management
    • Service Management
    • SPSS
    • Web Design
    • VMware
  • Certifications
    • Microsoft Technical
      • Microsoft Certified: Azure Administrator Associate
      • Microsoft Certified: Data Analyst Associate
      • Microsoft 365 Certified: Modern Desktop Administrator Associate
      • Microsoft 365 Certified: Enterprise Administrator Expert
      • Microsoft Certified: Azure Developer Associate
    • Microsoft Office
      • MOS: Associate (Office 365 and Office 2019)
      • MOS: Expert (Office 365 and Office 2019)
      • MOS-Microsoft Office Specialist
      • Microsoft 365 Certified
      • Microsoft Certified: Power BI Data Analyst Associate
    • Security Specialist
      • CND-Certified Network Defender
      • CSCU
      • CEH – Certified Ethical Hacker v11
      • CAST 611 – Advanced Penetration Testing
      • CISA – Certified Information Systems Auditor
      • CISM – Certified Information Security Manager
      • CISCO SECURITY
    • Cisco
      • CCNA – Cisco Certified Network Associate
    • ECDL Standard
    • Linux
      • Linux Professional Institute
    • Oracle
      • OCA – Oracle Certified Associate: PL/SQL Developer
      • OCA – Oracle Certified Associate: Database 11g Administrator
      • OCA – Oracle Certified Associate: Database 12c Administrator
    • VMware
    • Project Management Professional ( PMP )
    • Service Management
    • Pearson Vue
  • Solutions
    • For Business
    • For Individuals
    • Training Options
  • Contact
  • More
    • About Us
    • Request Info
    • Become a Trainer
    • News & Events
    Tel: (+357) 22.81.81.01
    Tel: (+357) 25.37.38.00
    sales@aktina.com.cy
    AKTINA – IT Training Center
    • Courses
      • Microsoft Technical
        • Microsoft Azure
        • Microsoft Exchange Server
        • Microsoft SQL Server
        • Microsoft SharePoint
        • Microsoft Office 365
        • Microsoft Teams
        • Microsoft Visual Studio
        • Microsoft Windows Server
        • Microsoft Windows Client
      • Microsoft Office
        • Microsoft Excel-Advanced
        • Microsoft Excel-Basic
        • Microsoft Word-Advanced
        • Microsoft Word-Basic
        • Microsoft Power BI
        • Microsoft Access
        • Microsoft PowerPoint
        • Microsoft Project
        • Microsoft Publisher
        • Microsoft Visio
      • Security
        • CCSA – Check Point Certified Admin
        • CND-Certified Network Defender
        • CSCU – Certified Secure Computer User
        • CEH-Certified Ethical Hacker v11
        • CAST 611-Advanced Penetration Testing
        • CISM – Certified Information Security Manager
        • CISA-Certified Information Systems Auditor
        • CISSP – Certified Information Systems Security Professional
      • CCNA
      • AWS
      • Cisco
      • Oracle
      • Linux
        • LPI
        • Red Hat
      • Adobe
        • Photoshop-Basic
        • Photoshop-Advanced
        • Illustrator
        • InDesign
        • Dreamweaver
        • Flash
        • Premiere Pro
      • Autodesk
      • Project Management
      • Service Management
      • SPSS
      • Web Design
      • VMware
    • Certifications
      • Microsoft Technical
        • Microsoft Certified: Azure Administrator Associate
        • Microsoft Certified: Data Analyst Associate
        • Microsoft 365 Certified: Modern Desktop Administrator Associate
        • Microsoft 365 Certified: Enterprise Administrator Expert
        • Microsoft Certified: Azure Developer Associate
      • Microsoft Office
        • MOS: Associate (Office 365 and Office 2019)
        • MOS: Expert (Office 365 and Office 2019)
        • MOS-Microsoft Office Specialist
        • Microsoft 365 Certified
        • Microsoft Certified: Power BI Data Analyst Associate
      • Security Specialist
        • CND-Certified Network Defender
        • CSCU
        • CEH – Certified Ethical Hacker v11
        • CAST 611 – Advanced Penetration Testing
        • CISA – Certified Information Systems Auditor
        • CISM – Certified Information Security Manager
        • CISCO SECURITY
      • Cisco
        • CCNA – Cisco Certified Network Associate
      • ECDL Standard
      • Linux
        • Linux Professional Institute
      • Oracle
        • OCA – Oracle Certified Associate: PL/SQL Developer
        • OCA – Oracle Certified Associate: Database 11g Administrator
        • OCA – Oracle Certified Associate: Database 12c Administrator
      • VMware
      • Project Management Professional ( PMP )
      • Service Management
      • Pearson Vue
    • Solutions
      • For Business
      • For Individuals
      • Training Options
    • Contact
    • More
      • About Us
      • Request Info
      • Become a Trainer
      • News & Events

      Exam 77-424: Microsoft Office Specialist (MOS) – Microsoft Access 2013

      • Home
      • Exams
      • Exam 77-424: Microsoft Office Specialist (MOS) – Microsoft Access 2013

      Exam 77-424: Microsoft Office Specialist (MOS) – Microsoft Access 2013

      Skills Measured:

      This exam is designed for candidates who have a fundamental understanding of the Access 2013 environment and the ability to complete tasks independently. They should know and demonstrate the correct application of the principal features of Access 2013

      The topics examined are stated in detail below:

      Create and manage a database (20–25%)
      • Create a new database
        • Create new databases, create databases using templates, create databases in older formats, create databases using wizards
      • Manage relationships and keys
        • Edit references between tables, create and modify relationships, set primary key fields, enforce referential integrity, set foreign keys, view relationships
      • Navigate through a database
        • Navigate to specific records, set a form as the startup option, use navigation forms, set navigation options, change views
      • Protect and maintain a database
        • Compact databases, repair databases, back up databases, split databases, encrypt databases with a password, merge databases, recover data from backups
      • Print and export a database
        • Print reports, print records, maintain backward compatibility, save databases as templates, save databases to external locations, export to alternate formats
      Build tables (25–30%)
      • Create a table
        • Create new tables, import external data into tables, create linked tables from external sources, import tables from other database, create tables from templates and application parts
      • Format a table
        • Hide fields in tables, change data formats, add total rows, add table descriptions, rename tables
      • Manage records
        • Update records, add new records, delete records, append records from external data, find and replace data, sort records, filter records, group records
      • Create and modify fields
        • Add fields to tables, add a validation rules to fields, change field captions, change field sizes, change field data types, configure fields to auto-increment, set default values, use input masks, delete fields
      Create queries (15–20%)
      • Create a query
        • Run queries, create crosstab queries, create parameter queries, create action queries, create multi-table queries, save queries, delete queries
      • Modify a query
        • Rename queries, add new fields, remove fields, hide fields, sort data within queries, format fields within queries
      • Utilize calculated fields and grouping within a query
        • Add calculated fields, add conditional logic, group and summarize data, use comparison operators, use basic operators
      Create forms (15–20%)
      • Create a form
        • Create new forms, create forms with application parts, save forms, delete forms
      • Set form controls
        • Move form controls, add form controls, modify data sources, remove form controls, set form control properties, manage labels
      • Format a form
        • Modify tab order in forms, format print layouts, sort records, apply themes, change margins, insert backgrounds, auto-order forms, insert headers and footers, insert images, modify existing forms
      Create reports (15–20%)
      • Create a report
        • Create new reports, create reports with application parts, delete reports
      • Set report controls
        • Group data by fields, sort data, add sub-forms, modify data sources, add report controls, manage labels
      • Format a report
        • Format reports into multiple columns, add calculated fields, set margins, add backgrounds, change report orientation, change sort order, insert headers and footers, insert images, insert page numbers, apply themes, modify existing reports
      Course(s):
      Microsoft Access
      Certification(s):
      Private: MOS: Microsoft Office Specialist 2013
      • Visit us on:

      LEMESOS (LIMASSOL)

      22 Griva Digeni Avenue, 1st floor 3106 Agios Nikolaos (200 m. from the roundabout, near Agios Nikolaos church)

      LEFKOSIA (NICOSIA)

      20 Louki Akrita street, 2064 Strovolos (behind Kykko secondary schools)

      Popular Courses

      Implementing and Administering Cisco Solutions (CCNA)

      Implementing and Administering Cisco Solutions (CCNA)

      Free
      20740: Installation, Storage and Compute with Windows Server 2016 – Official Microsoft Course

      20740: Installation, Storage and Compute with Windows Server 2016 – Official Microsoft Course

      Free
      20697-1: Implementing and Managing Windows 10 – Official Microsoft Course

      20697-1: Implementing and Managing Windows 10 – Official Microsoft Course

      Free

      Limassol Training Center

      22 Griva Digeni Avenue, 1st floor 3106 Agios Nikolaos (200 m. from the roundabout, near Agios Nikolaos church) Lemesos (Limassol), Cyprus

      (+357) 25.37.38.00

       

      Nicosia Training Center

      20 Louki Akrita street, 2064 Strovolos (behind Kykko secondary schools) PO Box 25252, CY-1308 Lefkosia (Nicosia), Cyprus

      (+357) 22 81.81.01

       

      TOP COURSES

      • 20740: Windows Server 2016
      • 20483: Programming in C#
      • 20480: HTML5 ,JavaScript…
      • VMware vSphere
      • Oracle Database: Backup and Recover

      Recommended

      • Security
      • Microsoft
      • Oracle
      • Cisco
      • Linux
      • Adobe

      Contact

      sales@aktina.com.cy

      Developed by AKTINA . IT Training organisation in Cyprus.

      • COURSES
      • CERTIFICATIONS
      • SOLUTIONS
      • CONTACT

      BECOME A TRAINER

      Join our team of trainers and earn money hassle free!

      Get Started Now