RelationalDBDesign
SiteMap
Data Manipulation
Access Features
Building Access DB
Tables Queries
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Features
«Prev
Next»
Access Database
Database Features
Open Access Database
MS Access Window
Access Help System
Access Database Window
Access Interface Conclusion
MS Access Database
What is Database
What is Relational Database
Design Relational Database
How Data is stored
Access Database Objects
Database Analysis
Create Access Database
Steps For Creating Database
Design Tables Conclusion
Creating Access Table
Creating Access Tables
Access Datasheet
Edit Access Datasheet
MS Access Functions
Importing Data
Import Access Table
Building Modifying Forms
Table Manipulation
Table Design View
Field Data Types
Changing DataType
Use InputMask To Limit Data
Selecting Table Fields
Adding Deleting Fields
Creating Hyperlinks In Access Table
Edit Table Design By Moving Field
Understanding Primary Key
Access Table Manipulation Conclusion
Consulting Database - Exercise
Getting in and out of an Access database - Exercise
Open Access and the Consulting Database
Objective:
Open Access and the Consulting database.
This exercise is worth 2 points. The exercise is auto-scored, which means that all you have to do to receive credit for it is click the
Submit
button below. Place the Consulting_02 database in the My Documents (Windows 7 or 10) folder on your hard drive. These folders are normally Access's default save folder, which makes the database easy to find in the Open dialog box. If you have not yet downloaded the file, please return to the Module 1 Lesson, "What you need" and download it. Once you have moved the file follow these steps to complete the exercise:
Open Access by choosing Start>>Programs>>Microsoft Access.
Open an Existing Database should be selected, Click OK to display the Open dialog box.
If the contents of the My Documents or the Personal folder is not displayed, navigate to the folder.
Select the Consulting database (Consulting.mdb) and click the Open button to open the database.
Examine the toolbar--if you hold the pointer over a button, the name of the button appears in a tooltip. If you like, take some time while you are here to play with some of the buttons and menu options, you cannot hurt anything, and you may learn something.
Close the database by using the close button on the Database window.
Choose File>>Exit to Close Access.