|
|
This is only a preview of the paper
Click here to register and get the full text.
Existing members click here to login
|
|
|
Microsoft Access 2000
Practical 1
In this practical we will look at the basics of Microsoft Access. ...
Starting and Quitting Microsoft Access
To start Microsoft Access
Click on the Windows Start button; select Programs, then Microsoft Access.
Or, if displayed on the screen, double-click on the Microsoft Access icon.
To quit Microsoft Access
Choose Exit from the File menu.
Getting Help using Microsoft Access
There are many ways to get assistance when using Microsoft Access. Many of the help options are available through the Help menu or by selected the Microsoft Access Help button on the toolbar.
Access Wizards
When you create a new database, table, query, form or report, Microsoft Access displays a dialog box where you can choose whether to start with a blank object and build it yourself or use an Access Wizard to help you build it. An Access Wizard is like a database expert who prompts you with questions about the object you want and then builds the object based on your answers.
Activity P1-1
Practise using the Microsoft Access help facilities. ...
Opening a Database
A Microsoft Access database is a collection of objects, not just a single table of data. ...
When you first load Access, the Microsoft Access dialog box is displayed, as shown in Figure P1-1.
Figure P1-1: The Microsoft Access dialog box.
To Open a Database using Microsoft Access dialog box
To view existing databases select the Open an existing file option. ...
To Open a Database
If the Microsoft Access dialog box is not displayed choose Open from the File menu (or click the Open button on the toolbar). ... Microsoft Access provides sample databases in the C:Program FilesMicrosoft OfficeOfficeSamples folder.
The Database Window
When you create or open a database, Microsoft Access displays a Database window in the Microsoft Access window. ...
Figure P1-2: The Microsoft Access Database window for the Northwind database.
The object buttons in the Database window provide direct access to every object in your database. ... Microsoft Access displays the list of forms stored in the database. ...
Microsoft Access displays the table in Datasheet view. ... A dynaset is an updatable type of record set, which is any Microsoft Access set of records defined by a table or query that you can treat as an object. ... Microsoft Access displays the dynaset in datasheet view. ... Microsoft Access opens the form and displays the first record of data. ... To switch from Form view to Datasheet view, access the View menu and select Datasheet. ...
Creating a Database
When you create a Microsoft Access database, you create one file that contains all the tables in your database as well as the queries, forms, reports and other objects that help you use the information in the database.
Microsoft Access provides two methods to create a database. ... In the Microsoft Access startup window, choose New from the File menu. ... In the Microsoft Access startup window, choose New from the File menu. ...
Microsoft Access displays the New dialog box. ... Microsoft Access automatically appends a mdb extension to your database filename. ... Microsoft Access creates an empty database file and opens the Database window. ...
Create a Table
Microsoft Access provides three ways to create a blank (empty) table:
• Use the Database Wizard to create in one operation all the tables, forms and reports required for an entire database. ... When you save the new datasheet, Microsoft Access will analyse your data and automatically assign the appropriate data type and format for each field.
Approximate Word count = 2833
Approximate Pages = 11.3
(250 words per page double spaced)
|
|
|
|
|
|