Save a database object

1. Click Save on the toolbar.
   
   
2. If you are saving a database object for the first time, type a name that follows Microsoft Access object-naming rules in the Save As dialog box, and then click OK. If you click Cancel in the Save As dialog box, the object is not saved.

Notes

• You don't need to save new data in records. Access automatically saves a record when you do any of the following: move the focus to a different record; close the active form, datasheet, data access page, or database; or quit Access.
  
  
• If you attempt to save a new query, and you receive an error that the name you entered already exists for another object, try using a different name. The database may contain queries that were created in Visual Basic for Applications (VBA) code with ActiveX Data Objects (ADO). Queries created with ADO do not appear in the Object list in the Database window.
  
  
• Learn more about saving changes to a shared Access database.