Microsoft Access Level 1 - Beginner Access

Name: Microsoft Access Level 1 - Beginner Access
Rating: 4.5 (95 reviews)

Learn Microsoft Access skills that will give you a solid foundation from a Microsoft Certified Access Specialist

Created byKirt Kershaw

Last updated 4/2021

English

What you'll learn

How to create an Access Database from scratch
Create Tables to store and organize all raw data
Use a Query to search and retrieve data fast
Enter and view records in a more organized layout using Forms
Generate very detailed, professional looking Reports
Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training

Course content

8 sections • 46 lectures • 7h 32m total length

Introduction13:20
Access training video on the basic introduction to Access as a relational database, or a database that breaks the data down into its smallest most meaning parts, or tables and then links those tables in a relationship to pull data as needed, and thereby making process more efficient for both user and computer.

Exercise Files, Instructor's Notes, Quiz & Answers5:58
Exercise Files - the exercise files are provided for you to practice what you've learned after watching the training videos. The exercise files are numbered, and are the exact same as the instructor uses in the video
Instructor Notes - are quick notes about the main points covered in the training videos, and are typically used to reference a point quickly without having to watch the entire training video over again
Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare

Access Overview - First Look13:34
Access training video on the basic overview of the application itself including: startup screen, Ribbon, Navigation pane, working area, Status Bar and more!
New Tell Me What You Want Or Help Feature1:48
Access training video on the new Tell Me What You Want that is part of the Help feature, and is used to find answers to questions about features in Access, as well as execute commands.
Change Office Theme4:40
Access training video on how to change the Office Theme which is basically the color scheme of the application's layout, as well as default database folder, setting User name and Initials.
Quick Access Toolbar7:02
Access tutorial on how to customize the Quick Access Toolbar by adding commands in numerous ways, and how to remove them as well as you'll see in this Access training video.
Customize Ribbon9:01
Access training video on how to customize the Ribbon including adding and removing tabs, commands and groups.
Datasheet Appearance1:46
Access training video on how to customize the Datasheet's appearance including it's font size.
Document Window Options7:25
Access training video on the three Document Window Options which is how you want the Access working windows to operate including: Overlapping Windows, Tabbed Documents and Display Document Tabs.
Basic Introduction to Tables, Queries, Forms & Reports13:41
Access training video on the basics of the four major objects in Access including: Table, Query, Form and Report.
Create a New Database6:41
Access training video on how to create a new database file for your tables, queries, forms and reports.
Basics Quiz

Creating Tables23:18
Access 2016 training video on how to create a table that is used to store raw data, and which queries, forms and reports are built upon.
Entering Records in Tables4:35
Access 2016 training video on how to enter in records in a table efficiently with some tips, tricks and shortcuts.
Export Table to XPS or PDF3:31
Access 2016 training video on how to export a table to XPS, or PDF file format to send to someone who doesn't have Access on their computer, or as a quick snapshot of a table.
Table Structuring9:31
Access 2016 training video on table structuring in a way that allows you to create relationships between tables from a poorly designed database.
Tips for Managing Tables5:25
Access 2016 training video on tips for managing your tables including: deleting, renaming and hiding tables, table descriptions, and object groups.
Basics on Primary, Composite & Foreign Keys13:51
Access 2016 training video basics on creating Primary, Composite and Foreign keys, as well as how and when to use them in your tables, prior to creating relationships between two or more tables.
Basic Introduction Setting Up Tables for Relationships7:35
Access 2016 training video on how to setup up tables to relate to one another by creating Primary and Foreign key fields.
Create One-to-Many Relationships17:48
Access 2016 training video on how to create a One-to-Many relationship between two tables, where you can have basically one record linked to many other records like: one customer that has many orders. This also includes enforcing referential integrity, cascade updates to related fields and deleting related records.
Create One-to-One Relationships13:29
Access 2016 training video on how to create a One-to-One relationship between two tables, where you can have basically one record linked to one other record like: one client that has one billing contact for that client. This also includes enforcing referential integrity, cascade updates to related fields and deleting related records.
Denormalization or Denormalize13:32
Access 2016 training video on denormalizing an a table, or breaking tables down into smaller, more meaningful parts i.e. tables. For example, a poorly designed database would have all the information like: clients, customers, orders, shipping, products loaded into one table, instead of one table for each meaningful part.
Managing Table Data15:03
Access 2016 training video on how to manage your table's data including how to: enter, modify, update and delete records.
Sorting Records5:11
Access 2016 training video on how to sort your table's records.
Filtering Records10:03
Access 2016 training video on how to filter your table's records.
Subdatasheets11:43
Access 2016 training video on subdatasheets which are datasheets nested within datasheets, or like tables within tables, but that are related. In other words, it's the ability to look up related data in another table without leaving your current table's datasheet view.
Tables Quiz

Query Wizard19:22
Access 2016 training video on how to create a query by using the Query Wizard, which is a step by step process where Access asks you questions and based upon your answers creates your query!
Basics on Creating a Query in Design View12:15
Access 2016 training video on how to create a query by Design, or in the design view including adding: tables and fields from those tables to the query.
Setting Query Criteria20:58
Access 2016 training video on how to set criteria for your query including: text, numbers, dates, blank, empty fields.
Add a Calculating Field7:33
Access 2016 training video on how to create a field that performs a calculation on other fields using functions, or formulas.
Grouping Records & Totals8:15
Access 2016 training video on how to group your records, and add a calculation to that group by using the Totals feature.
Customize Table or Query Datasheet3:39
Access 2016 training video on how to customize your table's or query's datasheet including: banded rows, alternating colors, font types, cell effects and more!
Queries Quiz

Basic Introduction to Forms18:42
Access 2016 training video on the basic introduction to a Form, and includes how to sort and filter records in a form.
Create Forms Instantly12:06
Access 2016 training video on how to create a Form instantly! Also, I'll show you here how to edit your Instant Forms including working with stacked and tabular layouts, and how to remove them as well.
Form Wizard5:58
Access 2016 training video on how to use the Form Wizard to create a Form quickly for your database.
How to Modify & Edit Forms14:49
Microsoft Access 2016 training video on how to edit and modify the database's Forms in the Design View including: moving, aligning, resizing labels, text boxes or fields as well as changing the Tab Order, or the order of fields you can tab to in the Form view.
Forms Quiz

Report Views8:11
Microsoft Access 2016 training video on the different type of views to view, print or edit your reports including: Report View, Layout View, Design View and Print Preview.
How to Create Instant Reports8:48
Microsoft Access 2016 training video on how to create an instant report including the different report views: Layout, Design and Print Preview.
Step by Step Report Wizard10:37
Microsoft Access 2016 training video on how to create a Report step by step using the Report Wizard!
Ceate Custom Calculating Fields22:19
Microsoft Access 2016 training video on how to create a field that you can add a formula, or function to and do some calculations by itself, or with other fields in your reports!
Formatting Controls6:16
Microsoft Access 2016 training video on how to format numbers in your Reports by working with the Formatting Controls, which include formatting to currency, decimal places and data formats.
Applying Themes5:29
Microsoft Access 2016 training video on how to apply a Theme to your Reports, which is a collection of complimentary fonts and colors.
Inserting Images7:41
Microsoft Access 2016 training video on how to insert images into your Reports, and thereby making them more aesthetically pleasing.
Insert Background Images & Watermarks9:27
Microsoft Access 2016 training video on how to insert background images, or watermarks into your Reports and make them appear more aesthetically pleasing, or to help with identification of the topic or type of report a person is reading.
Inserting Hyperlinks4:07
Microsoft Access 2016 training video on how to insert background images, or watermarks into your Reports and make them appear more aesthetically pleasing, or to help with identification of the topic or type of report a person is reading.
Microsoft Access 2016 Reports: Prepare for Print6:31
Microsoft Access 2016 training video on how to insert hyperlinks into your Reports, in the Report View, which can be helpful for outside referencing of data found within the Report.
Reports Quiz

Requirements

This course was created with Access 2016; however, all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007
You will need Microsoft Access installed on your computer to follow along and complete the exercise files

Description

Quickly Get a Solid Foundation on Access Basics

During this Microsoft Access Level 1 – Beginner course you will gain a solid foundation on which you will build the rest of your Access experience on. Enroll now and I'll guide you step-by-step, through the basics of creating relational databases and working with Tables, Queries, Forms and Reports. In very little time you will master the basics of Access that'll provide a sure foundation for more advanced Access techniques.

At completion of this course you will have mastered the most popular Access basic tools and have the foundational skills with a sureness to complete many daily Access tasks with efficiency and ease. Below are just a few of the topics that you will master in Access:

Build a solid understanding on the basics of Microsoft Access
Step by step in creating Microsoft Access Databases
Create Tables and how to enter, filter and sort Records
Create Primary, Composite and Foreign keys to link Tables
How to create relationships One-to-One and One-to-Many
Create a Query and how to add calculating fields
Create Forms to view records in a more organized layout
Use Reports to display your records in printable and/or email formats

Who this course is for:

This Microsoft Access Beginner Level 1 course is for anyone who is just starting out in Access
For those who’ve used Access, but want to find out some little-known tips, tricks and shortcuts and become more efficient
Anyone who wants all the training needed from all three Levels of my Access courses to take the Microsoft Access 2016 (77-730) Exam and become certified

Microsoft Access Level 1 - Beginner Access

What you'll learn

Explore related topics

Course content

Access Introduction1 lecture • 13min

Access Level 1 - Beginner1 lecture • 6min

Basics9 lectures • 1hr 6min

Tables14 lectures • 2hr 35min

Queries6 lectures • 1hr 12min

Forms4 lectures • 52min

Reports10 lectures • 1hr 29min

Course Wrap Up1 lecture • 1min

Requirements

Description

Who this course is for: