Microsoft Access 2013 skills are important to have in any profession or workplace. From basic data entry, preparation of spreadsheets and budgets, and management of data including sales and inventory, developing a skill set working with Access will allow you to work independently and efficiently problem solve.
This online course will teach you the skills you need to work with Access 2013 and prepare you to take the Microsoft Office Specialist Certification Exam 77-424. The material is presented in a step-by-step manner and you will learn it by completing readings and hands-on exercises, in addition to watching video presentations. The course also includes quizzes and exams so that you can assess your skills at regular intervals.
Instructor(s):
Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications. Requirements:
Hardware Requirements:
- This course must be taken on a PC. Macs are not compatible.
Software Requirements:
- Windows 10 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft 2013 Office Suite (not included in enrollment).
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Manuals are included as downloadable PDFs throughout the course.
Hide Syllabus
Lesson 1
- Quick Overview of the Access User Interface
- Access Ribbon
- Quick Access Toolbar
- Object Navigation Pane
- Access Work Surface
- Access Options Dialog Box
- Object Overview
- Process Overview
- Fundamentals
- Approaches to Database Design
- Gather Information
- A Few Words about Naming Conventions
- Exercise: Gathering Information
- Normalization
- Table Relationships
- Tables and Their Views
- Definition and Purpose
- Datasheet View
- Design View
- Tables
- Creating an Access Database
- Data Types
- Create a Table in Design View
- Queries
- Queries
- Select Queries
- Select Queries with Criteria
- Logical Operations
- Forms
- Forms
- One-Click Forms
- Form Wizard
- Reports
- Reports
- One-Click Report
- Report Wizard
- Optional: Databases and Access Terms
- "Database" Defined
- Databases vs Spreadsheets
- Questions to Ask When Deciding Whether to Use a Spreadsheet or a Database
- Access vs Excel
- Discussion Questions
- "Relational Database" Defined
- Terminology
- Observations
- "Relational Database Management System" (RDBMS) Defined
- Access Is an RDBMS
- Benefits and Limitations of Access
- Discussion Questions
- Relationships
- Review
- Referential Integrity
- Relationships
- A Few Words about Naming Conventions
- Queries
- Query Design View
- Review of Select Queries
- Review of Select Queries with Criteria
- Logical Operations
- Parameter Queries
- Action Queries
- Table Functions
- Importing Data
- Exporting Data
- Forms
- Design View
- Formatting
- Tab Order
- Reports/Design View
- Report Sections
- Adding a Report Header/Footer
- Adding a Logo to the Report Header
- Adding a Title to the Report Header
- Adding Fields to a Report
- Arranging Fields on a Report
- Resizing the Detail Section
- Eliminating Repeating Headings
- Grouping and Sorting
- Setting Properties on a Report
- Adding Record Counts
- Special Report Fields
- Controls
- Printing a Report
- Macros
- Macro Basics
- Running a Macro
- Completing the Desktop Application
- The Navigation Form
- Running Macros from a Navigation Form
- Setting the Navigation Form as the Default Form
- Splitting the Database
- Distributing the Front-end Database
Hide Syllabus
|