Access 2013 Courseware is now available from CustomGuide. Discover what is new in Access 2013.
Here is a brief overview of what you will learn in CustomGuide’s Access 2013 Courseware.
Microsoft Access 2013 is a powerful database program you can use to store all kinds of information, from a simple list to an inventory catalog of thousands of products. Once the information in put in Access, it’s easy to find and analyze. In this course you’ll become familiar with the Access 2013 working environment. You’ll learn about the program screen, how to give commands, use Help, and all the new features that have been added to Access 2013.
There are many great things you can do in Access 2013, but before you can dive in headfirst you need to learn the basics. In this course you will learn how Access’ basic functionality, such as entering date and the basics of tables, forms, queries, and reports.
Creating and Working with a Database
Thankfully, you can stop typing lists of information in Word and Excel by creating a database in Access 2013. In this course you will learn how to create databases that store names, addresses, and any other type of information you can think of.
Finding, Filtering, and Formatting Data
As a database becomes larger and larger, finding a specific record becomes harder and harder. Luckily, Access 2013 has commands, such as Find, Sort, and Filter that can track down particular records. This course will teach you how to use these commands, sort information in a table, and use filters to display only records that meet your criteria.
Working with Tables and Fields
The most useful and efficient databases consist of well-structured tables. This course will explain what you need to know about tables and fields: how to link two related tables, how to create indexes for faster performance, and how to create primary key fields.
Creating Relational Databases
Many people find the concept of relational databases difficult to understand. In this course you will receive a clear understanding of relational databases. You will learn how to link tables together in a one-to-many relationship to create a relational database. You will also learn how to enforce referential integrity to keep records accurate.
Working with Queries
Queries are the superstars of Access 2013. Queries make sense out of all the jumbled records and display only what you need to know. In this course you will learn how to harness the power of queries. You will learn about all the different types of queries and how they function within Access.
Working with Forms
A form created in Access 2013 is just like any ordinary paper form; only you dont have to worry about reading bad penmanship. In Access, forms give you an easy way to enter and view data in a table. In this course you will learn how to create, add content, and create a form.
Working with Reports
Reports are handy to know if you need to print professional copies of any analyzed from your database. This course will explain how to create and work with reports from tables and queries.
Formatting Forms and Reports
Looking to create sharp-looking forms and reports? This course will explain how to format your forms and reports. You will learn how to change appearance of text and add graphics to make forms and reports visually appealing and functional.
Working with Macros
Macros are extremely useful when working in Access 2013. A macro helps you perform routine tasks by automating them. Learn how to create, run, edit, and work with Macro groups to simplify routine tasks.
Now that you are an expert at Access 2013, learn how you can easily share information between different databases and different programs. In this course you will learn how to import and export data from external resources.