You have selected free tutorial of the Microsoft Corporation for the Microsoft Office Specialist (MOS) :
77-424: Access 2013 Topics : Create and manage a database (20–25%) :
Navigate through a database •Navigate to specific records, set a form as the startup option, use navigation forms, set navigation options, change views
Introduction to queries (Access basics, part 3 )
Learn how to create queries in Access 2013. Course covers the types of queries, creating Select queries, criteria, joins, and intermediate tables
After creating or opening a new database, the Access screen will look similar to undernoted video 1st sna. Across the top of the screen is the Ribbon, On the left, you see the Navigation pane. These two components make up the bulk of the Access interface. In addition, you have at your disposal the Quick Access toolbar, which you can customize with the commands you use most frequently
The Navigation pane The Navigation pane, at the left of the screen, is your primary navigation aid when working with Access. The Navigation pane shows queries, forms, reports, and other Access object types. It can also display a combination of different types of objects. By default, the Navigation pane shows all objects in the current database. Select All Access Objects when you’ve been working with one of the filtered view and want to see every object in the database.
The navigation options are divided into two categories:
- Navigate to Category :you choose an option under Navigate to Category
- Filter by Group: choose an option under Filter by Group. The Filter by Group options you’re presented with depend on the Navigate to Category option you select.
Click the drop-down list in the Navigation pane’s title bar to reveal the navigation options
- Custom The Custom option creates a new tab in the Navigation pane. This new tab is titled Custom Group 1 by default and contains objects that you drag and drop into the tab’s area. Items added to a custom group still appear in their respective object type view, as described in the next bullet. When you select Custom, the Filter by Group category is populated with all the custom groups you’ve previously created. You can use the Filter by Group category to filter to any of the created custom groups. (Custom groups are a great way to group dissimilar objects (like tables, queries, and forms) that are functionally related. For example, you could create a Customers custom group and add all the database objects related to customer activities. Items contained in a custom group can appear in other groups as well.)
- Object Type The Object Type option is most similar to previous versions of Access. When you select Object Type, you have the following options under Filter by Group:
- All Access Objects
Your Salary Above $ 66000... Click ...
Ohh! You want More.... be game developer of your choice $ 102000 ....