Join Adam Wilbert for an in-depth discussion in this video Creating customized front ends, part of Access 2013: Tips & Tricks.
…In the last two movies, we split our database into a front end and a back…end and gave each component a separate password…in order to control access to our information.…One of the main advantages to splitting a database is that each end user can receive…a customized front end that is tailor made…for the tasks that they need to accomplish.…Let me show you how we could easily set this up.…Let's suppose we want to have our product development team be able to add new…products to our database, but not have…access to any customer or order information.…Once again, because the data base is split and storing absolute file paths.…
I can't distribute a starting exercise file for this movie, so you'll…need to continue with the files you created in the last two movies.…So let's go ahead and start creating a database specific to our product team.…Right now I've got the KinetEco database open.…This is the front end file that we've been working with.…What I want to do is make a duplicate of this file and…then modify it so that it's tailor made for our product development team.…
- Creating a kiosk experience
- Hiding the ribbon
- Creating cascading combo boxes
- Working with hidden objects
- Creating a separate back end
- Building a dynamic reporting tool
- Writing custom functions in Visual Basic
- Distributing your application
Skill Level Intermediate
1. Creating a Start-up Experience
2. Creating Cascading Combo Boxes
3. Working with Hidden Objects
4. Working with Split Databases
Creating a back end3m 44s
5. Creating a Dynamic Reporting Tool
6. Aiding the End User
7. Writing Custom Functions in Visual Basic
8. Distributing Your Application
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.