This is a Microsoft Access tutorial covering, how to create a sales database part 1. The tutor starts off by creating a customer table and a products table. The tutor explains how validation rules and default field settings work. In the product table calculated fields are used to work out vat and total sales. The tutor then creates a relationship between the two tables and creates a query displaying customer sales. This is an Access database tutorial, covering table design, calculated fields, query design and table relationships. This is part 1 of the sales database series. Microsoft Access is a relational database package.
#msaccess
#salesdatabase
Join this channel to get access to perks:
/ @itseasytraining1st
Most popular video at the moment: Photos in a form, • Adding photos in an Mi...
If you want to support me, check this out: / itseasy
Online training courses:
itseasytraining.teachable.com/
www.udemy.com/course/microsof...
Playlists for this channel:
Access: • Unleash the POWER of S...
Excel: • Link web based data in...
Word: • How to use Microsoft W...
Visio: • How to create a basic ...
Project: • How to use Baselines a...
PowerPoint: • Zoom feature in Micros...
Publisher: • How to set or create B...
OneNote: • OneNote Overview, link...
Office 365: • Video
#itseasytraining
Classroom based courses can be arranged at www.itseasy.co.uk/
Courses are available through Microsoft Teams, Online and Face to face in the UK
Online courses at itseasytraining.teachable.com/
Udemy Courses www.udemy.com/user/stephen-sa...
Training Guide Books
Excel for New Managers
www.amazon.co.uk/Excel-New-Ma...
Microsoft Project Overview www.amazon.co.uk/Microsoft-Pr...
Microsoft Visio Basic www.amazon.co.uk/Microsoft-Vi...
Very cheap E_books are here:
Excel For New Managers payhip.com/b/IE4x
Microsoft Project Overview payhip.com/b/wY0m
Microsoft Visio Basics payhip.com/b/5XeV
Microsoft Access Introduction payhip.com/b/ynSL
A PowerPoint Overview payhip.com/b/YkQv
Негізгі бет Тәжірибелік нұсқаулар және стиль This video explains how to create a sales database in Microsoft Access
Пікірлер: 15