A relational database application such as Microsoft Office Access 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.
You might use a database to store
records of assets or inventory, customer information, sales transactions, maintenance schedules, statistical data, quality measures, and so forth. In fact, virtually any sort of information that can be entered into a computer can be stored in a database. Let's get started. (Lesson Introduction)
You might use a database to store records of assets or inventory, customer information, sales transactions, maintenance schedules, statistical data, quality measures, and so forth. In fact, virtually any sort of information that can be entered into a computer can be stored in a database. Let's get started. (Lesson Introduction)
Learn when to choose Access over Excel. (Typical database management tasks Access handles better than Excel)
A table is a storage container that stores data in rows and columns. Learn to perform some basic tasks in a table. (Record Navigation Bar, Navigate, Edit, Save, Delete, New Record)
Forms provide a graphical user interface (GUI) for entering and modifying table data. (Forms, Record Navigation Bar, Edit, Save, Delete, New Record)
You might have never worked with a relational database before, so let me explain what a relational database is.
Tables give a database its structure, providing an organized place to store data. Data is useful, however, only if it can be located, retrieved, and presented in meaningful ways.
Queries provide the means to locate and retrieve data in a database. (Queries, Filter Data)
Reports provide a publish-ready view of data that you can output to various pront or digital formats. (Print Preview)
You have opened and edited existing database objects like tables, queries etc. - now it's time to create your Access Database and the first table! (Database Templates, Field Data Types, Primary Key)
As you work with Access, you might need to look for additional information. The Tell Me feature might help you save time find the command in the ribbon. (Help, Tell Me)
Lern how to customize Access to your needs. (Options, Trust Center, Quick Access Toolbar)
You created the basic table structure within a database. To keep data in these tables current, you need to know how to add, delete, and update data in a table. (Lesson Introduction)
Learn how to modify table data. (Autocorrect, Commit, Save and Undo)
The Record navigation bar Search text box provides a quick means to jump to a specific record. (Search box)
The Find and Replace dialog box enables you to quickly locate and change database information. (Find, Replace)
The term "ask questions" might be a little unfamiliar at first, but learn why database developers use that term frequently.
Learn how to use the Totals row to add summary values to a table. (Totals (count of records or the sum, average, maximum, minimum, standard deviation))
As you work with a database, it can be helpful to temporarily sort or filter a table to show only records that match certain criteria. (Sort, Filter)
Now it gets exciting, because queries allow you to work with data in a very flexible way. (Lesson Introduction)
The Simple Query Wizard prompts you through steps to create a query. (Query Wizard)
Learn how to use the Query Design feature to create a new query in Design view. This tool give you the maximum flexibility creating the queries you need. (Query Design, Naming Conventions)
Learn how to use query criteria to specify which records should be included in a query result. (Comparison Operators (=, <, >, etc.). Logical Operators (AND, OR, NOT))
You can use various wildcard characters in conjunction with query criteria. Wildcards enable you to match records based on patterns, rather than requiring a literal character-by-character match. (Wildcards (*, #, ?, etc))
(Date, Range, The Zoom Dialog Box)
In a large table, it may be difficult to work with records if they are not displayed in a useful order. (Sort, Multi-Level-Sort)
In many instances, you will need to perform calculations on the data stored in your database. Because the tables already store the data that will be used to perform the calculations; therefore, the calculations should be executed in queries, forms, and reports. (Arithmetic Operators (+, -, *, /, ^), Expression Builder)
If your Access desktop database is going to be used by multiple users, a well-designed form is essential for efficiency and data entry accuracy. (Lesson Introduction)
Working in a database will only takes you so far, Forms display and change data, accept new data, and interact with the user. (Form View, Form Wizard)
Navigate in Forms, Search for Records, Filter Records, Sort Records
Learn why properties are used extensivly in forms and reports.
Properties are named attributes of controls, fields, and database objects. Learn how to set properties to modify the characteristics of a control, field, or object. (Property Sheet, Hide Fields, Hide Ribbon Commands)
A lookup field is a field in one table that is bound to another value in a source data table or value list. The lookup field can a display a list of user friendly values to select from. (Lookup Fields, Relationships View, Foreign Key, Control Wizards, Combo Box, Referential Integrity)
As your database starts to accumulate useful information, you may want to produce reports that you can use for analysis and subsequent publishing to print or digital form.
Learn how to create a report that includes all the fields in a table or query.
The Report Wizard guides you through steps to create a report based on one or more tables or queries, enabling you to select which fields you want to include in the report. (The Report Wizard)
The various tools used to generate a report are often able to create most or all of the controls and layout for you. However, there are times when you will need to add controls manually. (The Report Design view, Report Sections (Headers, Detail, Footers), Controls)
Access provides numerous options to enhance the appearance of a report. For example, you can apply color themes and font styles, and add graphics to any band in a report design. (Themes, Add Images)
When you print a report, you may find that the report contains too much information to fit within a page. It is often necessary to adjust page setup and layout options when you first set up a report for printing. (Page Size, Margins, Print Preview)
Reports that use grouping or display summary information are easier to understand. In this topic, you will organize information this way. You'll expand upon simple report designs to create attractive, informative printouts. (Group, Sort, and Total Pane, Group Headers and Footers)
You may want to enhance a report's appearance. In this topic, you will format reports as well as control pagination. This results in a professional-looking report that captures the reader's attention. (Report Control Properties, Report Pagination, Keep Together Property, Force New Page Property)
SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.