Microsoft Office Tutorials and References
In Depth Information
Opening a Table
The two records you added, with ContractNum field values of 3020 and 3025,
now appear in the correct primary key order. The table now contains a total of
10 records, as indicated by the Current Record box at the bottom of the
datasheet. The Current Record box displays the number of the current record as well
as the total number of records in the table.
Each record contains a unique ContractNum value because this field is the
primary key. Other fields, however, can contain the same value in multiple records;
for example, note the two values of 3/1/2013 in the SigningDate field.
To close an open database
without exiting the Access
program, click the File
tab to display Backstage
view, and then click Close
3. If you are not continuing on to Session 1.2, click the Close button on the
program window title bar. Access closes the Contract table and the Belmont
database, and then the Access program closes.
Saving a Database
Unlike the Save buttons in other Office programs, the Save button on the Quick Access
Toolbar in Access does not save the active document (database) to your disk. Instead,
you use the Save button to save the design of an Access object, such as a table (as you
saw earlier), or to save datasheet format changes, such as resizing columns. Access does
not have a button or option you can use to save the active database.
Access saves changes to the active database to your disk automatically when you
change or add a record or close the database. If your database is stored on a removable
medium, such as a USB drive, you should never remove the drive while the database file
is open. If you do, Access will encounter problems when it tries to save the database,
which might damage the database.
Now that you’ve become familiar with database concepts and Access, and created
the Belmont database and the Contract table, Oren wants you to add more records to the
table and work with the data stored in it to create database objects including a query,
form, and report. You will complete these tasks in Session 1.2.