Thank you. Click here for more information on how you can set up an account. Say employee gets 40 hrs PTO on Jan 1, if it isn't all used, it is lost. They also accrue Vacation time over the years, this balance carries over At company less than 5 years, carry over 40 hrs, at company more than 5 years, carry over 80 hrs. Vacation is added every two weeks at 3. I'll add it to the list. I'm sure you COULD build something like that after having completed my course - even just up through the Expert series.
But yeah, I could see that being a helpful template. If anyone else is interested, click the LIKE button on this comment. That's how I gauge user interest. I've just found your site about a year ago. I've just begun watching your Access Beginner Series. Figured it would be a good refresher and I might even be reminded of things I'm not doing in the best manner. A way to clean up any bad habits I may have developed over the years.
Thanks for putting the idea on your list. Here's to hoping it gets lots of likes and becomes a seminar. Show 4 More Replies Show Older Comments View in Table Format.
Microsoft Access Templates Templates are pre-designed database templates that you can use to accomplish your goals. New Releases Help Desk Template This database template is a trouble ticketing system for a help desk. Sorry, only students may add comments. John Desselle 10 months ago I've been working in Access for around 20 years now.
Lisa Messer 6 months ago I have changed careers and was hired to maintain an Access DB but that quickly changed to "we need you to Develop".
I had never worked with Access. Now we all know that takes time, more than 8 months of working with Access. I have had no training from the person who built the DB. I took a couple of classes and have been doing your videos. One of the projects that I have been handed is developing a Vacation DB for about employees.
I have pecked around with this for several months and have only gotten a few tables and forms and queries to work together. My boss who is not a DB or IT person, is expecting me to produce something by the end of the year. Record sets are probably out of your current scope. Update Queries may be able to help you. Then just manually run it when it's time to add new PTO time. Adam Schwanz 6 months ago Alternatively, I'm not sure how soon Rick has this on the table, but there is also AccessDev.
NET as an option. Richard Rost 6 months ago It's definitely on the list. It's not on top, but it's on there. I've never done this kind of a database before, so I need to know what kinds of crazy rules ya'll have for giving and using vacation time.
Building the database is a piece of cake for me, at least. To continue on with the full class, click on the Watch Now button below.
Click on the Watch Now button to begin. In Lesson 1 , we're going to learn what Microsoft Access is, and what it's used for. You will learn some database terminology. We'll discuss the benefits of a database. We will learn about the parts of a Microsoft Access database including tables, queries, forms, and reports. In Lesson 2 , we're going to discuss planning your database.
What tables do you need? What fields should go in each table What should your forms and printed reports look like? In Lesson 3 , we're going to get started creating our first new blank database file. We'll go over the Access Interface, switch the setting from Tabbed Documents to Overlapping Windows , and we'll learn how to handle that security warning that comes up when you open an Untrusted Database.
In Lesson 4 , we're going to create our first table. We'll learn about field names , naming conventions, data types, and we'll start building the Customer Table. In Lesson 5 , we're continuing with building the Customer Table.
We're going to decide whether certain fields should be text or number. We'll learn about long integers and doubles. We'll see why you should always include an AutoNumber ID field. You'll see how to move fields around in the table.
We'll save our table, and learn about naming conventions. We'll learn about the Primary Key field. In Lesson 6 , we're going to learn how to enter and edit data in our Microsoft Access Tables. In Lesson 7 , we're going to enter more records into our table.
I'll show you where and how to download my copy of the database so you don't have to do a lot of typing if you don't want to. We'll learn about record selectors , how to turn off the delete confirmation warning , how to save table layout changes, and how to move columns around.
We'll also discuss how AutoNumbers are not reused and why you shouldn't worry about them. In Lesson 8 , we'll learn how to sort and filter our records.
You'll see how to perform a single-field sort. You'll learn the difference between text, numeric, alphanumeric, and date sorts. You'll remove the sort. Then, we'll see how to filter records. If the boss only wants to see customers from New York, you'll know how to apply that filter to display the correct records. You'll learn how to print a table or send it as an email attachment. In Lesson 9 , we'll learn how to create queries to display our data in different ways. We'll see how to add a table to a query, add fields from the table to the query, and run the query to display results.
Then we'll learn how to add sorting to our query using multiple fields, and add criteria. In Lesson 10 , we're going to build a customer form to present our user with a nice friendly interface for adding and editing records. We'll see how the quick form builder works. We'll learn about navigation, layout view, deleting records, and the different types of forms in Microsoft Access.
In Lesson 11 , we're going to learn the right way to build a form using form Design View. Click here for more information on how you can set up an account. Alex Hedley 5 days ago Rich Text. Show 8 More Replies Gregg Moore 4 days ago Yes it is!
Richard Rost 3 days ago What SendEmail function are you using? Expert 20 or the Email Seminar? Gregg Moore 2 days ago I haven't had a chance to subscribe to either yet. I got the following from one of your extended cut videos. Application Dim M As Outlook. Kevin Robertson 2 days ago Greg, You should get your proper formatting if you change from.
RTFBody to. Gregg Moore 2 days ago I agree with you, however users do not have an easy way to update the information which becomes the text body in HTML. Do you know of a simple way they might be able to do this? You just won't get any markups. Sorry, only students may add comments. Can I apply the techniques you teach in Access or will there be limitations as I am not using nor ?
Since brought the new. I would urge to upgrade, if you can, since had so many bugs. You can do the emailing directly in Access and by pass the email program itself. You can have Access open up the Default email program you have set though. You may want to read these articles from the CD News :. Keywords: microsoft access email PermaLink.
0コメント