Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Courses   Tips   Templates   Forums   Help   Order   Contact   Logon  
 
 
Access Developer 14, Lesson 1

Courses > Access > Developer > Level 14 > Lesson 1 Prev: Contents | Next: Lesson 2

Lesson 1. Easy Access POS Part 1: Database Structure (30:14)

We will begin by learning about the database we're going to be building: The Easy Access POS. We'll talk about the features it will have, see the layout of the screens, and discuss possible future upgrades. Lots of you have asked me to spend more time on planning and laying out databases ahead of time. Here you go!

Loading...

Next: Lesson 2

This lesson covers:

  • Planning the Database
  • Discussing Features to be Built
  • Groups & People (Family & Students)
  • Products & Categories
  • Discounts, Adjustments, Tax, Tip
  • Unbound Modal Popup Forms
  • Barcode Scanner Capable
  • Avoiding Multi-User Problems
  • Touch-Screen Friendly
  • Payment & Payment Types
  • Credit Cards, Cash
  • Popup Keypad for Numeric Entry
  • Calculate Change
  • Voiding Sales
  • Multiple Locations
  • Manager Menu
  • Edit Lists, System Settings
  • Edit Orders & Payments
  • Sales Charts & Graphs
  • List of Groups with Open Balances
  • Mail Statements
  • Detailed Sales Reporting
  • Possible Future Upgrades

Post your comments or questions below.

 

Reports Link 
Larry Aldama     
Wed 7/1
When thinking about reports... We always compare to track trends month to month.  There are plenty of ways to compare but most important to us are monthly, weekly, or daily.  Within that we like same day, or week, last year. Most managers I know use Excel to compare. We typically take POS data and I enter it into Access to generate custom reports.
Richard Rost    
Thu 7/2
Thanks, Larry.
Add a Reply
Adding Food Pictures Link 
Dawood Fardan 
Wed 6/24
The only comment I can add to the POS is adding pictures to the food items that makes it easy for users who do not have the command of English language and expediency. You are the expert and you are doing an excellent job Mr. Rost. Keep the good work going.  one more thing the less details about the customers the better. Read More...
Richard Rost    
Wed 6/24
It will most likely be something we add in after the class is built. I see your point. Let's get it functional first, and then add this as an option.
Add a Reply
Happy with Outline Link 
Mubeezi Micah     
Wed 6/24
i am happy with the outline, now looking forward to the entire course.
MICAH
Add a Reply
Multi-currency transactions Link 
Ingrid Laplanche     
Tue 6/23
Hi Richard,
It would be great if it has the option for multi-currency transactions.
Richard Rost    
Tue 6/23
OK. Definitely something to consider. Thanks!
Add a Reply
Love the new format Link 
jannette jones     
Tue 6/23
Love the new format and how you plan a database. I also love how you are incorporating touch screen and signature i just added a text box field on a project i was working on. I would love to have you have a class on sql server and attaching the database to a sql server.
Richard Rost    
Tue 6/23
Thanks. Attaching to SQL Server is definitely coming soon.
Add a Reply

Show Older Posts

 

Post Your Comments
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

You may want to read these articles from the 599CD News:

6/30/2020Access Seminars
6/29/2020Access Create Duplicate Record
6/28/2020Access Times as a Duration
6/25/2020Access D14 Lessons 2, 3 Ready
6/20/2020Access Developer 14
6/17/2020Access Time 12 hour NO am/pm
6/16/2020Access Handbook News
6/16/2020Access Developer 7 Handbook
6/7/2020Working on Access Dev 14
6/6/2020Access Beginner Level 1
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search The Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

YouTube Channel    LinkedIn

Blog RSS Feed   
Keywords: access developer 14 lesson 1  PermaLink