Microsoft Access 2013 Level 2

This Microsoft® Access 2013 Certification Guide teaches students how to design data tables, select appropriate data types and relate tables logically. Students will create and modify database objects including tables, forms, reports, queries and macros, and will apply intermediate skills to streamline data entry, ensure data integrity, automate tasks and analyze data.

Students who complete this course will have reviewed all of the exam objectives and be on their way to preparing for Microsoft Office Specialist Access 2013 Exam #77-424. Successful completion of the certification exam provides a competitive advantage by validating the knowledge and skill sets for individuals who may be seeking employment or further job opportunities in their careers.

Course Prerequisites

This course is designed for students who are familiar with personal computers, using a keyboard and using a mouse. The course assumes that students have completed the Microsoft Windows course or have equivalent Microsoft Windows knowledge and experience.

• start and run Windows

• use the taskbar

• use the Start button

• use the Help feature

• use Minimize, Restore Down/Maximize, or lose

• use the left and right mouse buttons appropriately

• understand file management techniques

• navigate between files, folders, or drives

Outline

Lesson 1: Working with Forms

• Why Use Forms?

• The Inside Scoop – Controls and Properties

• Designing a Form

• Form Types

• Form Views

• Creating Forms Using Automated Tools

• Form Tool

• Form Wizard

• Application Parts

• Creating Forms from Scratch

• The Fields List Pane

• The Property Sheet

• Form and Control Properties

• Modifying Forms

• Adding controls

• Removing controls

• Setting Form Properties

• Formatting Forms

• Aligning and Sizing Controls

• Tab Order

• Repositioning controls

• Managing labels

• Modifying data sources

• Setting form control properties

• Working with a Form in Layout view

• Working with a Form in Design View

• Adding Controls from the Ribbon

• Adding Controls in Layout View

• Adding Controls in Design View

• Adding Subforms

• The Visible Property

• Using Lookup Fields on Forms

• Ensuring Accuracy

• Validating Data Entry

• Validation Rules

• The Tab Stop Property

• The Locked and Enabled

• Properties

• Specifying Default Values

• Selecting Controls

• Aligning, Sizing and Spacing Controls

• Formatting Reports

• Working with page size and page orientation

• Changing the Sort Order

• Creating Columns

• Adding Images to Reports

• Adding Page Numbers

• Report headers and footers

• Applying a theme

• Applying Background Images to Reports

• Previewing and Printing Reports

Lesson 2: Designing Reports

• What is a Report?

• Report sections

• Designing a report

• Report layouts

• Controls and properties

• Report Views

• Report View

• Print Preview

• Layout View

• Design View

• Creating Reports

• Using the Report Tool

• Creating a Report Using the Report Wizard

• Creating a Report Using Application Parts

• Creating a Blank Report

• The Field List Pane

• The Property Sheet

• The Record Source Property

• Working with Reports

• Selecting and Formatting Controls

• Moving Controls

• Working with Padding and Margins

• Adding Controls from the Ribbon

• Working with Report Labels

• Adding a Subreport

• Changing the Data Source

• Grouping and Sorting

• Adding Calculated Controls

• Working with Reports in Design View

• Adding controls from the Ribbon

Lesson 2: Managing, Maintaining and Protecting Databases

• Protecting Database Files

• Open Modes

• Encrypting and Password protecting a Database

• Maintaining Database Files

• Saving and publishing a database

• Backing Up a Database

• Recovering Data from a Backup

• Compacting and Repairing

• Managing Databases

• Front-End and Back-End Databases

• Splitting a Database

• Merging Split Databases

• Creating Templates and Application Parts

• Using User Templates

• User-Defined Data Type Templates

• User-Defined Database Templates and Application Parts

• Templates