Access Beginner 1 updated for Access 365, 2016, and 2019 is currently in production. If you need to learn Access now, watch my Access Beginner 1 for Access 2013. The material is almost exactly the same, and Access hasn't changed that much since then.
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. We'll see AutoNumbers in action, learn how to resize a column, discuss 2-character state codes, only storing digits in phone number fields, various date/time formats that are allowed, what #### in a field means, see how the Date Picker works, what the 2-digit year cutoff date is, how to toggle a yes/no field with the keyboard, how to open the Zoom window, and learn what Dirty records are.
In Lesson 7, coming soon...
Enroll now so that you can participate with us as the videos are posted.
Please feel free to post your questions or comments below. Thanks.
You may want to read these articles from the 599CD News: