Microsoft Access for Beginners - The Complete Beginner's Guide to Access

Focused View

Chester Tugwell

3:24:01

7 View

439210 01 Introduction to the Course.mp4

01:24

439210 02 Download the Course Files.mp4

00:47

439210 03 Flat vs Relational Databases. Why Relational Databases are More Efficient..mp4

04:41

439210 04 Create and Save a New Access Database.mp4

01:53

439210 05 Understand Access Objects.mp4

06:56

439210 06 Naming Conventions.mp4

01:23

439210 07 Create the Camrof Ltd Products Table.mp4

05:12

439210 08 Create the Camrof Ltd Suppliers Table.mp4

02:53

439210 09 Understand & Use the Caption Property.mp4

02:06

439210 10 Understand & Use the Field Size Property.mp4

04:17

439210 11 Understand & Use the Format Property.mp4

02:17

439210 12 Understand & Use the Lookup Wizard to Create Drop Downs.mp4

01:59

439210 13 Understand & Use the Field Description.mp4

01:42

439210 14 Enter a Record in the Products Table.mp4

04:08

439210 15 Enter a Record in the Suppliers Table.mp4

03:09

439210 16 Import Records into the Products Table.mp4

03:41

439210 17 Import Records into the Suppliers Table.mp4

01:33

439210 18 Sort Records in a Table.mp4

03:09

439210 19 Filter Records in a Table.mp4

07:25

439210 20 Apply Formatting to the Datasheet View.mp4

01:44

439210 21 Freeze Columns in a Table.mp4

02:19

439210 22 Build Relationships Between Tables Using the Relationships Window.mp4

09:50

439210 23 Build Relationships Between Tables Using the Lookup Wizard.mp4

06:56

439210 24 Create the Product Form Part 1.mp4

03:21

439210 25 Create the Product Form Part 2 Placing Controls.mp4

06:20

439210 26 Create the Product Form Part 3 Designing the Form.mp4

01:55

439210 27 Create the Product Form Part 4 Formatting Controls.mp4

03:23

439210 28 Create the Product Form Part 5 The Form Header and Footer.mp4

03:51

439210 29 Create the Products Form Part 6 Adding Command Buttons.mp4

07:51

439210 30 Create the Products Form Part 7 Form Properties.mp4

03:14

439210 31 Create the Supplier Form Part 1 Using the Layout View to Create a Form.mp4

03:15

439210 32 Create the Supplier Form Part 2 Formatting Controls in the Layout View.mp4

04:33

439210 33 Create the Supplier Form Part 3 Finishing Touches.mp4

08:20

439210 34 Create a Form Which Includes a Subform Using the Form Wizard.mp4

09:12

439210 35 Create Your First Select Query.mp4

05:52

439210 36 Create a Select Query That Includes Two Related Tables.mp4

04:47

439210 37 Create a Select Query That Uses And Or Criteria.mp4

04:57

439210 38 Create a Select Query That Uses Comparison Operators.mp4

02:39

439210 39 Create a Select Query That Uses Between And Criteria.mp4

01:46

439210 40 Create a Query That Uses Wildcard Criteria.mp4

04:15

439210 41 Create the Products Report Part 1.mp4

06:57

439210 42 Create the Products Report Part 2.mp4

06:50

439210 43 Create the Suppliers Report Using the Report Wizard.mp4

08:26

439210 44 Create a Navigation Form Part 1.mp4

10:52

439210 45 Create a Navigation Form Part 2.mp4

05:56

439210 46 Create a Navigation Form Part 3.mp4

03:09

439210 47 Student Project Teala Training Database.mp4

00:56

es.FiLES.zip

Description

This introduction to Microsoft Access provides the perfect foundation for developing expertise. Even though it is a beginner’s course, delegates will build two fully functioning relational databases. Chester Tugwell, your course tutor, started his Microsoft Access training career back in the late 1990s and over the years he has fine-tuned his content and delivery to culminate in this excellent course.

Chester has designed this course to be as hands-on as possible. It is project-based and takes you through the steps involved in building an Access relational database from the ground up.

Topics Covered in the Course

Relational Database Theory – what is a relational database and how does it compare to the way data is stored in Excel, for example?

Tables – designing tables to store data. Setting data types and field properties.

Importing Data – importing data into your Access database stored in Excel or as text files.

Creating Relationships Between Tables – understanding primary and foreign keys and creating relationships between tables.

Design Forms – that look great and function well.

Select Queries – understand how to set AND/OR criteria, use comparison operators and wildcards.

Design Reports – that look professional.

Create a Front-End for your Database – create a navigation form with command buttons that open your forms and reports. Set database options that control what appears/doesn’t appear to your users when they open the database.

The course was created using Access 365 (2019) but will work for earlier versions.

What You'll Learn?

Technology
Databases
Microsoft Office
Data Science
Design Form
Microsoft Access
Access Beginners

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Microsoft Access

Chester Tugwell

Instructor's Courses

My name is Chester Tugwell. I am a self-employed IT trainer with 25 years' experience in a commercial and public sector context. I have run MS Office courses in literally hundreds of companies, providing tailored training made relevant to the workplace. I hope you enjoy my course!

SkillShare

View courses SkillShare

Skillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.