Overview
What does the course cover?
This course guides new Access users through the powerful Microsoft Access program introducing them to the concepts and ideas behind relational databases. The course explains the structure, design and capabilities of databases and covers automation using the VBA programming language.
Aims
Why take this course?
To be able to design and build databases incorporating the use of forms, queries and reports. If you want to be able to import and export information from Windows based products and analyse that data. You’ll gain an advanced understanding of this application.
Audience
Who would benefit?
New users of databases and users who have experience using applications like Excel and require the advanced facilities of Access. Also suitable for programmers not familiar with relational databases. Anyone wanting to master the advanced functionality of Access.
Course Preview
Each course contains high quality, professional video lessons, downloadable exercise files and real-world templates for you to use.
Course Details
Section 1: Introduction To Access
- Lesson 1: Introduction
- Lesson 2: Starting Access
- Lesson 3: Opening An Existing Database
- Lesson 4: Exploring The Access Window
- Lesson 5: Closing A Database And Exiting Access
- Lesson 6: Creating A New Database
Section 2: Tables
- Lesson 1: Introduction
- Lesson 2: Opening An Existing Tables
- Lesson 3: Changing, Adding And Deleting Records
- Lesson 4: Sorting And Filtering Records
- Lesson 5: Creating A New Table
- Lesson 6: Primary Keys
- Lesson 7: Field Types
- Lesson 8: Field Properties
- Lesson 9: Indexes
- Lesson 10: Recap Of Definitions
Section 3: Table Relationships
- Lesson 1: Introduction
- Lesson 2: What Is A Table Relationship?
- Lesson 3: Linking To Create A Relationship Between Tables
- Lesson 4: Editing A Link
- Lesson 5: Deleting A Link
Section 4: Queries
- Lesson 1: Introduction
- Lesson 2: What Is A Query?
- Lesson 3: Creating A Query
- Lesson 4: Sorting Records In A Query
- Lesson 5: Specifying Criteria
- Lesson 6: Finding Empty Cells
- Lesson 7: Criteria For Numbers
- Lesson 8: Entering Multiple Criteria
- Lesson 9: Using More Than One Table In A Query
- Lesson 10: Different Query Types
Section 5: Forms
- Lesson 1: Introduction
- Lesson 2: Creating A Form
- Lesson 3: Editing A Forms Design
- Lesson 4: Adding And Editing Data Using A Form
- Lesson 5: Deleting A Form
Section 6: Reports
- Lesson 1: Introduction
- Lesson 2: Creating A Report
- Lesson 3: Editing A Reports Design
- Lesson 4: Printing Report
- Lesson 5: Deleting A Report
Section 7: Preparing Output
- Lesson 1: Introduction
- Lesson 2: Printing A Table And Selected Records
- Lesson 3: Printing A Query, Form And Report
Skills You’ll Learn
What you’ll be able to do after the course
- Create and understand simple relational database models
- Query a database and create summary reports
- Create simple forms and reports for data entry
- Select cells, rows and columns
- Create macros to automate reports and forms
- Editing A Reports Design
How You Can Apply These Skills
What you’ll be able to use these skills for
- Design and build databases incorporating the use of forms, queries and reports
- Design a query to extract information from the database and export that information into other windows based products
- Manipulate expressions and to be able create and edit macros to help automate the use of the database
- Build queries and understand basic SQL syntax
Certification
When you pass you will receive an internationally recognized accreditation certificate like this:
What’s next?
Upon completion, you can move onto our more advanced Excel courses such as Excel Macros or Excel VBA.
Careers that require these skills at this level?
Excel is used in practically every business and in nearly all departments in those businesses – ranging from sales to accounting and administration. Any role that requires the management of databases will require you to be able to use Access.
Want to start learning today?
Joining is simple, easy and risk free with our 7 day money back guarantee.
