If you have some experience with Access 2003 or earlier — a couple small databases or more — this course was written for you. Here are some suggested ways to practice what you saw in the course.
Important To follow these steps, you must have Access 2010 installed on your computer, and you need to be connected to the Internet.
Create a new, blank database
To follow these steps, you can use one of your own database schemas.
- Start Access 2010. It opens in Backstage view automatically.
- Click the New tab. The Blank Database template is already selected.
- On the right side of the tab, in the File Name box, enter a name for the new database.
- Optionally, click the folder icon located to the right of the File Name box.
That starts the File New Database dialog box, and you can use it to select another location for the database.
- Click Download.
The database opens and displays a blank table in Datasheet view, ready for you to add fields.
Add fields to a table
Access provides several ways to add fields to a table. Here are some of the most common.
- With the table open in Datasheet view, make sure you’re on the Fields tab (click it if you’re not).
- In the Add & Delete group, open the More Fields list.
- At the bottom of the list, under Quick Start, click Name.
- Click the blank field header to the right of the new fields (the words Click to Add), and then repeat step 4 to add the Address and Phone fields to your table.
- Right-click the blank field header (the words Click to Add), and from the list that appears, select Memo.
That sets the data type for the field and makes the field header writable.
- In the field header, enter Comments, then click outside the header to commit your changes.
Navigate the Navigation Pane
Note You need an internet connection to follow these steps. Start by downloading the Northwind sample database. To do that, click the New tab, and then click Sample Templates. Trust the database (on the yellow message bar, click Enable Content) and log in to the database.
- The Navigation Pane is closed in this template, so click the double arrow to open it.
- In the pane, click the Reports bar to expand that group.
Notice the group displays a set of shortcuts to the database objects. That’s how you know you’re looking at a custom category or group.
- Click the bar at the top of the pane (it reads Northwind Traders), and click Object Type. Now you’re looking at a list of the objects in the database.
- Click Forms, then right-click the Customer List form and click Layout View.
- Click the Tables group to expand it, and then double-click the Customers table.
- Right-click the bar at the top of the pane and click Search Bar.
To make the Search bar visible, repeat this step.
- With the Search bar visible, expand all the groups, and in the Search box, slowly enter customer. Notice how Access filters the list of objects as you type.
Navigate the ribbon
Try these steps with a database such as Northwind.
- Open a table in Datasheet view and note which contextual tabs appear, and explore those tabs to see the commands they provide.
- Open a query in Design view and note which contextual tabs appear. Explore the tabs to see the commands they provide.
- Open a form in Layout view and note which contextual tabs appear. Explore those tabs, too.
- With any database object open and the Home tab showing, press the ALT key.
A set of Key Tips appears.
Access provides a Key Tip for each ribbon tab, and a Key Tip for the commands on each tab.
- Press the ALT key again, and notice the Key Tips disappear.
- Press ALT+C to go to the Create tab.
Because you navigated to the Create tab from the Home tab, Access displays a set of Key Tips for every command on the Create tab.
- Press ALT yet again, and notice the Key Tips disappear.
- Now press ALT+C and notice the Key Tips for each command reappear.
If you accidentally close the Key Tips for a given tab, you can press ALT and the letter for that tab to see the Key Tips again.
- Press QD to start the query designer.
- With the query designer open, press ALT+H to go to the Home tab.
Notice how the Key Tips for disabled (gray) commands are also disabled.
Publish a web database
Start by downloading one of the web database templates, such as the Assets Web Database template. To do that, click the New tab, and then click Sample Templates. Trust the database (on the yellow message bar, click Enable Content) and log in to the database.
- In Backstage view, click the Save & Publish tab.
- Click Publish to Access Services.
- Click Run Compatibility Checker.
- Click Yes to close any open objects and let the Compatibility Checker run.
If the compatibility check finds no issues, or it only finds warnings, the database is ready to publish.
- Enter the URL of your server and a name for the site. Obtain the URL from your system administrator.
- Click Publish to Access Services.
You’ll need to wait for the publish process to finish, and for your server to finish processing your new site.
- Start your browser, go to the site, open the Current Assets form and enter some data.
Change a web database and save your changes to the web
- Open the Assets web database in Access.
- Open the Main form in Layout view.
- Right-click the Getting Started tab in the form and click Delete, then press CTRL+S to save your changes.
- Click the File tab to go to Backstage view.
- On the Info tab, click Sync All to write (save) your changes to the web.