Length: 2 days
Price: $550/person (USD)
Bundle & Save: View Bundle
Group Price: Request Quote
Live Instructor Teaching
Certificate of Completion
Free 6 Month Online Retake
Hands-On Learning?: Yes
Software Lab Included?: Yes
Individuals and Groups
@ Your Location
@ Your Organization
This 2-day course covers the basic skills and concepts students need to use Microsoft Access productively and efficiently. Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft Access can help you and your organization with this task. The Access - Level 1 Class focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access. For comprehensive certification training, students should complete the Level 1, 2 and 3 courses for Access.
In this course, you will create and manage an Access database.
Register Early: Registration Deadline is 2 Weeks Prior to Class Start.
Versions That Can Attend: Desktop Version of Office 2021, 365, 2019, 2016 (Microsoft Windows PC or Macintosh)
Course Taught With: Desktop Version of Office version 365/2019 (Microsoft Windows PC) Software and Courseware
This course is designed for students looking to establish a foundational understanding of Microsoft Access for Office 365/2019, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. You can obtain this level of skills and knowledge by taking the Windows for End Users Course.
Access - Level 2
Access - Level 3
MOS: Microsoft Access Expert Certification
This course is taught by a live instructor and is available in two class formats:
A Microsoft Access database is a computer application used to store and manipulate data. It is a part of the Microsoft Office suite of applications, which also includes Word, Excel, PowerPoint, and Outlook. Access is designed to work with data stored in other applications, such as Microsoft SQL Server or Oracle Database.
Access databases are often used to store data for small businesses or organizations. They can be used to track customer information, inventory, employee records, and more. Access databases can be created using the Access software application or by exporting data from another application, such as Excel.
Access databases are typically stored on a computer's hard drive, but they can also be stored on a network drive or on a removable storage device, such as a USB flash drive. When storing an Access database on a network drive or removable storage device, it is important to ensure that the file is properly backed up in case of data loss.
Tables are a database component in Microsoft Access that stores information in a structured format. Tables are the basis for all data stored in an Access database. All data in an Access database is stored in tables.
Tables consist of rows and columns, with each row representing a record, and each column representing a field. Fields can contain various types of data, such as text, numbers, or dates. Tables can be related to each other through relationships, which are used to link data from multiple tables together.
Microsoft Access queries are a powerful way to retrieve and manipulate data from your database. Queries can be used to find specific records, calculate summaries, or even create new tables and forms. With the right query, you can make working with your data much easier and more efficient.
Creating a query is simple: just specify the criteria you want to use and Access will do the rest. For example, you can use a query to find all the orders placed by a particular customer, or all the products in a certain category. You can even use queries to generate custom reports.
There are two main types of queries: Select and Action. Select queries are used to retrieve data from your database, while Action queries can be used to add, change, or delete data.
Microsoft Access forms are an essential part of the application. They provide a user-friendly way to enter, view, and edit data. Forms can also be used to create custom reports and queries.
When creating a form, you can choose from a variety of form templates, or you can create a custom form. Forms can be created in Layout view or Design view.
Layout view is a drag-and-drop interface that lets you quickly create a form. Design view gives you more control over the form's design, and is better suited for complex forms.
Once a form has been created, it can be customized to match your specific needs. For example, you can add or remove fields, change the layout of the form, and add graphics or other objects.
Forms are an essential part of Microsoft Access and can be used to make your application more user-friendly and efficient.
Microsoft Access reports are a great way to collect and present data. Reports can be used to show data in tabular, summary, or detail form. They can also be used to create charts and graphs. Reports can be printed or exported to other file formats.
Creating a report is easy with Microsoft Access. Simply select the fields you want to include in the report, and then choose a layout. Access will automatically generate the report. You can then print or export the report as needed.